userexit program on Windows

[joephilip]

We are running DB2 UDB v8.1 on Windows 2003.

We are keep getting an error in the db2diag.log saying that
"The user exit program returned an error when archiving log file S0000000.LOG from E:\psft\dev\logs\NODE0000 for database dev. The error code was 8."

I checked the error code for 8, and it says that "operator intervention is needed."

My question is that: how do I know which logpath is this \sqllib\bin\db2uext2.exe is utilizing. Since it is a binary file, I can not open it and find out anything. If it logs an error, where does it log to?

 

[ifxtechie]

Hi JoePhilip,
First thing,
if you have not modified the db2uext2.exe, you need to copy the db2uext2.tape file and rename it to db2uext2.c and compile to get the executable file.
Before compiling, copy that file to another directory. Then, edit for the LOGPATH. That program is self-explanatory i.e. if you read first 20 lines you will know what changes need to be done. Only 2 parameters need to be changed.
#define ARCHIVE_PATH "c:\\joePhp\\DB2\\bkp\\archive\\"
#define RETRIEVE_PATH "c:\\Joephp\\DB2\\bkp\\"

Once you get the executable file, put that into SQLLIB/bin directory.
Then restart the database. Then you don't see any errors.
If you still have any problems, let me know.
Hope this helps.
ifxtechie