|
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
|
 |
| 9.5.0.7
|
|
