Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    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:

    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

  2. #2
    Join Date
    May 2004
    Posts
    8
    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.

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    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

  4. #4
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Talking

    Did you set "LOG_RETAIN_STATUS = Yes" too?

    Newbie

  5. #5
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by dsusendran
    Did you set "LOG_RETAIN_STATUS = Yes" too?

    Newbie
    accourding the article , I did not change logretain (db cfg) to recovery.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •