DB2 - Problembeschreibung
Problem IC69111 | Status: Geschlossen |
Static SQL fails with -901 (reason: cached_sectptr is NULL) afte rpackage cache is full. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
A static SQL fails with -901 (reson: cached_sectptr is NULL), and subsequent statements fails with -901 (reson: Section not loaded) until the database is recycled. a) A static SQL fails with SQL0901N, reason code "cached_sectptr is NULL". 2010-05-19-00.02.24.137939+540 I35917317A844 LEVEL: Severe PID : 1437794 TID : 30201 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 007 DB : SAMPLE APPHDL : 7-22141 APPID: *N0.db2inst1.100521114854 AUTHID : DB2INST1 EDUID : 30201 EDUNAME: db2agent (SAMPLE) 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: cached_sectptr is NULL sqlerrp : SQLRA136 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFC4A (6) 0x00000007 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: b) Subsequrnt statements also fails with SQL0901N. 2010-05-19-00.02.26.433722+540 I35996150A841 LEVEL: Severe PID : 1437794 TID : 10736 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 007 DB : SAMPLE APPHDL : 7-22173 APPID: *N0.udbebb01.100521114921 AUTHID : DB2INST1 EDUID : 10736 EDUNAME: db2agent (SAMPLE) 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: 19 sqlerrmc: Section not loaded! sqlerrp : SQLRA03E sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFFDD (6) 0x00000007 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: This problem is likely to occur when: - There are lots of static package workloads on the database. - Package cache becomes almost full. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users who use static SQLs. * **************************************************************** * PROBLEM DESCRIPTION: * * A static SQL fails with -901 (reson: cached_sectptr is * * NULL), and subsequent statements fails with -901 (reson: * * Section not loaded) until the database is recycled. * * * * * * a) A static SQL fails with SQL0901N, reason code * * "cached_sectptr is NULL". * * 2010-05-19-00.02.24.137939+540 I35917317A844 LEVEL: Severe * * PID : 1437794 TID : 30201 PROC : db2sysc * * 0 * * INSTANCE: db2inst1 NODE : 007 DB : SAMPLE * * APPHDL : 7-22141 APPID: * * *N0.db2inst1.10052111485 * * AUTHID : DB2INST1 * * * * EDUID : 30201 EDUNAME: db2agent (SAMPLE) 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: cached_sectptr is NULL * * * * sqlerrp : SQLRA136 * * * * sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) * * 0x00000000 * * (4) 0x00000000 (5) 0xFFFFFC4A (6) * * 0x00000007 * * sqlwarn : (1) (2) (3) (4) (5) (6) * * (7) (8) (9) (10) (11) * * sqlstate: * * * * b) Subsequrnt statements also fails with SQL0901N. * * * * 2010-05-19-00.02.26.433722+540 I35996150A841 LEVEL: Severe * * PID : 1437794 TID : 10736 PROC : * * db2sysc 0 * * INSTANCE: db2inst1 NODE : 007 DB : SAMPLE * * APPHDL : 7-22173 APPID: * * *N0.udbebb01.100521114921 * * AUTHID : DB2INST1 * * EDUID : 10736 EDUNAME: db2agent (SAMPLE) 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: 19 * * sqlerrmc: Section not loaded! * * * * sqlerrp : SQLRA03E * * * * sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) * * 0x00000000 * * (4) 0x00000000 (5) 0xFFFFFFDD (6) * * 0x00000007 * * sqlwarn : (1) (2) (3) (4) (5) (6) * * * * (7) (8) (9) (10) (11) * * * * sqlstate: * * * * This problem is likely to occur when: * * * * - There are lots of static package workloads on the * * database. * * - Package cache becomes almost full. * **************************************************************** * RECOMMENDATION: * * upgrade to DB2 for LUW Version 9.5 fixpack 7 * **************************************************************** | |
Local-Fix: | |
None. Increasing PCKCACHESZ might relax the problem. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.5 fixpack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69443 IC69444 IC69828 IC69832 IC74129 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.06.2010 20.12.2010 20.12.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP7 | |
Problem behoben lt. FixList in der Version | |
9.1.0.7 | |
9.5.0.7 |