home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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)