Detector SQL data collection by AUTHID

Products

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

Issue/Introduction

Is there any possibility to collect data for a particular AUTH-ID? 

CA - detector is collecting all the SQL data, is there any possibility to collect the data for separate Auth - ID. This facility is not available in current setup, will this affect existing setup if any modification is done?

Environment

Release : 20.0

Resolution

The data can be collected for a particular AUTHID by following these steps:

1. Option 4 from Main Menu Maintain collect/report profiles

2. Option 1 View Collection Profiles

3. Put S -View/Modify Profile next to the profile

4. Change View Group Type ==> A to X from DETECTOR View/Modify Application Groups

5. Select 1  Collection Profile Plan Exclude/Include Group from DETECTOR Collection Exclusion Groups Menu

6. From View/Modify Include/Exclude List Entries add 2 entries. One with the AUTHID and options needed and the other one with options off.