IBM Support

IC82546: AFTER REDIRECTED RESTORE TERMINATED WITH ERROR "-1704" WITH TOKENS "17" SUBSEQUENT DROP FAILING TO CLEAN THE CONTAINERS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Error is a consequence of incorrect cleaning. When error occurs,
    the database drop command finishes dirty with leftover table
    space containers. Sequence of events:
    
    1. Redirected restore
    
    2. Redirected restore terminates with Error "-1704" with tokens
    "17" - unable to allocate pages in SYSCAT . You can see in
    db2diag.log:
    
    2012-03-28-06.06.57.349698-240 E371364A1119       LEVEL: Error
    PID     : 37617714             TID  : 1819        PROC : db2sysc
    INSTANCE: db2inst1             NODE : 000         DB   :
    redirectedDB
    APPHDL  : 0-10                 APPID:
    *LOCAL.db2inst1.120328100613
    AUTHID  : db2inst1
    EDUID   : 1819                 EDUNAME: db2agent (redirectedDB )
    FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateExtent,
    probe:840
    MESSAGE : ADM6044E  The DMS table space "SYSCATSPACE" (ID "0")
    is full.  If
              this is an autoresize or automatic storage DMS
    tablespace, the
              maximum table space size may have been reached or the
    existing
              containers or storage paths cannot grow any more.
    Additional space
              can be added to the table space by either adding new
    containers or
              extending existing ones using the ALTER TABLESPACE SQL
    statement. If
              this is an autoresize or automatic storage DMS table
    space,
              additional space can be added by adding containers to
    an autoresize
              table space or by adding new storage paths to an
    automatic storage
              database.
    
    3 Subsequent database drop failing to clean the currently
    assigned containers. You can see in the console error similar to
    the following:
    
    SET TABLESPACE CONTAINERS FOR  0 USING (FILE
    '/home/db2inst1/originalDB/cat' 140000)
    SQL0299N  Container is already assigned to the table space.
    SQLSTATE=42731
    
    Customer Impact: customer unable to perform a redirected restore
    of a downlevel backup image.
    

Local fix

  • Manual file system cleanup of previous table space containers is
    needed.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 fixpack 7                         *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 version 9.7 fixpack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC82546

  • 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

    2012-04-06

  • Closed date

    2012-10-20

  • Last modified date

    2012-10-20

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

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

    IC87838

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC82546

Modified date: 20 October 2012