IBM Support

IT07540: CLI QUERIES WHICH NEEDS INTERNAL TRANSLATION MAY THROW CLI0118E

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • CLI queries which needs internal translation, for eg. query
    using fn TimestampDiff function will internally be translated to
    use SYSFUN.TIMESTAMPDIFF instead, may throw error "CLI0118E
    Invalid SQL syntax.SQLSTATE=37000". This is because the length
    of the translated query is exceeding the allocated temporary
    buffer. In trace you may see failure in CLI_scnTranslate
    function
    
    1305278       31.954000729   | | | | CLI_scnReplaceToken entry
    1305279       31.954001518   | | | | CLI_scnReplaceToken error
    [probe 1]
    1305280       31.954001913   | | | | | CLI_errStoreError entry
    1305281       31.954002308   | | | | | CLI_errStoreError data
    [probe 999]
    1305282       31.954002703   | | | | | CLI_errStoreError exit
    1305283       31.954002703   | | | | CLI_scnReplaceToken exit
    [rc = 0xFFFFFFFF = -1]
    1305284       31.954002703   | | | | CLI_memFree entry
    1305285       31.954003097   | | | | CLI_memFree exit
    1305286       31.954003097   | | | CLI_scnTranslate exit [rc =
    0xFFFFFFFF = -1]
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fixpack 11                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fixpack 11
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT07540

  • 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

    2015-03-06

  • Closed date

    2015-10-20

  • Last modified date

    2015-10-20

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

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

    IT08006 IT08008

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       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:
20 October 2015