PM08037: -START TRACE (MON) DEST(SMF) CLASS(01) IFCID(318) REQUIRED FOR DB2 DYNAMIC SQL CACHE TRACKING, BUT NOT STARTED AUTOMATICALLY

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• -START TRACE (MON) DEST(SMF) CLASS(01) IFCID(318) is required
  for DB2 Dynamic SQL Cache tracking, but not started
  automatically by Omegamon.  This trace is started if NTH is
  turned on.
  If client starts the above trace manually (NTH turned off), the
  problem is fixed.
  Screen EDDT without this trace turned on:
  
  > DYNAMIC SQL CACHE STATISTICS
  
  > place an 'a' before the EDDT command to get average for times
  and
  coun
  
  >
  
  EDDT
  
  + *
  
  + Times CPU Elapsed Wait Get- Sync Sync
  
  + Exec. Time Time Time Pages Reads Writes
  
  + ------ ------------ ------------ ------------ ------ ------
  ------
  
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  

Local fix

• Either specify NTH, or issue -START TRACE (MON) DEST(SMF)
  CLASS(01) IFCID(318) manually.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   ICAT                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: If NTH is not activated customers must  *
  *                      start the monitoring trace class 1 with *
  *                      IFCID 318 in order to collect dynamic   *
  *                      statement cache statistics. But NTH     *
  *                      may produce overhead the customer       *
  *                      does not want.                          *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  To activate support for automatic trace-start,
  a new panel with a new configuration parameter must be made
  available. This parameter will enable or disable the collection
  of the dynamic statement cache statistics. This parameter must
  also be enabled for batch mode install.
  
  PROBLEM CONCLUSION:
  A new panel was added with a new OPTIONAL configuration
  parameter to enable or disable the collection of dynamic
  statement cache statistics using monitoring class 1
  and IFCID 318. This parameter has been enabled for batch mode
  install also.
  

Problem conclusion

Temporary fix

• Start the trace by hand using the DB2 administration tool.
  

Comments

• A new panel was added with a new OPTIONAL configuration
  parameter to enable or disable the collection of dynamic
  statement cache statistics using monitoring class 1
  and IFCID 318. This parameter has been enabled for batch mode
  install also.
  
  KEYWORDS : DYNAMIC STATEMENT CACHE STATISTICS, IFCID 318
  

APAR Information

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

  PK79315

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

  UK55645

Modules/Macros

• KD2BHELP KD2CVAR2 KD2DDICT KD2HTRC  KD2PTRAC
  KD2SBATO KD261MC2 KD261SB2 KD2610SP
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R420 PSY UK55645

     UP10/04/07 P F004

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.