When using the Restore Wizard to Restore to a new database I get
Quote:
An unexpected system error occurred.
sqlcode : -1042
sqlstate : 58004
|
When I Enable containter redirection and then click on the image timestamp.
The db2diag has about a dozen errors in it along the lines of
Quote:
2006-11-22-10.18.41.596000+600 I11215579H466 LEVEL: Severe
PID : 1644 TID : 4832 PROC : db2syscs.exe
INSTANCE: SOL NODE : 000 DB : ECHIDNA
APPHDL : 0-1040 APPID: *LOCAL.SOL.061122001841
FUNCTION: DB2 UDB, base sys utilities, sqlescln, probe:24
DATA #1 : String, 22 bytes
sqlm_d_exit is failed.
DATA #2 : Hexdump, 4 bytes
0x28556F6C : 0100 0000 ....
2006-11-22-10.18.41.940000+600 I11216047H434 LEVEL: Error
PID : 1644 TID : 4832 PROC : db2syscs.exe
INSTANCE: SOL NODE : 000 DB : ECHIDNA
APPHDL : 0-1041 APPID: *LOCAL.SOL.061122001842
FUNCTION: DB2 UDB, data protection, sqlpgint, probe:520
MESSAGE : DBCON SEED
DATA #1 : Hexdump, 4 bytes
0x280681D4 : E003 5844 ..XD
2006-11-22-10.18.41.940000+600 I11216483H159 LEVEL: Error
PID:1644 TID:4832 NODE:000 Title: SQLP_LFH
Dump File:C:\PROGRA~1\IBM\SQLLIB\SOL\16444832.000
|
Now, ECHIDNA is an already existing DB, but it doesn't happen with all DB's that exist in the catalog.
Anyone any ideas?
What I want to do is use the GUI to restore a production DB OVER a test DB at regular intervals. It needs to be GUI because I need to hand over to someone who doesn't want to get into scripts :/
Cheers
dBforums
>
Unexpected System Error when using "Restore to new DB"
11-21-06, 18:33
Linear Mode
