Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC65084 Status: Closed

INSTANCE CRASH WHILE CALLING A STORED PROCEDURE FROM PERL APPLICATION

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Calling a stored procedure from a Perl application resulted in 
64 bit instance crash. 
 
Callstack of the Trap generated: 
_Z29sqljsHandleNotSupportSqlArrayP14db2UCinterfaceP14dataDescrip 
tor + 0x0042 
_Z18sqljsPrepDescReplyP13sqljsDrdaAsCbP14db2UCinterfacei + 
0x006f 
_Z23sqljsDrdaAsCBCompletionP14db2UCinterfacei + 0x0201 
_Z21sqlrr_rds_common_postP14db2UCinterfaceiil + 0x06b2 
...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who are at DB2 V9.5 FP5 or before are affected.        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Calling stored procedure from Perl application resulted in   * 
* crash in 64 bit instance.                                    * 
* The following error messages are seen from db2diag.log file: * 
*                                                              * 
* 2009-12-07      LEVEL: Error                                 * 
* PID    : nnnnn                TID  : mmmmmmmmm PROC :        * 
* db2sysc 1                                                    * 
* INSTANCE: db2inst1            NODE : 001          DB  : test * 
*                                                              * 
* APPHDL  : 1-8230              APPID: XXXX.XXX.XXXXXXXX       * 
*                                                              * 
* AUTHID  : NAME                                               * 
*                                                              * 
* EDUID  : 18183                EDUNAME: db2agent (test) 1     * 
*                                                              * 
* FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,    * 
* probe:1                                                      * 
* MESSAGE : Error in agent servicing application with          * 
* coor_node:                                                   * 
* DATA #1 : Hexdump, 2 bytes                                   * 
*                                                              * 
* 0x0000002B5440FA52 : 0100                                    * 
*                                                              * 
*                                                              * 
*                                                              * 
* .....                                                        * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2009-12-07-06.34.03.575793-300 I5199288E582        LEVEL:    * 
* Error                                                        * 
* PID    : nnnnn                TID  : mmmmmmmmm PROC :        * 
* db2sysc 1                                                    * 
* INSTANCE: db2inst1 NODE : 001          DB  : test            * 
*                                                              * 
* APPHDL  : 1-8230              APPID: XXXX.XXX.XXXXXXXX       * 
*                                                              * 
* AUTHID  : NAME                                               * 
* EDUID  : 18183                EDUNAME: db2agent (test) 1     * 
*                                                              * 
* FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,    * 
* probe:9                                                      * 
* MESSAGE : Error in agent servicing application with PRODUCT  * 
* SIGNATURE:                                                   * 
* DATA #1 : Hexdump, 8 bytes                                   * 
*                                                              * 
* 0x0000000200CC2600 : 5351 4C30 3830 3235                     * 
*    SQL08025                                                  * 
*                                                              * 
*                                                              * 
* 2009-12-07-06.34.03.575898-300 I5199871E581        LEVEL:    * 
* Error                                                        * 
* PID    : nnnnn                TID  : mmmmmmmmm PROC :        * 
* db2sysc 1                                                    * 
* INSTANCE: db2inst1 NODE : 001          DB  : test            * 
* APPHDL  : 1-8230              APPID: XXXX.XXX.XXXXXXXX       * 
*                                                              * 
* AUTHID  : NAME                                               * 
* EDUID  : 18183                EDUNAME: db2agent (test) 1     * 
*                                                              * 
* FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,    * 
* probe:10                                                     * 
* MESSAGE : Error in agent servicing application with          * 
* APPLICATION NAME:                                            * 
* DATA #1 : Hexdump, 7 bytes                                   * 
*                                                              * 
* 0x0000000200CC25D6 : 7065 726C 352E 38                       * 
*    perl5.8                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* To resolve the issue, please upgrade to DB2 V9.5 Fixpack 6   * 
* or above.                                                    * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
The fix is contained in DB2 V9.5 Fixpack 6 or above.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC65757 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.12.2009
27.09.2010
27.09.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)