Reports (database)
To access the Reports menu to view the following database statistics, do the following:
- Right-click on the database icon to display the Reports menu.
- From the Reports menu, choose General or Summary, and then choose one of the following reports:
General
Menu command | Description |
|---|---|
Applications Info | displays information on all applications currently connected to the selected database |
Buffer Pool Info | displays all the buffer pool data and index reads and writes that have been performed for a particular database |
Connection Info | displays information on the connection activity for a particular database |
Database Activity Info | displays information regarding the number of binds or precompiles that have been attempted, the last date and time the database was backed up, and the maximum size for the database heap |
General Info | displays general information regarding a particular database |
I/O Activity Info | displays the I/O activity for a particular database |
Lock Info | displays summary information regarding the status of the locks and deadlocks for a particular database |
Logging Activity Info | displays information on the logging activity that has been performed for a particular database |
Sort Activity | displays information on the sort activity that has been performed for a particular database |
SQL Statement Activity | displays information regarding the SQL statement activity that has occurred for a particular database since the first application connected to it or since the DB2 monitor was last reset (whichever has occurred more recently) |
Table Activity Info | displays detailed information on all tables associated with a particular database |
Tablespace Info | displays information regarding all tablespaces associated with the selected database |
Summary
Menu command | Description |
|---|---|
DB Applications By Agent | lists all applications connected to the database, sorted by application ID, and includes a summary that identifies the nodes where subagents were created |
DB Applications By Node | lists all applications connected to the database, sorted by node number |
Tablespace Parameters | Consolidates tablespace parameter statistics from all the nodes in the database configuration and displays the results in tabular format by node. |