Batch report for the top plans accessing a DB2 table

Document ID : KB000074874
Last Modified Date : 27/03/2018
Show Technical Document Details
Issue:
How to generate a batch report for the top plans accessing a DB2 table?
Resolution:
The process of creating your own report is documented in the CA Detector(r) for DB2 for z/OS - 19.0 CA Detector(r) for DB2 for z/OS Pages 226 to 250. Here are the steps:
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 high-level.CDBASRC(PDTBATCH) sample member shows the parameters for this data set.
2 Create DB2 tables if you don't have done that yet. The DDL are located in CDBASAMP(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 CA Detector(r) for DB2 for z/OS DB2 tables. To load collection data into DB2 tables, edit one of the following jobs. These jobs are provided in hlq. CDBASRC to include a valid JOB statement, DB2 subsystem ID, libraries for your site, and your system user ID for utility data sets: PDTLOAD Loads collection data into DB2 tables using the IBM LOAD utility. PDTLOADC Loads collection data into DB2 tables using CA Fast Load for DB2 for z/OS
4- You can query the tables to generate your customized report.