|
Problem IC71073
|
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 / 970 - 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 *
****************************************************************
* PROBLEM DESCRIPTION: *
* CRASH OCCURS (-901 IN DB2DIAG.LOG) WHEN RUNNING SQL USING *
* CONCAT OPERATOR THAT INVOLVES LONG VARCHARS OR LOBS *
* *
* Stack shows: *
* 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_val
* P7DDValue *
* *
* + 0x2C8 *
* *
* 0x09000000064CB170 *
* *
* sqlriPutLobLongDatalinksExecute__FP14db2UCinterfaceP10sqlz_val
* 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) *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 9.7 Fix Pack 4 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 4. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.09.2010
02.05.2011
02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
