The Database Manager Summary drilldown displays global summary information about all active databases and partitions in the DB2 for LUW (Linux, Unix, and Windows) instance you are monitoring. In a single-partition environment, only the All Nodes data is presented.
Note: For detailed information about a particular database or database partition, use the Databases drilldown.
When you select a specific database or database partition from the list, a set of tabs appear in the lower half of the window. These tabs contain additional details and activity statistics about the specific database, allowing you to drill down for more information about a problem.
If monitor heap failure becomes a problem, use this formula, taken from the IBM System Monitor Guide and Reference, to adjust the MON_HEAP_SZ parameter.
( number of monitoring applications + 1 ) * ( number of databases * (800 + ( number of tables accessed * 20 ) + ( (number of applications connected + 1) * (200 + (number of tablespaces * 100) ) ) ) ) / 4096
You can click any column header at the top of the grid to sort the database list by the contents of that column. Sorting the list by the various status and interval measurement columns can help identify problem databases. You can also rearrange the order of the columns, and hide columns in the grid to put focus on the information you want to view.
The summary information that the Database Manager Summary drilldown displays is as follows:
The following tabs appear on the Database Manager Summary drilldown to provide additional information about a selected database or database partition: