home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList