|
Problem IC70530
|
Status: Closed |
A query involving large objects fails with SQL0901 with Reason: "SQLRIMSO: NULL MATPOSSTRUCT" |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If application is fetching large LOBS, bigger then 128K in size,
it can run into above error on the database server.
Please, apply this APAR to correct the issue.
SQL0901N will generate stack similar to this:
sqlrimso
sqlriWriteCsoIntoBuffer
sqlriExtDtaGetNextChunk
sqlrrProcessGetNextChunk
sqlrrGetNextChunk
db2diag.log on the database server will have entry similar to
this:
2010-07-28-17.19.21.638537-300 I68024A529 LEVEL: Severe
PID : 3236028 TID : 24161 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :
ICMNLSDB
APPHDL : 0-132 APPID:
*LOCAL.db2inst1.100728221725
AUTHID : DB2INST1
EDUID : 24161 EDUNAME: db2agent (ICMNLSDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:400
...skipping...
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 27
sqlerrmc: sqlrimso: NULL matPosStruct
sqlerrp : SQLRI08C
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFDDC (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* LOBs *
****************************************************************
* PROBLEM DESCRIPTION: *
* If application is fetching large LOBS, bigger then 128K *
* insize,it can run into above error on the database *
* server.Please, apply this APAR to correct the issue.SQL0901N *
* will generate stack similar to *
* this:sqlrimsosqlriWriteCsoIntoBuffersqlriExtDtaGetNextChunksql
* on the database server will have entry *
* similartothis:2010-07-28-17.19.21.638537-300 I68024A529 *
* LEVEL:SeverePID : 3236028 TID : 24161 *
* PROC :db2sysc0INSTANCE: db2inst1 NODE : 000 *
* DB :ICMNLSDBAPPHDL : 0-132 *
* APPID:*LOCAL.db2inst1.100728221725AUTHID : DB2INST1EDUID : *
* 24161 EDUNAME: db2agent (ICMNLSDB) 0FUNCTION: *
* DB2 UDB, relation data serv, *
* sqlrr_dump_ffdc,probe:400...skipping...DATA #1 : SQLCA, *
* PD_DB2_TYPE_SQLCA, 136 bytessqlcaid : SQLCA sqlcabc: 136 *
* sqlcode: -901 sqlerrml: 27sqlerrmc: sqlrimso: NULL *
* matPosStructsqlerrp : SQLRI08Csqlerrd : (1) 0x00000000 *
* (2) 0x00000000 (3)0x00000000(4) 0x00000000 (5) *
* 0xFFFFFDDC (6)0x00000000sqlwarn : (1) (2) (3) *
* (4) (5) (6)(7) (8) (9) (10) *
* (11)sqlstate: *
****************************************************************
* RECOMMENDATION: *
* Apply this APAR *
**************************************************************** |
| Local Fix: |
Avoid fetching entire LOB in one api call. Change application to
fetch LOB in smaller chunks then 128K. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
If application is fetching large LOBS, bigger then 128K in
size,
it can run into above error on the database server.
Please, apply this APAR to correct the issue.
SQL0901N will generate stack similar to this:
sqlrimso
sqlriWriteCsoIntoBuffer
sqlriExtDtaGetNextChunk
sqlrrProcessGetNextChunk
sqlrrGetNextChunk
db2diag.log on the database server will have entry similar to
this:
2010-07-28-17.19.21.638537-300 I68024A529 LEVEL: Severe
PID : 3236028 TID : 24161 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :
ICMNLSDB
APPHDL : 0-132 APPID:
*LOCAL.db2inst1.100728221725
AUTHID : DB2INST1
EDUID : 24161 EDUNAME: db2agent (ICMNLSDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:400
...skipping...
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 27
sqlerrmc: sqlrimso: NULL matPosStruct
sqlerrp : SQLRI08C
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFDDC (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.08.2010
30.09.2010
30.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
