PK79315: -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.
  

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.
  
  KEYWORDS : DYNAMIC STATEMENT CACHE STATISTICS, IFCID 318
  

APAR Information

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

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

  UK50347 PM08037

Modules/Macros

• KD2BHELP KD2CVAR2 KD2DDICT KD2PTRC  KD2SBATO
  KD261CV1 KD261CV3 KD261HBT KD261PD  KD261SB2 KD261TC
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK50347

     UP09/09/26 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.