DB2 FOR LUW / DB2FORLUW / 970 - DB2

If an add storage command fails due to disk failure. This can 
result in the SGF file to become corrupt. 
 
 
$ db2 "alter database db97 add storage on 
'/home/hotel51/calvinw'" 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0968C  The file system is full.  SQLSTATE=57011 
 
$ db2 "alter database db97 add storage on 
'/home/hotel51/calvinw'" 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL1224N  The database manager is not able to accept new 
requests, has 
terminated all requests in progress, or has terminated the 
specified request 
because of an error or a forced interrupt.  SQLSTATE=55032 
 
The problem is because during the first alter database, the SGF 
file is created but the disk full error prevented Db2 from 
writing to it. As a result, Db2 closed the file handle and 
returned error to the caller. During second alter database, Db2 
detected a SGF file's existence and assumed that the storage 
group table is initialized, but this was not the case. Results 
in a crash of the Db2 database.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to latest fix pack. Issue is resolved in fix pack    * 
* 10.                                                          * 
****************************************************************

Ensure Enough Space is available when adding storage.

First fixed in fix pack 10

not known / see Local fix

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

14.10.2013
16.12.2014
16.12.2014