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

Hi,
The problem got resolved by compiling stored procedures in 64 bit mode..

gcc use option -maix64
xlC -q64


Thanks
Sridhar