Offloading data to the Performance History Database
Use the procedures in this section to offload data from your Performance History Files (VSAM files) to a Performance History Database. You can tailor this process to offload selected Performance History Files, intervals, time periods, or data types. The load process maintains data uniqueness across z/OS systems, Db2 subsystems, and Query Monitor Subsystems.
Terminology
- Db2 Offload
- The process of offloading data from Db2 Query Monitor's VSAM Performance History Files to the Db2 tables in Db2 Query Monitor Performance History Database.
- Performance History Database
- A Db2 database consisting of a set of Db2 tables to which you can offload data from Db2 Query Monitor's Performance History Files.
- Performance History Files
- VSAM data sets that hold metrics, exceptions, and notifications by Db2 Query Monitor's collection points. One Performance History File is created for each collection point, for each interval. Db2 Query Monitor dynamically allocates the Performance History Files. You can control the allocation of Performance History File using parameters specified in CQMPARMS.