Skip to Content
Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Configuring automatic data collection

Use the following procedure to configure automatic collection of data for use in the PADB.

Related topic

Setting-up-Performance-Advisor

  1. Copy the NGLARCH member from hlq.llqSAMP to your SYS1.PROCLIB (or equivalent) started task.Doing so allows for the automatic submission of the NGL9ARCH utility each time a Data Collector log file becomes full or each time the Data Collector SWITCH command is issued. NGLARCH creates an archive data set. This data set contains all data from the log file that was filled or switched from.

  2. At the DOMPLEX option set panel for your DOMPLEX, expand DB2 Monitor List to define the SQL statistics collection interval for each Db2 subsystem.For best results, align your interval definitions so that an interval ends at midnight each day. This approach aligns the daily, weekly, and monthly tables. Otherwise, the table aggregations include data from the end of the aggregation period until the end of the interval.

    Information
    Example

    If your SQL statistics collection interval ends at 2 A.M. instead of midnight, your daily tables cover the period from 2 A.M. on the indicated day until 2 A.M. the following day; however, the INTVTIME column for this table shows a time of midnight.

  3. Set up an automatic Data Collector SWITCH.A log file switch should occur when the last SQL statistics collection interval concludes each day and the ApptuneUNLOAD process completes. The switch tells the NGLARCH started task to populate your archive data sets with data for the Performance Advisor tables (typically, shortly after midnight), and can be implemented using an automated Data Collector SWITCH command. Implement this using the system automation tool of your choice

    Success

    Tip

    You can set the switch with an automated Data Collector SWITCH command using the system automation tool of your choice. You can also set the switch by submitting a job that runs the DOMBSWIT utility.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

SQL Performance for DB2 13.1