I do not change anything to db2uext2.c. I try to use C compiler to compile it to get the db2uext2.exe to put it in the BIN directory. However, when I compiled it, C complier gave a lot of error. I compiled different db2uext2.c files but it gave me the same errors.

I compiled by issuing: cc -o db2uext2 db2uext2.c
I think the problem comes because of library links in C
There for I could not get the executable file.

Please help me out with this problem. Thanks a lot for this

The error is:
113: warning: invalid white space character in directive
"db2uext2.c", line 114: warning: invalid white space character in directive
"db2uext2.c", line 115: warning: invalid white space character in directive
"db2uext2.c", line 345: invalid source character: '\'
"db2uext2.c", line 346: syntax error before or at: ErrorLog
"db2uext2.c", line 569: syntax error before or at: unsigned
"db2uext2.c", line 587: undefined symbol: fileToArchive
"db2uext2.c", line 587: warning: improper pointer/integer combination: arg #1
"db2uext2.c", line 588: undefined symbol: archiveTargetName
"db2uext2.c", line 588: warning: improper pointer/integer combination: arg #1
"db2uext2.c", line 621: undefined symbol: systemCallRc
"db2uext2.c", line 628: undefined symbol: tempFp
""db2uext2.c", line 681: undefined symbol: _O_BINARY
"db2uext2.c", line 681: undefined symbol: _O_RDONLY
"db2uext2.c", line 687: undefined symbol: rc
"db2uext2.c", line 691: undefined symbol: _S_IREAD
"db2uext2.c", line 691: undefined symbol: _S_IWRITE
"db2uext2.c", line 693: undefined symbol: _O_WRONLY
"db2uext2.c", line 693: undefined symbol: _O_CREAT
"db2uext2.c", line 693: undefined symbol: _O_TRUNC

In AIX , for db2 8.1.x(I think) I used

/usr/vac/bin/cc -o db2uext2 db2uext2.c /usr/tivoli/tsm/client/api/bin/libApiDS.a -I/usr/tivoli/tsm/client/api/bin/sample
/usr/vac/bin/cc -q64 -o db2uext2 db2uext2.c /usr/tivoli/tsm/client/api/bin64/libApiTSM64.a -I/usr/tivoli/tsm/client/api/bin64/sample


for 32bit and 64bit db2. For 8.2 you do not need to create db2uext2. You have to use the db config properly to indicate you are using db2uext2.

Hi mota,
Thanks for suggestion with TSM. I do not use TSM now,but I will use that next month.

I am using version 8.2. If I do not create db2uext2, how can I identify the location of archived logs that userexit program will copy from C:\DB2CTLSV\NODE0000\SQL00003\SQLOGDIR? I already turned userexit ON and LOGARCHMETH1 = USEREXIT.


What I mean is where I can find the archvied log files that userexit copies from log directory that contains active logs and archived logs.

I appreciate your help

Khanh Nguyen.

if you set logarchmeth1(database configuration parameter) to DISK:/u/dbuser/archived_logs the archive log files will be placed in a directory called /u/dbuser/archived_logs.This is for unix. For Windows it will be like
DISK:C:\ARCHLOGDESTINATION. You find this info in Data Recovery and High Availability Guide and Reference.

Everything likes you said. I tried both on DISK and TSM.

Best

Khanh Nguyen