IBM Support

IZ60245: 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

  • 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:

    IZ60244

  • 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