|
Problem IC65247
|
Status: Closed |
SQL901 ERROR when unable to connect |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
DB2 could hit the SQL0901N error and unable to connect to the
database.
The SQL901 means "Not enough memory reclaimed for 1 buffer"
and "numPageHdrLeftToAlloc should be >0"
This problem will only happen on systems that are severely
short of memory. You should investigate the memory shortage
situation.
2009-11-12-15.37.03.881000-300 I87032530H879 LEVEL: Severe
PID : 2600 TID : 3244 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPLE
APPHDL : 0-655 APPID: *LOCAL.DB2.091112194827
AUTHID : DB2SERV
EDUID : 3244 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: 35
sqlerrmc: numPageHdrLeftToAlloc should be > 0
sqlerrp : SQLRI4B5
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFD8D (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 Server User *
****************************************************************
* PROBLEM DESCRIPTION: *
* The following error can happen when we are short on memory *
* (sortheap) and we need to do special processing in order to *
* finish while constrained on memory. *
* With the fix DB2 will proceed. As long as we get minimum *
* memory required, DB2 will return result back to the user. *
* If even minimum memory required could not be obtained then *
* different, more descriptive, error will be returned. *
* *
* 2009-11-12-15.37.03.881000-300 I87032530H879 LEVEL: *
* Seve *
* PID : 2600 TID : 3244 PROC : *
* *
* db2syscs.exe *
* *
* INSTANCE: DB2 NODE : 000 DB : *
* *
* SAMPLE *
* *
* APPHDL : 0-655 APPID: *
* *LOCAL.DB2.091112194827 *
* AUTHID : DB2SERV *
* *
* EDUID : 3244 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: *
* sqlerrmc: numPageHdrLeftToAlloc should be > 0 *
* *
* sqlerrp : SQLRI4B5 *
* *
* sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) *
* *
* 0x00000000 *
* *
* (4) 0x00000000 (5) 0xFFFFFD8D (6) *
* *
* 0x00000000 *
* *
* sqlwarn : (1) (2) (3) (4) (5) *
* (6 *
* (7) (8) (9) (10) (11) *
* *
* sqlstate: *
* *
* *
* *
* The SQL 901 means "Not enough memory reclaimed for 1 buffer" *
* *
* and "numPageHdrLeftToAlloc should be >0" *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.5 FP6 or newer *
**************************************************************** |
| Local Fix: |
NO |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
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 Fixed in DB2 Version 9.5 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.12.2009
23.10.2011
18.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.,
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
