IBM Support

IC80733: INVALID APG XML GENERATED FROM EXPLAIN_SQL STORED PROCEDURE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • EXPLAIN_SQL and db2exfmt can generate incomplete SQL statement
    text, and predicate text, with some multi-byte National Language
    characters missing or truncated. This occurs when there is a
    code page difference between the database and the client or
    application.
    
    If you see the SQL statement text, predicate text, table names,
    or column names displayed incorrectly, this fix should correct
    the problem, and cause the text to display properly.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 LUW users of db2exfmt with different Server & Client     *
    * code pages                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the DB2 Linux, Unix and Windows server to v9.7fp6 or *
    * higher.                                                      *
    ****************************************************************
    

Problem conclusion

  • Upgrade the DB2 Linux, Unix and Windows server to v9.7fp6 or
    higher in order for the output of db2exfmt to contain the
    correct output for any of the SQL Statement, predicate text,
    column lists, or explain arguments.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80733

  • 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

    2012-01-09

  • Closed date

    2012-11-09

  • Last modified date

    2012-11-09

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

    IC71487

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

    IC84595

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • RA10 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC80733

Modified date: 09 November 2012