IBM Support

IC90600: DB2 CREATE TABLESPACE COMMAND CAN FAIL WITH SQL0289N WHEN FILE SYSTEM SIZE EXCEEDS 16 TB

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Create tablespace command in an SMS tablespace may fail with
    SQL0289N error in storage system with very large file system
    sizes exceeding 16 TB.  However os commands such as dd will be
    able to create files in that file system with no errors.
    
    
    
    db2diag.log snippet:
    -------------------
    2012-12-13-14.01.40.137432-480 E6548E842           LEVEL: Error
    PID     : 11409                TID  : 47352953956672PROC :
    db2sysc 0
    INSTANCE: resdb2               NODE : 000          DB   : SAMPLE
    APPHDL  : 0-1988               APPID: *LOCAL.resdb2.121213213340
    AUTHID  : RESDB2
    EDUID   : 21                   EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDirectWrite,
    probe:99
    MESSAGE : ADM6017E  The table space "IP8KTS" (ID "7") is full.
    Detected on
              container "/db2_db/respatp2/sample/tablespaces/ip8kts"
    (ID "0").  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.
    
    2012-12-13-14.01.40.146232-480 I7391E501           LEVEL: Error
    PID     : 11409                TID  : 47352953956672PROC :
    db2sysc 0
    INSTANCE: resdb2               NODE : 000          DB   : SAMPLE
    APPHDL  : 0-1988               APPID: *LOCAL.resdb2.121213213340
    AUTHID  : RESDB2
    EDUID   : 21                   EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDirectWrite,
    probe:99
    MESSAGE : container page this was encountered on =
    DATA #1 : unsigned integer, 8 bytes
    0
    
    db2trc info shows:
    0604 errtrans DB2 UDB global services sqlzeMapZrc cei
    (13.3.26.46.2.40)
     pid 11409 tid 47352953956672 cpid 28141 node 0 probe 40
    
     Error Translation
    
     Original Error ZRC = 0x85020021 = -2063466463 =
    SQLB_END_OF_CONTAINER
          New Error SQL0289
    
    
    
    40605 error DB2 UDB global services sqlzeMapZrc cei
    (4.3.26.46.2.50)
     pid 11409 tid 47352953956672 cpid 28141 node 0 probe 50
    
     Error ZRC = 0x85020021 = -2063466463 = SQLB_END_OF_CONTAINER
    
     bytes 144
    
     This can occur where the file system is larger than 16 TB (2^32
    4k pages).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users using NAS storage for Tablespaces.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to DB2 LUW V9.7 FixPack 9                            *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 LUW V9.7 FixPack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90600

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-01

  • Closed date

    2014-07-30

  • Last modified date

    2014-07-30

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

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

    IC96385 IC96423

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

[{"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:
30 July 2014