DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

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

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

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 version 9.7 fixpack 7

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC87838 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.04.2012
20.10.2012
20.10.2012

9.7.FP7