Business Intelligence Tutorial

Monitoring a database

The performance monitor provides information about the state of DB2 Universal Database and the data that it controls, and calls attention to unusual situations. The information is provided in a series of snapshots, each of which represents the state of the system and its databases at a point in time. You can control the frequency of the snapshots and the amount of information collected by each.

The information that is collected by a performance monitor is returned in performance variables. These performance variables are a defined set of elements that can:

To monitor the LOOKUP_MARKET table:

  1. From the DB2 Control Center, right-click the LOOKUP_MARKET table, and click Performance Monitoring --> Start Monitor....

    The Start Monitor window opens.

  2. The Start Monitor window lists the performance monitors that can take snapshots at the table level. Select the Default_for_table_level monitor, and click OK to start it.

    The Default_for_table_level is an IBM-supplied monitor that is designed to collect key performance related information at the table level.

  3. Right-click on the LOOKUP_MARKET table and select Performance Monitoring --> Show Monitor Activity....

    The Show Monitor notebook opens.

    The Details page lists the performance variables that are being collected by the monitor and the values that are returned by the snapshots. The Default_for_table_level monitor takes snapshots (Regular sample box) every 30 seconds, and does not graph its collected data. You can tailor this monitor to your own preferences (for example, graph performance variables or change snapshot interval). See the online help for details.

  4. If there is no activity on the LOOKUP_MARKET table, then the values on the Details page will remain blank. To generate table activity:
    1. Open the Command Center.
    2. On the Script page, do the following:
      1. Issue connect to TUTWHS user userid using password, where:
      2. Issue a number of SELECT * FROM schema.LOOKUP_MARKET statements, where schema is the schema that was specified when the database was created.Lesson 2, Creating a warehouse database.
      3. Click Script-->Execute to run the script.
    3. Return to the Show Monitor notebook. As snapshots are taken, the values for the Rows Read per Second performance variable will reflect your SQL statement activity.
  5. Close the Show Monitor notebook. Right-click on the LOOKUP_MARKET table and click Performance monitoring --> Stop monitor. The Default_for_table_level monitor stops.


[ Top of Page | Previous Page | Next Page | Table of Contents ]