PK91768: SQL ACTIVITY TRACE REPORT - UNEXPECTED CHARS FOR ATTR FIELD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The report sometimes looks good but sometimes we have additional
  chars in ATTR text:
  ATTR: DSNHATTR FOR READ ONLY b  instead of just ATTR: DSNHATTR
  FOR READ ONLY (i.e. 'b' should not be there)
  
  SQLACTIVITY
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The field ATTR shows unreadable         *
  *                      characters in Batch SQL Activity Trace. *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  Incorrect length used for the display of the value. Unreadable
  chars were shown.
  
  PROBLEM CONCLUSION:
  The correct length is used now to show the value of the ATTR
  field.
  

Problem conclusion

• The correct length is used now to show the value of the ATTR
  field.
  KEYWORDS :
  BATCH SQL ACTIVITY TRACE ATTR UNREADABLE CHARS
  

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:

  UK49876

Modules/Macros

• DGORPSUM
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R420 PSY UK49876

     UP09/09/12 P F909

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.