DB2 FOR LUW / DB2FORLUW / 970 - DB2

Db2look is not inserting the comments for table and columns into 
systools.db2look_info table for  SYSPROC.ALTOBJ() to refer. 
 
For example, if you call system procedure SYSPROC.ALTOBJ to 
alter table TABLEA: 
 
CALL SYSPROC.ALTOBJ('APPLY_CONTINUE_ON_ERROR', 'CREATE TABLE 
DB2INST1.TABLEA(COL1 DECIMAL(5, 0), COL2 VARCHAR (20))', -1, ? 
); 
 
, then after it recreated the table TABLEA, you will lose all 
the COMMENTs for table TABLEA, as well as its columns' COMMENTs.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL.                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Db2look is not inserting the comments for table and          * 
* columnsintosystools.db2look_info table for  SYSPROC.ALTOBJ() * 
* to refer.For example, if you call system procedure           * 
* SYSPROC.ALTOBJ toalter table TABLEA:CALL                     * 
* SYSPROC.ALTOBJ('APPLY_CONTINUE_ON_ERROR', 'CREATE            * 
* TABLEDB2INST1.TABLEA(COL1 DECIMAL(5, 0), COL2 VARCHAR        * 
* (20))', -1,?);, then after it recreated the table TABLEA,    * 
* you will loseallthe COMMENTs for table TABLEA, as well as    * 
* its columns'COMMENTs.                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to version 9.7 fix pack 2 or later.                   * 
****************************************************************

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

This problem is first fixed in version 9.7 fix pack 2.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

11.11.2009
25.05.2010
25.05.2010

9.7.FP2