Trends

View IBM DB2 database performance and utilization metrics in a trend graph. Select an Instance, a Database and up to three IBM DB2 metrics. Metric options include (among others) ACT_WAIT_CPU_TIME, AVG_LOCK_TIMEOUTS, ROWS_READ_PER_ROWS_RETURNED and UTILS_PROC_TIME_PERCENT.

Choose a Time Range or click ellipse_button00115.gif to specify your own. Mouse-over to see additional details.

db2_trends.gif

title_bar_shortNew00116.gif

 

 

Log Scale

Select to enable a logarithmic scale. Use Log Scale to see usage correlations for data with a wide range of values. For example, if a minority of your data is on a scale of tens, and a majority of your data is on a scale of thousands, the minority of your data is typically not visible in non-log scale graphs. Log Scale makes data on both scales visible by applying logarithmic values rather than actual values to the data.

 

 

Base at Zero

Select to use zero (0) as the Y axis minimum for all graph traces.

 

Time Range

Select a time range from the drop down menu varying from 2 Minutes to Last 7 Days, or display All Data. By default, the time range end point is the current time. To enter a specific time range, click the associated ellipsis button ellipse_button00117.gif.

trend_timerange00118.gif

To change the time range click the Open Calendar button calendar_button00119.gif, choose the date and time, then click OK. Or, enter the date and time in the text field using the following format: MMM dd, YYYY HH:MM:ss (for example, Aug 21, 2011 12:24 PM) and click Apply. Use the Navigation Arrows button_forwardback00120.gifto move forward or backward one time period (the time period selected from the Time Range drop-down menu). Click Restore to Now to reset the time range end point to the current time.