DB2 - Problembeschreibung
Problem IT04494 | Status: Geschlossen |
SQLB_END_OF_CONTAINER ERROR IS RETURNED WHEN SMS TABLESPACE CONTAINER SIZE IS INCREASED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When we get a 'File system full' error upon writing data into an SMS tablespace, if we increase the size of the file system, we might still continue getting the 'file system full' error message in db2diag.log. db2diag.log might contain entries similar to the following: <timestamp> LEVEL: Error PID : 14025930 TID : 1 PROC : db2agent (DBNAME) 0 INSTANCE: db2inst1 NODE : 000 DB : DBNAME APPHDL : 0-1978 APPID: <Application Id> AUTHID : DB2AUTH1 FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDirectWrite, probe:99 MESSAGE : ADM6017E The table space "TBSPACE1" (ID "4") is full. Detected on container "/db2auth1/tbspace1" (ID "2"). The underlying file system is full or the maximum allowed space usage for the file system has been reached. It is also possible that there are user limits in place with respect to maximum file size and these limits have been reached. <timestamp> LEVEL: Error PID : 14025930 TID : 1 PROC : db2agent (DBNAME) 0 INSTANCE: db2inst1 NODE : 000 DB : DBNAME APPHDL : 0-1978 APPID: <Application Id> AUTHID : DB2AUTH1 FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDirectWrite, probe:99 MESSAGE : container page this was encountered on = DATA #1 : unsigned integer, 8 bytes 327828 <timestamp> LEVEL: Error PID : 14025930 TID : 1 PROC : db2agent (DBNAME) 0 INSTANCE: db2inst1 NODE : 000 DB : DBNAME APPHDL : 0-1978 APPID: <Application Id> AUTHID : DB2AUTH1 FUNCTION: DB2 UDB, buffer pool services, sqlbCheckAllocation, probe:0 MESSAGE : ZRC=0x85020021=-2063466463=SQLB_END_OF_CONTAINER "DMS Container space full" This APAR will fix the above observed issue. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgraded in DB2 9.7 Fix Pack 12 * **************************************************************** | |
Local-Fix: | |
recycle the instance (issue db2stop; db2start) | |
Lösung | |
First Fixed in DB2 9.7 Fix Pack 12 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.09.2014 09.05.2017 09.05.2017 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP12 | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |