UserExit succeeded manully but failed when loaded automatically by DB2

[Guoping Jiang]

Hi,

We have a DB2 UDB v7.2 (with Fixpak 6) database (named, say, PRODDB)
running on a RS/6000 machine (pSeries) with AIX 5.2 (Maintenance Level
1). The database is not partitioned. Both LOGRETAIN & USEREXIT are
turned on.

I have compiled the sample userexit program db2uext2.c(disk) and put
it under
${INSTANCE_HOME}/sqllib/adm
and also made the following softlink (just to make sure)
${INSTANCE_HOME}/sqllib/bin/db2uext2 ->
${INSTANCE_HOME}/sqllib/adm/db2uext2.

I do not have a problem to manully archive log files by running the
program:

../db2uext2 -OSAIX -RLSQL07024 -RQARCHIVE -DBPRODDB \
-NNNODE0000 -LP"/onlinelogs/" -LNS0000000.LOG
However, it failed when DB2 automatically loaded it. And the following
error message was found in db2diag.log:

------------------------------------------------------------
2004-07-08-21.45.45.141664 Instance:db2inst1 Node:000
PID:1142976(db2cart) Appid:none
data_protection sqlpgart Probe:490

DB2 not able to execute User Exit program when archiving log file
S0000000.LOG from /onlinelogs/ for database PRODDB, error code 255

Please verify User Exit program by manually running it.
------------------------------------------------------------

I suspect that DB2 failed in loading some library. And the problem is
environment-related (such as LIBPATH, etc).

Could anyone give me some light to solve the problem?

Thanks in advance,

Guoping Jiang