How to run IDB2 DISTRIB report in batch mode?

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
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

What is the batch equivalent of the online report TITLE =('Detail Trace of DDF Activity') contained in CDBATREQ(DISTRIB) that points to TERMINAL (panel=dbgsdxp,help=DBGRDST,nodata=DBGNTRF)?

 

Environment

Release : 20.0

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

Resolution

You can use one of these two: BTSTATR3 & BTSTASM3. If none of them gives you what you're looking for you can customize it or just make a copy DISTRIB and them customize it to make it a batch. One of the thing you'll need is to change PANEL to PRINT. You'll need to use the Sysview for DB2 Doc that you can access using the following link:

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/reference/iql-reference/how-to-write-a-request.html