Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    16

    Unanswered: 64 bit - (DB28.1 + FP4a AIX 5.2)Stored procedure Excution Issue

    Hi,

    We are in the process of certifying our product on db28.1 + fp4a on AIX 5.2 64 bit.We have deployed 64 bit db2 software too.However when we try executing stored procedures we are getting following error.

    SQL0444N Routine "*T_SCHEMA" (specific name "SQL040622170700546") is
    implemented with code in library or path "...sqlproc/SAM/DB2INST2/P7070052",
    function "pgsjmp" which cannot be accessed. Reason code: "5". SQLSTATE=42724.

    Everything works fine on 32 bit os and db software..

    Also db2diag.log throws following error

    .0509-022 Cannot load module /home/db2inst2/sqllib/function/routine/sqlproc/SAM/DB2INST2/P7070052...0509-124 The program is a discontinued 64-bit object file.

    Any help on this would immensly help us..


    Regards
    Sridharan.T

  2. #2
    Join Date
    Jul 2003
    Posts
    16
    Hi,
    The problem got resolved by compiling stored procedures in 64 bit mode..

    gcc use option -maix64
    xlC -q64


    Thanks
    Sridhar

Posting Permissions

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