Start of change

Instrumentation enhancements

Db2 12 provides several instrumentation enhancements.

These enhancements for Db2 Db2 12 include:
  • More granular wait times for IFCIDs 316 (dynamic) and 401 (static)
  • Enhanced IFCIDs 53/58 statement level section for PREPARE (similar to INSERT/UPDATE/DELETE)
  • Addition of section number in IFCIDs 53/58
  • Addition of batch job STEP name in correlation header
  • Addition of REFRESH TABLE to counts in DSNDQXST
  • Measurement of cache + catalog hit ratio to recognize reduced full prepare due to dynamic plan stability
End of change