home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList