| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT04494 | Status: Closed |
SQLB_END_OF_CONTAINER ERROR IS RETURNED WHEN SMS TABLESPACE CONTAINER SIZE IS INCREASED | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
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 Summary: | |
**************************************************************** * 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) | |
| Solution | |
First Fixed in DB2 9.7 Fix Pack 12 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.09.2014 09.05.2017 09.05.2017 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP12 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.11 |
|