Results 1 to 7 of 7

Thread: AIX PRocs

  1. #1
    Join Date
    Mar 2002
    Posts
    17

    Unanswered: AIX PRocs

    does anyone have working SQL Stored Procs on AIX. I have a problem linking them(during creation). Can't find/create the .exp file required for linking.
    Thanks

  2. #2
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    24
    elaborate your problem further...
    You hv to place Stored procedure on AIX server in ASCII format... Check it...



    Regards,
    Riaz Sattar

  3. #3
    Join Date
    Mar 2002
    Posts
    17
    OK. I have these procedures working on DB2 on NT and would like to compile them on the AIX server (with DB2) using the Procedure Builder and I get this error. It looks its failing on linking.

    - Create stored procedure returns -7032.

    :
    *** BIND /home/db2inst1/sqllib/function/routine/sqlproc/KEYLARGO/KEYLARGO/tmp/P2640430.sqc ***

    LINE MESSAGES FOR P2640430.sqc
    ------ --------------------------------------------------------------------
    SQL0060W The "C" precompiler is in progress.
    SQL0091W Precompilation or binding was ended with "0"
    errors and "0" warnings.

    *** COMPILE /home/db2inst1/sqllib/function/routine/sqlproc/KEYLARGO/KEYLARGO/tmp/P2640430.c ***

    db2set DB2_SQLROUTINE_COMPILER_PATH=/usr/bin/cc
    db2set DB2_SQLROUTINE_COMPILE_COMMAND=xlC_r -+ -H512 -T512 -I/home/db2inst1/sqllib/include SQLROUTINE_FILENAME.c -e -bEQLROUTINE_FILENAME.exp -e SQLROUTINE_ENTRY -o SQLROUTINE_FILENAME -L/home/db2inst1/sqllib/lib -lc -ldb2

    SQLROUTINE_FILENAME=P2640430
    export SQLROUTINE_FILENAME
    export SQLROUTINE_ENTRY=pgsjmp

    xlC -I/home/db2inst1/sqllib/include P2640430.c -bE:P2640430.exp -e pgsjmp -o P2640430 -L/home/db2inst1/sqllib/lib -lc -ldb2

    *** /home/db2inst1/sqllib/function/routine/sqlproc/tmp/P2640430.exp ***
    pgsjmp

    DB2SET processing complete, rc = -4400, SQLCODE = 0
    DBI1302E Invalid parameter detected.

    Explanation: An invalid parameter was used.

    User Response: Use the -? option for the usage help message.


    ld: 0706-006 Cannot find or open library file: -l m
    ldpen(): A file or directory in the path name does not exist.

    ----------------------------------------------------------------------------

    SQL7032N SQL procedure "XXXX" not created. Diagnostic
    file is "P2640430.log". SQLSTATE=42904



    - Changes rolled back.

    - Build failed.

  4. #4
    Join Date
    Oct 2001
    Posts
    68
    Hi there,

    You are missing the AIX development math library libm.a which is not included in a base AIX 4.3.3 installation.

    Code:
    # cd /usr/lib
    # ls -l libm*
    lrwxrwxrwx   1 bin      bin           19 Sep 18 2001  libm.a -> /usr/ccs/lib/lib
    m.a
    lrwxrwxrwx   1 bin      bin           21 Sep 18 2001  libm_r.a -> /usr/ccs/lib/l
    ibm_r.a
    lrwxrwxrwx   1 bin      bin           22 Sep 18 2001  libmsaa.a -> /usr/ccs/lib/
    libmsaa.a
    lrwxrwxrwx   1 bin      bin           24 Sep 18 2001  libmsaa_r.a -> /usr/ccs/li
    b/libmsaa_r.a
    Use smit install_update and search for libm then install from the AIX 4.3.3 CDROM. You should get the following then:

    Code:
    # lslpp -L | grep libm
      bos.adt.libm               4.3.3.0    C    Base Application Development
    #
    WP

    DB2/UDB, AIX, NT, OS/390

  5. #5
    Join Date
    Mar 2002
    Posts
    17
    Thanks, I will check it and let you know.

  6. #6
    Join Date
    Mar 2002
    Posts
    17
    Thanks a million times. That was like what the Doctor ordered. Keep well.

  7. #7
    Join Date
    Oct 2001
    Posts
    68
    You're welcome Musa. If you need any more help using DB2/UDB on AIX let me know.

    WP.

Posting Permissions

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