IBM Support

IT28319: THE DB2CAEM TOOL MAY FAIL WITH DIFFERENT ERRORS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The db2caem tool may fail with error SQL104, SQL103, SQL204 etc.
    
    Most of errors will point to wrong syntax, undefined objects,
    not valid literals etc.
    
    This may happen if the statement provided in the input file has
    any line longer than 1460 characters.
    The error is returned because db2caem wrongly interprets long
    lines of the statements and puts white space in each line after
    1460 characters
    
    This issue can be reproduced as follows:
    
    db2 connect to sample
    $ cat badquery.sql
    /*This is some text to make this line longer that 1460
    character. The quick red fox jumps over the lazy brown dog. The
    quick red fox jumps over the lazy brown dog. The quick red fox
    jumps over the lazy brown dog. The quick red fox jumps over the
    lazy brown dog. The quick red fox jumps over the lazy brown dog.
    The quick red fox jumps over the lazy brown dog. The quick red
    fox jumps over the lazy brown dog. The quick red fox jumps over
    the lazy brown dog. The quick red fox jumps over the lazy brown
    dog. The quick red fox jumps over the lazy brown dog. The quick
    red fox jumps over the lazy brown dog. The quick red fox jumps
    over the lazy brown dog. The quick red fox jumps over the lazy
    brown dog. The quick red fox jumps over the lazy brown dog. The
    quick red fox jumps over the lazy brown dog. The quick red fox
    jumps over the lazy brown dog. The quick red fox jumps over the
    lazy brown dog. The quick red fox jumps over the lazy brown dog.
    The quick red fox jumps over the lazy brown dog. The quick red
    fox jumps over the lazy brown dog. The quick red fox jumps over
    the lazy brown dog. The quick red fox jumps over the lazy brown
    dog. The quick red fox jumps over the lazy brown dog. The quick
    red fox jumps over the lazy brown dog. The quick red fox jumps
    over the lazy brown dog. The quick red fox jumps over the lazy
    brown dog. The quick red fox jumps over the lazy brown dog. The
    quick red fox jumps over the lazy brown dog.*/ select * from
    employee;
    
    db2caem -d sample -sf badquery.sql
    
    DBT7042I  "db2caem": The SQL statement "/*This is some text to
    make this line longer that 1460 character. The quick red fox
    jumps over the lazy brown dog. The quick red fox jumps over the
    lazy brown dog. The quick red fox jumps over the lazy brown dog.
    The quick red fox jumps over the lazy brown dog. The quick red
    fox jumps over the lazy brown dog. The quick red fox jumps over
    the lazy brown dog. The quick red fox jumps over the lazy brown
    dog. The quick red fox jumps over the lazy brown dog. The quick
    red fox jumps over the lazy brown dog. The quick red fox jumps
    over the lazy brown dog. The quick red fox jumps over the lazy
    brown dog. The quick red fox jumps over the lazy brown dog. The
    quick red fox jumps over the lazy brown dog. The quick red fox
    jumps over the lazy brown dog. The quick red fox jumps over the
    lazy brown dog. The quick red fox jumps over the lazy brown dog.
    The quick red fox jumps over the lazy brown dog. The quick red
    fox jumps over the lazy brown dog. The quick red fox jumps over
    the lazy brown dog. The quick red fox jumps over the lazy brown
    dog. The quick red fox jumps over the lazy brown dog. The quick
    red fox jumps over the lazy brown dog. The quick red fox jumps
    over the lazy brown dog. The quick red fox jumps over the lazy
    brown dog. The quick red fox jumps over the lazy brown dog. The
    quick red fox jumps over the lazy brown dog. The quick red fox
    jumps over the lazy brown dog. The quick red fox jumps over the
    lazy brown dog.*/ select * from emplo yee" is being issued.
    
    DBT7028E  "db2caem": The db2caem command failed because the DB2
    database manager encountered an error while processing the
    specified input parameters and the specified SQL statement.
    Handle type: "3". Return code: "-1:1920".
               CLIInfo: SQLstate: "42S02"
                        Return code: "-204"
                        Diagnostic message: "[IBM][CLI
    Driver][DB2/LINUXX8664] SQL0204N  "ESCHEMA.EMPLO" is an
    undefined name.  SQLSTATE=42704
    

Local fix

  • Break the statement into lines shorter than 1460 characters
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v111m4fp6 or later                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to db2_v111m4fp6 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT28319

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-03-06

  • Closed date

    2021-03-19

  • Last modified date

    2021-03-19

  • 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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
20 March 2021