PM53549: SUPPORT OF STATEMENT ID IN BATCH AUDIT, TYPE DML AND BIND

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Support of field STATEMENT ID in BATCH AUDIT, TYPE DML and BIND,
  IFCID 143, 144, 145, in TRACE, REPORT, FILE, and PDB.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  *                 -   Performance Database users               *
  ****************************************************************
  * PROBLEM DESCRIPTION: The SQL STATEMENT ID is neither         *
  *                      supported in Batch Audit Report,        *
  *                      Trace, File nor in Audit tables of the  *
  *                      Performance Database.                   *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                 Update current Audit file tables.            *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  The SQL STATEMENT ID is neither supported in Batch Audit Report,
  Trace, File nor in Audit tables of the Performance Database.
  
  PROBLEM CONCLUSION:
  The PTF for this apar supports the field SQL STATEMENT ID in
  Batch Audit Report, Trace, File and in Audit tables of the
  Performance Database (label STMT ID and column STMT_ID).
  

Problem conclusion

Temporary fix

Comments

• The PTF for this apar supports the field SQL STATEMENT ID in
  Batch Audit Report, Trace, File and in Audit tables of the
  Performance Database (label STMT ID and column STMT_ID).
  
  KEYWORDS : SQL STATEMENT ID STMT ID STMT_ID BATCH AUDIT REPORT
  TRACE FILE PDB PERFORMANCE DATABASE SAMPLE TABLE DB2PMFAUDT_DML
  DB2PMFAUDT_BINDNR TYPE DML BIND BINDNR NON REPEATING
  

APAR Information

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

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

  UK75757

Modules/Macros

• DGOXBBND DGOXBDML DGOXCBND DGOXCDML DGOXDBND
  DGOXDDML DGOXD000 DGOXFSQL DGOXF000 DGOXF001 DGOXF002 DGOXF003
  DGOXF004 DGOXF005 DGOXF006 DGOXF007 DGOXF008 DGOXF009 DGOXLBND
  DGOXLDML DGOXR000 DGOXT000 DGOXT001 DGOXT002 DGOXT003 DGOXT004
  DGOXT005 DGOXT006 DGOXT007 DGOXUPDB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK75757

     UP12/01/28 P F201

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.