In Db2 environments with high transactional workload, the near-time history keeps a short time period of accounting data. When further history analysis is required, users cannot take the advantage of the available online history reports in SYSVIEW for Db2.
To address this problem we introduced a specialized data collector mode as an online alternative to batch reports for analysis of history data (PTF LU02118). Users can designate a data collector for history access only using the new system parameter DC-HISTORY-MODE, and dynamically switch between the allocated CA SYSVIEW for DB2 history files.
Please note that when in History-Only DC mode, only history reports are available, no new Db2 data is collected or processed.
To get started, submit a job that allocates new history files, loads them with Db2 statistics from an SMF file, and starts the data collector in this mode. New sample JCLs that are available in the SOURCE library include all these steps. Submit IDB2HDCJ (job) or IDB2HDCS (started task) to start the data collector in History-Only mode. Below are few screenshots illustrating key ISPF panels to interact with:
This is available through PTF LU02118, feel free to leave us a comment below if you have any questions or feedback.
For further readings, please check: