IBM Support

IC68746: FOR DB2 ROUTINES WHICH ARE APPENDED WITH "COMMENTS" DURING CREAT ION, DB2LOOK FAILS TO RE-CREATE THE OBJECT FROM THE DB2LOOK OUTP

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • For DB2 routines which are appended with "comments" during
    creation, like the one below:
    
    db2 "CREATE /*replace*/ or replace PROCEDURE myproc6(IN in1
    smallint,IN in2 smallint,IN in3 CHAR(20)) BEGIN INSERT INTO
    lappanna.tab1 values(in1,in2,in3); END
    --comment1
    --comment2
    "
    
    db2look will append the terminating character in the comment
    line itself, like the one below:
    
    ---------------------------------
    -- DDL statements for stored procedures
    ---------------------------------
    
    SET CURRENT SCHEMA = "LAPPANNA";
    SET CURRENT PATH =
    "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","LAPPANNA";
    
    CREATE PROCEDURE myproc6(IN in1 smallint,IN in2 smallint,IN
    in3 CHAR(20)) BEGIN INSERT INTO lappanna.tab1
    values(in1,in2,in3); END
    --comment1
    --comment2;
    
    
    When this db2look output is used to recreate the above procedure
    it fails to create that object and gives a syntax error.
    This is because the CLP ignores the comment line and thus the
    terminating character.
    
    
    The correct way would be db2look appends the terminating
    character at the next newline, like the one below:
    
    ---------------------------------
    -- DDL statements for stored procedures
    ---------------------------------
    
    SET CURRENT SCHEMA = "LAPPANNA";
    SET CURRENT PATH =
    "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","LAPPANNA";
    
    CREATE PROCEDURE myproc6(IN in1 smallint,IN in2 smallint,IN
    in3 CHAR(20)) BEGIN INSERT INTO lappanna.tab1
    values(in1,in2,in3); END
    --comment1
    --comment2
    ;
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 V97fp1                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * "db2 -tvf" fails to generate the correct DDLs as "db2look"   *
    * doesn't generate the correct "comments"                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V97fp3.                                       *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 Version 9.7 fix pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68746

  • 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

    2010-05-20

  • Closed date

    2010-06-23

  • Last modified date

    2010-09-16

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

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

    IC69079

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7"}]

Document Information

Modified date:
10 September 2020