Business Intelligence Tutorial
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:
- Count the number of times something has occurred (counters), for example,
the number of rows read.
- Return the current value (gauge), for example, the number of applications
currently connected.
- Represent the time when something occurred (time stamp), for example, the
time when the last application completed.
- Record the highest value reached (water mark), for example, the maximum
size of the database heap.
To monitor the LOOKUP_MARKET table:
- From the DB2 Control Center, right-click the LOOKUP_MARKET table, and
click Performance Monitoring --> Start
Monitor....
The Start Monitor window opens.
- 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.
- 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.
- If there is no activity on the LOOKUP_MARKET table, then the values on the
Details page will remain blank. To generate table activity:
- Open the Command Center.
- On the Script page, do the following:
- Issue connect to TUTWHS user userid using
password, where:
- 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.
- Click Script-->Execute to run the script.
- 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.
- 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 ]