Setting/Create Profile for two different plans and collection options

Products

• Detector for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Recovery Suite

Issue/Introduction

Here is a SCENARIO: 

- Two plans: PLAN-A and PLAN-B.

- Every day, PLAN-A is used in on-line programs under CICS.

- Every day,PLAN-B is used in batch programs.

- Every day both PLAN-A and PLAN-B can run at the same time.

 

REQUIREMENT: TO DEFINE COLLECTION PROCESING for the following cases:

- CASE 1: Need to define a profile for PLAN-A with N in the Triggered SQL collection field.

- CASE 2:Need to define a profile for PLAN-B with Y in the Triggered SQL collection field and Y in the Dynamic SQL field in order to indicate we want to collect dynamic SQL data.

 

QUESTION:

Is it possible to create one profile considering CASE1 and CASE2, both in the same profile because PLAN-A and PLAN-B could be executed at the same time?

 

 

 

 

Environment

Release : 20.0

Component : Detector for DB2 for z/OS

Resolution

Using the collection profile Plan Exclude/Include Group, you can have two different entries; one for PLAN A(CICS) and another for PLAN B(BATCH) but there is no granularity to turn on or off Triggered SQL. This can be submitted as an idea(enhancement) in the DB2 communities.