IBM Support

IT04494: SQLB_END_OF_CONTAINER ERROR IS RETURNED WHEN SMS TABLESPACE CONTAINER SIZE IS INCREASED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as Permanent restriction.

Error 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.
    

Local fix

  • recycle the instance (issue db2stop; db2start)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgraded in DB2 9.7 Fix Pack 12                              *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 9.7 Fix Pack 12
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT04494

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-09-19

  • Closed date

    2017-05-09

  • Last modified date

    2017-05-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 May 2017