|
Problem IC90421
|
Status: Closed |
DB2 query might produce SQL0901N with "SECTION LENGTH MISMATCH" |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 query might produce SQL0901N with "SECTION LENGTH MISMATCH"
A diaglog entry similar to this will be produced:
2013-02-12-10.30.47.848780-300 I4293495E852 LEVEL: Severe
PID : 14237 TID : 140737010198272PROC
:db2sysc 0
INSTANCE: instname NODE : 000 DB : dbname
APPHDL : 0-502 APPID: appid
AUTHID : authid EDUID : 45 EDUNAME:
db2agent
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: 23
sqlerrmc: Section length mismatch
sqlerrp : SQLRA01B
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)0x00000000
(4) 0x00000000 (5) 0xFFFFFEA2 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Stack Trace will show these functions:
<StackTrace>
sqlra_cache_fill_sec
sqlra_find_sect
sqlra_get_section
sqlrr_sql_request_pre
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2FORLUW Version 9.7 *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 query might produce SQL0901N with "SECTION LENGTH *
* MISMATCH" *
* *
* A diaglog entry similar to this will be produced: *
* *
* 2013-02-12-10.30.47.848780-300 I4293495E852 LEVEL: *
* Severe *
* PID : 14237 TID : 140737010198272PROC *
* :db2sysc 0 *
* INSTANCE: instname NODE : 000 DB : *
* dbname *
* APPHDL : 0-502 APPID: appid *
* AUTHID : authid EDUID : 45 EDUNAME: *
* db2agent *
* 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: 23 *
* sqlerrmc: Section length mismatch *
* sqlerrp : SQLRA01B *
* sqlerrd : (1) 0x00000000 (2) 0x00000000 *
* (3)0x00000000 *
* (4) 0x00000000 (5) 0xFFFFFEA2 (6) *
* 0x00000000 *
* sqlwarn : (1) (2) (3) (4) (5) *
* (6) *
* (7) (8) (9) (10) (11) *
* sqlstate: *
* *
* Stack Trace will show these functions: *
* *
* <StackTrace> *
* sqlra_cache_fill_sec *
* sqlra_find_sect *
* sqlra_get_section *
* sqlrr_sql_request_pre *
* </StackTrace> *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 FP9 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.02.2013
16.12.2013
16.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
