|
Problem IC69828
|
Status: Geschlossen |
Static SQL fails with -901 (reason: cached_sectptr is NULL) afte rpackage cache is full. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - 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.1 fixpack 10. *
**************************************************************** |
| Local-Fix: |
None. Increasing PCKCACHESZ might relax the problem. |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
First fixed in DB2 Version 9.1 fixpack 10. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.07.2010
20.04.2011
20.04.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
