What IDB2 IQL to run for Detailed Summary of Accounting?

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite

Issue/Introduction

What request should be run for?

1-A Db2 monitor report that would have the heading: Detailed Summary of Accounting Information Grouped by Connection Type.

2-A Db2 monitor statistics report for the Db2 subsystem's database services address space

3-A Db2 monitor statistics report for the Db2 subsystem's distributed data facility address space

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

1-ACCOUNTING SUMMARY LONG FORMAT(BTACTSML) and SHORT FORMAT(BTACTSML). Recommend running first the short one to see the info it provides before running the long one.

2. BTSTATR1

3-BTSTASM1, BTSTATR1or DISTRIB(This is not a batch but can be used as template to create a customized version if the first 2 don't provide what is  needed.