The following topics are provided:
The IBM DB2 Database plug-in includes 19 out-of-box reports (Figure 5-1):
Figure 5-1 IBM DB2 Database Plug-in Reports
To generate a new report from one of the out-of-the-box reports provided by Oracle, follow these steps:
Table 5-1 shows the BI Publisher Enterprise Reports that are provided by Oracle:
Table 5-1 IBM DB2 Database Plug-in Reports
Report Name | Description |
---|---|
IBM DB2 Database DB Manager Configuration |
Displays Database Manager Configuration Information for IBM DB2 Database. |
IBM DB2 Database System Configuration |
Displays System Configuration Information for IBM DB2 Database. |
IBM DB2 Database Container Health |
Displays Container Health Statistics for IBM DB2 Database. |
IBM DB2 Database DB Health |
Displays Database Health for IBM DB2 Database. |
IBM DB2 Database DB Manager Health |
Displays DBM Health Statistics for IBM DB2 Database. |
IBM DB2 Database Tablespace Health |
Displays Tablespace Health Statistics for IBM DB2 Database. |
IBM DB2 Database Applications CPU Usage |
Displays Applications CPU Usage for IBM DB2 Database. |
IBM DB2 Database Applications Lock Performance |
Displays Applications Lock Performance for IBM DB2 Database. |
IBM DB2 Database Applications Row Accesses and Sorts Performance |
Displays Applications Row Accesses and Sorts for IBM DB2 Database. |
IBM DB2 Database Bufferpool and Non-Buffered IO Statistics |
Displays Bufferpool and Non-Buffered IO Statistics for IBM DB2 Database. |
IBM DB2 Database Cache Statistics |
Displays Cache Statistics for IBM DB2 Database. |
IBM DB2 Database DB Manager Agents and Connections Statistics |
Displays DBM Agents and Connections Statistics for IBM DB2 Database. |
IBM DB2 Database DB Manager Sorts Statistics |
Displays DBM Sorts Statistics for IBM DB2 Database. |
IBM DB2 Database Locks Statistics |
Displays Database Locks Statistics for IBM DB2 Database. |
IBM DB2 Database SQL Statement Performance |
Displays SQL Statement Performance for IBM DB2 Database. |
IBM DB2 Database Sort Heap and Hash Join Statistics |
Displays Sort Heap and Hash Join Statistics for IBM DB2 Database. |
IBM DB2 Statement and Lock Wait Analysis |
Displaying Information about the Analysis of the Most Active SQL Statements and Lock Waits of the DB2 Database. |
IBM DB2 Database DB Disk Storage Statistics |
Displays DB Disk Storage Statistics for IBM DB2 Database. |
IBM DB2 Database Tablespace Statistics |
Displays Tablespace Statistics for IBM DB2 Database. |
If the IBM DB2 Database plug-in is deployed or upgraded after BI Publisher is already configured and the reports were not deployed automatically, execute the following command:
emcli deploy_bipublisher_reports -pluginid="oracle.em.sidb" -pluginversion="12.1.0.4.0" -force
To view the out-of-box templates, from the Enterprise menu, select Monitoring and then Monitoring Templates. Using the Target Type drop down, select IBM DB2 Database and press the arrow button.
A complete list of all out-of-box monitoring templates will be available for use as follows (see Figure 5-4):
Basic IBM DB2 Monitoring Template: Recommended basic template for monitoring IBM DB2.
IBM DB2 I/O Monitoring Template: Recommended template for monitoring IBM DB2 I/O.
IBM DB2 Lock Monitoring Template: Recommended template for monitoring locks and deadlocks in IBM DB2.
Figure 5-4 IBM DB2 Database Plug-in Monitoring Templates
To apply a monitoring template to an IBM DB2 Target, perform the following actions:
The Actions button found on the Monitoring Templates screen will also give access to setting a selected template as "Default" for all new IBM DB2 Target deployments, or Edit an existing template's threshold values.
Refer to the Using Monitoring Templates chapter in the Oracle Enterprise Manager Cloud Control Administrator's Guide for more information on how to use Monitoring Templates in Enterprise Manager Cloud Control 13c.