var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: UserExit problem.
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:
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.
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,
Originally Posted by 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.
Did you set "LOG_RETAIN_STATUS = Yes" too?
accourding the article , I did not change logretain (db cfg) to recovery.
Originally Posted by dsusendran