Db2 Tools

 View Only

SYSVIEW for Db2: New History-Only Data Collector Mode

  • 1.  SYSVIEW for Db2: New History-Only Data Collector Mode

    Broadcom Employee
    Posted Aug 19, 2021 11:39 AM




    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:


    History-Only Data Collector Mode - Main Menu (new)

     


    History-Only Data Collector Mode - Manage history files(new)


     

    Thread History List(Tailored to History-Only Data Collector Mode)

     

    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: