IBM Support

PK52064: SQL TEXTS FROM QW0140SQ, QW0141TX, QW0142TX, QW0145TX ARE NOT PRINTED IN FULL LENGTH IN RECORD TRACE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL texts from QW0140SQ, QW0141TX, QW0142TX, QW0145TX are not
    printed in full length in RECORD TRACE for IFCID 140, 141, 142
    and 145.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   Batch Reporting                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: The SQL statement in QW0140SQ,          *
    *                      QW0141TX, QW0142TX and QW0145TX is not  *
    *                      always printed in full available        *
    *                      length.                                 *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF to get the full available     *
    *                 SQL statement text in Record Trace.          *
    ****************************************************************
    PROBLEM SUMMARY:
    The SQL statement in QW0140SQ, QW0141TX, QW0142TX and QW0145TX
    is not always printed in full available length.
    
    PROBLEM CONCLUSION:
    By using a larger internal buffer even large SQL statements
    are now printed in full available length.
    

Problem conclusion

  • By using a larger internal buffer even large SQL statements
    are now printed in full available length.
    
    KEYWORDS : QW0140SQ QW0141TX QW0142TX QW0145TX
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK52064

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-08-31

  • Closed date

    2007-12-07

  • Last modified date

    2008-01-03

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

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

    UK31938 UK31971

Modules/Macros

  • DGONF140 DGONF150
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R310 PSY UK31938

       UP07/12/08 P F712

  • R410 PSY UK31971

       UP07/12/08 P F712

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 January 2008