PSP: Imagine How Much You Can Learn Exploring Db2, CICS and MQ SMF Data

Project and Program: SHARE-wide Events

Tags: Proceedings, SHARE Columbus 2022

Db2, CICS, and MQ produce SMF data that offers rich potential insights for managing the availability and performance of these subsystems. This session is designed to capitalize on the vast learning potential available through exploring the contents of that data. We plan to cover as many of these areas as time permits: '€¢ Visibility into levels of detail within CICS regions provided by the Statistics data including by storage area, TCLASS, and TCB pool and mode '€¢ Facilitating CICS transaction response time analysis getting our arms around the almost 100 timing buckets '€¢ Exploring the extensive Db2 buffer pool metrics and leveraging them to inform buffer pool tuning activities '€¢ Examining the differing profiles of work generated by the various callers of Db2 services ("connection type"), including CPU and SQL activity and elapsed time profiles '€¢ Exploring the visibility provided by "correlation ID" into the specific drivers of Db2 activity (e.g., by CICS transaction, batch job, etc.) '€¢ How focusing analysis of DDF work by "authorization ID" can help manage what is often a challenging workload '€¢ Introducing many types of metrics found in the MQ Statistics data including MQ command counts, buffer utilizations and write thresholds, and logging metrics '€¢ Examining the differing profiles of work generated by the various callers of MQ services ("connection type"), including command elapsed and CPU times, message lengths, persistent message counts, and queue depth This session will be full of technical content of value both to specialists and to learners from other disciplines. When the session finishes don't be surprised if you can't wait to get back home and expand your learning horizons through exploring your own SMF data.

Back to Proceedings File Library