Restore failed with SQL0901N

[Former Member]

Hello everyone,

today i tried to restore a System. It was running until the restore stopped with the following error code

SQL0901N The SQL statement failed because of a non-severe system error.

Subsequent SQL statements can be processed. (Reason "1130".) SQLSTATE=58004

Any ideas what might be the problem?

Thanks in advance

Marco

[paul_power]

Hi Marco,

What was the exact command used to perform the restore?

Did the same command work previously?

What was the exact entry from the db2diag at this time?

Please ensure to display the entry as code so it gets displayed correctly.

What is your db release and fixpack level?

Regards,

Paul

[Former Member]

Hi,

the exact command was

L:\db2\db2ksf\db2_software\BIN>db2 restore db KSF from \\... taken at '20100301200054' replace existing 

when i was runnin list utilities show detail the restore was running. until it stopped with the error message (after 460GB)

the db2 level is 9.7 fixpack 0.

[Former Member]

i think i solved the problem, the restore had a problem accessing the backup files.

[Former Member]

I am facing the same problem , what was the issue with the backup ? We use disk mirroring and db2relocatedb and getting same error SQL0901N during the bind against the syscat.tables. Any help will be highly appreciated.