FILTERING IDB2 BTACTSMS BY PLAN

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

How do I specify Conditional statements with Batch Report Writer out of CDBATREQ Dataset and Member BTACTSMS.

 

Like "IF PLAN_NAME = '?"" or "IF PLAN_NAME = '?' and PACKAGE_NAME='?', etc. (IF-THEN-ELSE-AND-OR)

 

 

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

Add the following to the BTACTSMS. Make your own copy of it
#IFEND
WHERE PLAN-NAME='DISTSERV' <====
TITLE = ('SHORT SUMMARY OF ACCOUNTING INFORMATION',
'GROUPED BY AUTH-ID, PLAN-NAME')
PRINT (BTACTSMS) /* <== ROUTE REPORT TO DDNAME IN JCL */
;