PI92651: IMPROVED SUPPORT FOR DB2 V11 AUTONOMOUS STORED PROCEDURES IN APPLICATION TRACE FACILITY

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Improved support for DB2 V11 Autonomous Stored Procedures in
  Application Trace Facility.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM                *
  *                 users of component                           *
  *                 Application Trace Facility                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: ATF Create DSN can only create 999      *
  *                      megabyte VSAM dataset                   *
  *                                                              *
  *                      ATF tracing doesn-t collect performance *
  *                      records generated during execution of   *
  *                      Autonomous Store Procedures.            *
  *                      INCOROUT when specifying various ATF    *
  *                      trace filtering options.                *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  ATF Create DSN panel can only create dataset up to 999
  megabytes, despite ATF supporting datasets up to 2048 MB.
  When a Unit of Work invoked a Db2 Autonomous SQL Stored
  Procedure, no data was captured while it was executing.
  Various filtering options would result in incorrect output
  when viewing an ATF trace dataset.
  

Problem conclusion

Temporary fix

Comments

• ATF Command ZLDSC now supports allocation of 2048 Meg (2 Gig)
  ATF trace datasets.
  Trace records generated by Autonomous SQL Stored Procedures
  are now captured and reported on.
  Improvements to filtering logic correct missing records
  Which had been incorrectly filtered out.
  

APAR Information

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

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

  UI56210

Modules/Macros

•    KO2ARS0K KO2ARS0S KO2ARS02 KO2ARS1K KO2ARS1S
  KO2ARS12 KO2ATBMB KO2ATQXB KO2ATRCB KO2ATRDB KO2ATREB KO2ATRTB
  KO2ATVDB KO2ATVWB KO2DCS1B KO2HMSGB KO2LDSCB KO2OINTB KO2OMGCB
  KO2OTHDB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI56210

     UP18/06/02 P F806

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.