DB2 FOR LUW / DB2FORLUW / 970 - DB2

db2look fails to insert a comma incase there is no consecutive 
element created for COMPONENTS listed. 
 
EX: 
 
 
CREATE SECURITY LABEL COMPONENT "COMPONENT_01" 
   SET {'001', '002', '003'}; 
 
 
CREATE SECURITY LABEL COMPONENT "COMPONENT_02" 
   SET {'004', '005', '006'}; 
 
CREATE SECURITY LABEL COMPONENT "COMPONENT_03" 
   SET {'007', '008', '009'}; 
 
 
If you specify the elements for components COMPONENT_01 and 
COMPONENT_03 as follows: 
 
CREATE SECURITY LABEL "SEC_LABEL"."LABEL_NAME" 
   COMPONENT "COMPONENT_01" '001', 
   COMPONENT "COMPONENT_03" '008'; 
 
 
then db2look will fail to insert a comma for components listed 
causing error SQL0104N be printed in db2look output and 
bad syntax like as following: 
 
 
CREATE SECURITY LABEL "SEC_LABEL"."LABEL_NAME" 
   COMPONENT "COMPONENT_01" '001' 
 
   COMPONENT "COMPONENT_03" '008'; 
 
 
However, if you specify all consecutive component elements, 
db2look will generate the correct DDL: 
 
CREATE SECURITY LABEL "SEC_LABEL"."LABEL_NAME" 
   COMPONENT "COMPONENT_01" '001', 
   COMPONENY "COMPONENT_02" '004', 
   COMPONENT "COMPONENT_03" '008';

DB2LOOK FAILS TO INSERT A COMMA INCASE THERE IS NO CONSECUTIVE 
ELEMENT CREATED FOR COMPONENTS LISTED.

No local Fix

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
 

It is fixed in db2 V9.7 FP2

not known / see Local fix

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

08.09.2009
06.07.2010
06.07.2010

9.7.FP2