All Databases Grid

This display provides a grid view of a subset of data in the All Databases Table display.

Each grid object is a different database on the selected instance. Each has a trend graph that traces the Commits per second, Rollbacks per second and Response Time for the database. Choose a Time Range for the trend graph to trace, or select All Data to include all available data in the trace. Scroll forward and backward in the trend graph and click Reset to return to the original state.

Show Expired databases first using Sort By: Expired. Or sort by instance name, database name or connected state.

Toggle Sort Descending to order the grid objects.

Investigate performance metrics details for a databasein the Database Summary display by clicking on the (left or right side of the) grid object.

db2_allDbs_grid.gif

title_bar_shortNew00061.gif

 

Instance:

Select an instance.

Database Count:

The number of databases in the display.

Sort By:

Orders the grid objects as follows:

  • Instance: Instance names.

  • Database: Database names.

  • Connected: Databases that are connected.

  • Expired: Databases that are in an expired state.

Sort Descending

Toggle on to order the grid objects.

Time Range

Choose a time range for the trend graph to trace, from 2 minutes to 7 days, or choose All Data to include all available data. The selected time range applies to all grid objects in the display.

Grid Objects

Each grid object is a different database and values describe each database.

 

Connected

The database connectionstatus:

red_indicator_light00062.gif Red indicates that the database is disconnected.

green_indicator_light00063.gif Green indicates that the database is connected.

 

Expired

When checked, performance data has not been received within the time specified by your administrator for the Expire Time.

If your administrator has also set the Delete Time, this grid object will be deleted if no data is received within the time specified for deletion.

 

Database

The name of the database.

 

Trend Graph

  • Commits/s Traces the number of commits per second.

  • Rollbacks/s Traces the number of rollbacks per second.

  • Response Time Traces the amount of time to respond.