IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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

  • It is fixed in db2 V9.7 FP2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC63038

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-08

  • Closed date

    2010-07-06

  • Last modified date

    2010-07-06

  • APAR is sysrouted FROM one or more of the following:

    IZ60244

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R910 PSY

       UP

  • R950 PSY

       UP

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 July 2010