Fixes are available
APAR status
Closed as program error.
Error description
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';
Local fix
No local Fix
Problem summary
DB2LOOK FAILS TO INSERT A COMMA INCASE THERE IS NO CONSECUTIVE ELEMENT CREATED FOR COMPONENTS LISTED.
Problem conclusion
Fixed in DB2 V91 FP10
Temporary fix
Comments
APAR Information
APAR number
IZ60245
Reported component name
DB2 CEE SOLARIS
Reported component ID
5765F3002
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-08
Closed date
2011-06-14
Last modified date
2011-06-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 CEE SOLARIS
Fixed component ID
5765F3002
Applicable component levels
R910 PSY
UP
R950 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]
Document Information
Modified date:
03 October 2021