Saturday, September 18, 2004

Errors After A Redirected Restore!

ADM1814E The current log path
"/ PATH/NODE0000/" is invalid.

ADM1811E DB2 will now switch to the default log path
"/PATH/NODE0000/SQL00004/SQLOGDIR/".

Whether you are restoring to a different machine or on the same machine never forget to change the NEWLOGPATH Database Parameter. If you don’t DB2 will switch to default log path. This will not be an issue if you are using default log path.

DB2 was unable to confirm logs were archived.
Return code 118489304, FirstArchNum 31953, HeadExtentID 31958

An error was received from the user exit program.
0x2FF21508 : 0x0000001C ....

Userexit program maintains a log which is more informative than the above and it will be in the files named USEREXIT.ERR & ARCHIVE.LOG, you should be able to find that in the LOGPATH.

You have to act based on that.

In my case I have to create a directory for the new database so that it can archive the logs.

This message keeps coming up sometimes after a redirected restore and not sure what it means… Help me!

SQL procedure executables recovery has been initiated. DBNAME
0x2FF1E330 : 0x4341535342202020

SQL procedure executables recovery ended. RC:
0x2FF1E310 : 0x00000000

No comments: