PI92754: OMPE SQLACTIVITY TRACE SHOWS TRUNCATED SQL TEXT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• OMPE SQLACTIVITY TRACE shows truncated SQL Text.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM users of       *
  *                 component                                    *
  *                  - Batch Reporting                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: OMEGAMON Batch Reporter SQLACTIVITY     *
  *                      TRACE may truncate the text of long SQL *
  *                      statements after the first line.        *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  A text of a multi-line SQL statement may be truncated when an
  SQLACTIVITY TRACE page header is printed in the middle of the
  statement.  The same internal buffer was being used to generate
  the page header and padding with blanks overwrote the remainder
  of the SQL statement text.
  

Problem conclusion

• The code was changed to fix this problem.
  
  Search Keywords:
  INCORROUT BATCH SQLACTIVITY TRACE SQL TEXT TRUNCATED
  

Temporary fix

Comments

APAR Information

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

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

  UI54809

Modules/Macros

•    DGORPSUM
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI54809

     UP18/03/29 P F803

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.