We have udb ver 8.1 on aix and want to turn on USEREXIT to archive logs on tsm server.
In sample/c folder I see a program called db2uext2.ctsm
I changed the /u folder to 'instance home dir' and
DSMI_DIR, DSMI_CONFIG, DSMI_LOG entries are made in db2 profile.
Compiled the program and put it in sqllib/adm directory.
I can do full backup on TSM server.
but its not archiving the logs to tsm using db2uext2.ctsm program.
Does anyone know what to change in this db2uext2.ctsm file in order to archive it properly on tsm server. The programs documentation is little confusing.
Also how do I clean up the archieved logs? or does db2 take care of deleting these logs.
There should be a file called dsierror.log in $DSMI_LOG. This will show any low level API errors.
To check that userexit is being invoked correctly and that your DB2 has the correct environment, you could create a shell script called db2uext to replace the binary you compiled containing something like :-
echo $* >> /tmp/userexit.out
set >> /tmp/userexit.out
The issue a 'db2 archive log for db xxx' and check /tmp/userexit.out