UserExit problem.

M_RAS · #1 (**permalink**) 08-18-04, 11:37

I am working with db2 v7 fix 6 aix 4.3.3
I decided to use UserExit=on for our environment for online backup and I did step by step accourding this article:

http://www-106.ibm.com/developerwork...0307kline.html
Unfortunately db2uext2 does not work. I do not have any logs in /mylogs/db_name/NODE0000.

and in db2diag.log I get :
DB2 not able to execute User Exit program when archiving log file S0000000.LOG from /database/db2v7i1/NODE0000/SQL00001/SQLOGDIR/ fo
r database db_name error code 255.

Plesae help.

Thanks

nkelly · #2 (**permalink**) 08-18-04, 12:46

Hello M,

Do you have log files in the userexit log path /mylogs such as USEREXIT.ERR, ARCHIVE.LOG and dsierror.log? Did you chmod 700 db2uext2? Who owns it?

If you have no logs I would suggest replacing the db2uext2 with a shell script just to diagnose if the db2uext2 is being called correctly. Create a shell script containing something like this:

echo $* >> /tmp/userexit.out (to check parameters passed)
set >> /tmp/userexit.out (to check the DB2 envinonment)

Hope this helps,
NK.

M_RAS · #3 (**permalink**) 08-18-04, 13:52

Quote:

Originally Posted by nkelly

Hello M,

Do you have log files in the userexit log path /mylogs such as USEREXIT.ERR, ARCHIVE.LOG and dsierror.log? Did you chmod 700 db2uext2? Who owns it?

If you have no logs I would suggest replacing the db2uext2 with a shell script just to diagnose if the db2uext2 is being called correctly. Create a shell script containing something like this:

echo $* >> /tmp/userexit.out (to check parameters passed)
set >> /tmp/userexit.out (to check the DB2 envinonment)

Hope this helps,
NK.

Hi Nkelly,
I chmod to 777 and I do not have any logfiles, unfortunatly I do not undrestand what you meant about script, could you please tell me more detail or give me a sample.

Thanks again