Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2006
    Posts
    4

    Unanswered: Urgent Help with USEREXT

    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

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    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.
    mota

  3. #3
    Join Date
    Mar 2006
    Posts
    4
    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.

  4. #4
    Join Date
    Sep 2003
    Posts
    237
    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.
    mota

  5. #5
    Join Date
    Mar 2006
    Posts
    4

    Thanks Mota a lot

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

    Best

    Khanh Nguyen

Posting Permissions

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