Latest versionsfixlist
11.1.0.6 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
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC70887 Status: Closed

CRASH OCCURS (-901 IN DB2DIAG.LOG) WHEN RUNNING SQL USING CONCAT OPERATOR
THAT INVOLVES LONG VARCHARS OR LOBS

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Running sql which contains CONCAT operator that involves long 
varchars or Lobs 
 
We received the following stacks: 
 
DB2 build information: DB2 v9.5.0.5 s091123 SQL09055 
timestamp: 2010-06-03-16.47.02.190787 
instance name: db2inst1.000 
EDU name     : db2agent (TEST) 0 
EDU ID       : 106144 
Signal #11 
 
.... 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x000000000000F498 ?unknown + 0x0 
0x0900000005713E74 
sqlrimso__FP8sqlrr_cbP9sqllf_csoPUcPUiUiisPPvT6 + 0xB40 
0x09000000064AD724 
sqlriWriteCsoIntoBuffer__FP8sqlrr_cbP9sqllf_csolPPvT3PUcPUlPl + 
0x508 
0x09000000064CB528 
sqlriPutLobLongDatalinksExecute__FP14db2UCinterfaceP10sqlz_value 
P7DDValue 
+ 0x2C8 
0x09000000064CB170 
sqlriPutLobLongDatalinksExecute__FP14db2UCinterfaceP10sqlz_value 
P7DDValue@glueB41 
+ 0x70 
0x09000000064D7874 sqlribnoCbDrda__FP14db2UCinterface + 0x450 
0x0900000004B7DB20 sqlribno__FP8sqlrr_cb - 0x2C 
Stack traceback unavailable. 
</StackTrace> 
 
 
db2diag.log file shows: 
2010-06-03-17.03.22.104880-300 I16618A842         LEVEL: Severe 
PID     : 11501682             TID  : 107686      PROC : db2sysc 
0 
INSTANCE: db2inst1           NODE : 000         DB   : TEST 
APPHDL  : 0-88                 APPID: 
127.0.0.1.33993.100603220326 
AUTHID  : USER123 
EDUID   : 107686               EDUNAME: db2agent (TEST) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 22 
 sqlerrmc: sqlrimso: bad LSE type 
 sqlerrp : SQLRI08C 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFE3E      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate:
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* CRASH OCCURS (-901 IN DB2DIAG.LOG) WHEN RUNNING SQL          * 
* USINGCONCATOPERATOR THAT INVOLVES LONG VARCHARS OR           * 
* LOBSRunning sql which contains CONCAT operator that          * 
* involveslongvarchars or LobsWe received the following        * 
* stacks:DB2 build information: DB2 v9.5.0.5 s091123           * 
* SQL09055timestamp: 2010-06-03-16.47.02.190787instance name:  * 
* db2inst1.000EDU name    : db2agent (TEST) 0EDU ID      :     * 
* 106144Signal #11....<StackTrace>-------Frame------           * 
* ------Function + Offset------0x000000000000F498 ?unknown +   * 
* 0x00x0900000005713E74sqlrimso__FP8sqlrr_cbP9sqllf_csoPUcPUiUii 
* +                                                            * 
* 0xB400x09000000064AD724sqlriWriteCsoIntoBuffer__FP8sqlrr_cbP9s 
* 0x2C80x09000000064CB170sqlriPutLobLongDatalinksExecute__FP14db 
* 0x700x09000000064D7874 sqlribnoCbDrda__FP14db2UCinterface    * 
* +0x4500x0900000004B7DB20 sqlribno__FP8sqlrr_cb - 0x2CStack   * 
* traceback unavailable.</StackTrace>db2diag.log file          * 
* shows:2010-06-03-17.03.22.104880-300 I16618A842              * 
* LEVEL:SeverePID    : 11501682            TID  : 107686       * 
* PROC :db2sysc0INSTANCE: db2inst1          NODE : 000         * 
* DB  : TESTAPPHDL  : 0-88                                     * 
* APPID:127.0.0.1.33993.100603220326AUTHID  : USER123EDUID  :  * 
* 107686              EDUNAME: db2agent (TEST) 0FUNCTION: DB2  * 
* UDB, relation data serv, sqlrr_dump_ffdc,probe:300DATA #1 :  * 
* SQLCA, PD_DB2_TYPE_SQLCA, 136 bytessqlcaid : SQLCA           * 
* sqlcabc: 136  sqlcode: -901  sqlerrml: 22sqlerrmc: sqlrimso: * 
* bad LSE typesqlerrp : SQLRI08Csqlerrd : (1) 0x00000000       * 
* (2) 0x00000000      (3)0x00000000(4) 0x00000000      (5)     * 
* 0xFFFFFE3E      (6)0x00000000sqlwarn : (1)      (2)      (3) * 
*      (4)        (5)      (6)(7)      (8)      (9)      (10)  * 
*       (11)sqlstate:                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.5 Fix Pack 7.                   * 
****************************************************************
Local Fix:
available fix packs:
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
Problem first fixed in DB2 UDB Version 9.5 Fix Pack 7
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC71073 IC71602 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
01.09.2010
15.11.2010
15.11.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP7
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.7 FixList
9.5.0.7 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.