Unloading Detector collection data to a sequential file using a batch process.

Products

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

Issue/Introduction

Can SQL collected activity captured by Detector for Db2 for z/OS (PDT) be unloaded with a batch process?

 

Environment

Release : 20.0
Component : Detector for DB2 for z/OS

Resolution

PDT has a batch option to unload data from a data store to a sequential flat file and then load the data into DB2 tables.
The PDTBATCH member in hlq.CDBAJCL provides a JCL job that you can use to unload data.


Documentation links:

Unload Collection Data from a Data Store

Load Collection Data into Db2 Tables