Batch report for the top plans accessing a Db2 table using Detector for Db2

Products

• Detector for DB2 for z/OS

Issue/Introduction

How to generate a batch report for the top plans accessing a Db2 table using Detector for Db2 for z/OS (PDT)?

Resolution

The process of creating your own report is documented in the Detector for Db2 for z/OS guide:

1. Unload the datastore data into a sequential file UNLOAD Specifies whether to unload the records that match the filtering and selection
criteria into a sequential file. You can then use a load utility to load the data into Db2 tables or write your own facility for reporting the data.
The following values are valid: Y Unloads the records to a sequential file. Also specify the target data set in a SYSREC DD.
The hlq.CDBAJCL(PDTBATCH) sample member shows the parameters for this data set.

2. Create Db2 tables if you have done that yet. The DDL is located in hlq.CDBASKL0(PDTDDL)

3. Load Collection Data into Db2 Tables:
a - Unload the data to a flat file
b - After you have unloaded the collection data to a sequential file, you can optionally load the collection data from the file into the
Detector for Db2 for z/OS tables. To load collection data into Db2 tables, edit one of the following jobs.
These jobs are provided in hlq.CDBASAMP to include a valid JOB statement, DB2 subsystem ID, libraries for your site, and your system
user ID for utility data sets:
PDTLOADI Loads collection data into DB2 tables using the IBM LOAD utility.
PDTLOADC Loads collection data into DB2 tables using Fast Load for Db2 for z/OS

4. You can query the tables to generate your customized report.