home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC70887 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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:
verfügbare FixPacks:
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

Lösung
Problem first fixed in DB2 UDB Version 9.5 Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC71073 IC71602 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.09.2010
15.11.2010
15.11.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP7
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList