IBM Support

IC70485: MAXIMUM SIZE LIMITATION OF A DB2 DMS TEMPORARY TABLESPACE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Database manager erroneously reports that a temporary DMS
    tablespace has reached its maximum size, when the reported size
    is in fact a value that is below the documented limit.
    
    For example, for a 32K temporary DMS tablespace, you may
    observe the following error message in db2diag.log:
    
    2010-02-02-07.51.36.600495-360 E62453858A639 LEVEL: Warning
    PID : 86514 TID : 14185 PROC : db2sysc 2
    INSTANCE: bcuaix NODE : 002 DB : xxxxxx
    APPHDL : 0-75 APPID: *N0.bcuaix.100202122336
    AUTHID : BCUAIX
    EDUID : 14185 EDUNAME: db2agntp 2
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbPrepareToGrowLastRange, probe:160
    MESSAGE : ADM6099W Table space "TEMP32K" (ID "2") has reached
    the maxiumum size ("549755813888" bytes) for a tablespace of
    this type and page size. To add more storage to the database,
    add a new table space.
    
    Here, the database manager reports the maximum limit of 512 GB
    was reached. However, DB2 info center states that temporary DMS
    tablespace is always LARGE and should have a 64 TB limit for
    32K pages.
    
    The problem is that database manager incorrectly treats
    temporary DMS tablespaces as REGULAR when they should be
    considered LARGE.
    
    The problem applies to tablespace with page sizes other than
    32K, as well.
    

Local fix

Problem summary

  • USERS AFFECTED:
    ===============
    Customer using version 9.5 and above on all platforms.
    
    PROBLEM DESCRIPTION:
    ====================
    DB2 is treating temporary tablespace as REGULAR tablespace when
    it attempts to grow a temporary tablespace as part of extent
    allocation. Temporary tablespaces should truly be considered as
    LARGE/LONG tablespace. Due to this behavior, DB2 will fail
    stating the maximum capacity is reached when attempting to grow
    the temporary tablespace beyond 512 GB. The true limit for a
    large tablespace is 64 TB.  This APAR will make sure that DB2
    treats a temporary tablespace as a LARGE/LONG tablespace.
    

Problem conclusion

  • Problem is first fixed in version 9.7 Fixpack 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70485

  • 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

    2010-08-11

  • Closed date

    2011-05-03

  • Last modified date

    2011-12-19

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

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

    IZ82631

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC70485

Modified date: 19 December 2011