Use the Report Manager to create and organize data reports, add existing Toad or Excel reports, or generate reports.
To create a report
Select Tools | Reports | Report Manager from the menu.
Right-click a folder and select Create Report.
Complete the wizard and design the report.
Save the report.
To add the report to the Reports Manager window:
To generate an existing report
Select Tools | Reports | Report Manager from the menu.
Double-click the existing report.
Review the following for additional information:
|
Direction |
Select the direction of variable from the list. |
|
Value |
Enter the value of the variable. Note: Enter a percent (%) in this field to generate all values. |
Tips:
To add an existing Toad or Excel report to the Report Manager, right-click the Report Manager window and select Add Existing Report.
To send a Toad or Excel report via email or to a shared folder or other location, right-click the report, select Send To, and then select an option.
The following reports are available from the Reports Manager (Tools | Reports | Reports Manager).
| Report Name | Description |
|---|---|
| Activity |
Lists and describes activity reports that the Activity Monitor for the current DB2 for LUW database uses. This report also lists the switches required to gather data for a specific activity report. Toad uses the AM_BASE_RPTS table function to generate this report. |
| ADMIN_LIST_HIST_V82 | Displays information from the database history table for the DB2 for LUW database partition to which Toad is currently connected. Toad uses the ADMIN_LIST_HIST table function to generate this report. |
| Database Partitions | Shows information about each database partition on the current DB2 for LUW database. Toad uses the DB_PARTITIONS function to gather this information from db2nodes.cfg. |
| DB Manager Config Info | Lists the database manager configuration parameters and their values defined for the current DB2 for LUW database. |
| HEALTH_CONT_HI | Shows the current "health" status of all containers that tablespaces in the current DB2 for LUW database use. Toad uses the HEALTH_CONT_HI table function to generate this report. |
| HEALTH_CONT_HI_HIS | Shows a "health" history for all containers that the tablespaces in the current DB2 for LUW database use. Toad uses the HEALTH_CONT_HI_HIS table function to generate this report. |
| HEALTH_CONT_INFO | Identifies the containers that tablespaces in the current DB2 for LUW database use and lists the highest current alert status for each container. Toad uses the HEALTH_CONT_INFO table function to generate this report. |
| HEALTH_DB_HI | Shows the "health" status of the current DB2 for LUW database, including its highest current alert status. Toad uses the HEALTH_DB_HI table function to generate this report. |
| HEALTH_DB_HI_HIS | Shows the "health" history of the current DB2 for LUW database. Toad uses the HEALTH_DB_HI_HIS table function to generate this report. |
| HEALTH_DB_HIC | Shows the "health" status of objects in the current DB2 for LUW database. Toad uses the HEALTH_DB_HIC table function to generate this report.s |
| HEALTH_DB_HIC_HIS | Displays a "health" history for objects in the current DB2 for LUW database. Toad uses the HEALTH_DB_HIC_HIS table function to generate this report. |
| HEALTH_DB_INFO | Shows the highest current alert status for the current DB2 for LUW database. Toad uses the HEALTH_DB_INFO table function to generate this report. |
| HEALTH_DBM_HI | Shows the "health" status for the current DB2 for LUW instance. Toad uses the HEALTH_DBM_HI table function to generate this report. |
| HEALTH_DBM_HI_HIS | Shows a "health" history at the database manager level for the current DB2 for LUW instance. Toad uses the HEALTH_DBM_HI_HIS table function to generate this report. |
| HEALTH_DBM_INFO | Shows the highest current alert status for the current DB2 for LUW instance. Toad uses the HEALTH_DBM_INFO table function to generate this report. |
| HEALTH_TBS_HI | Shows the "health" status of all tablespaces in the current DB2 for LUW database. Toad uses the HEALTH_TBS_HI table function to generate this report. |
| HEALTH_TBS_HI_HIS | Shows a "health" history for tablespace in the current DB2 for LUW database. Toad uses the HEALTH_TBS_HI_HIS table function to generate this report. |
| HEALTH_TBS_INFO | Shows the highest current alert status for each tablespace in the current DB2 for LUW database. Toad uses the HEALTH_TBS_INFO table function to generate this report. |
| Index Statistics | Displays statistics for the indexes under the current schema for the DB2 for LUW database and flags those indexes that need reorganization. Toad uses the REORGCHK_IX_STATS procedure to generate this report. |
| Installed DB2 Products | Lists the DB2 for LUW 9 products currently installed on your system. Toad uses the ENV_GET_PROD_INFO table function to generate this report. Products can include the following: RTCL DB2 Run-Time Client CONSV DB2 Connect Server (any edition) CONPE DB2 Connect Personal Edition |
| Installed DB2 Products_V82 |
Lists the DB2 for LUW 8 products currently installed on your system. Toad uses the ENV_GET_PROD_INFO table function to generate this report. Products can include the following:
|
| Instance Information_V82 | Lists details about the current DB2 for LUW instance. Toad uses the ENV_GET_INST_INFO table function to generate this report. |
| Recommendations for Activity Reports | Provides recommendations (in English) for the various activity reports that the activity monitor uses. Toad uses the AM_BASE_RPT_RECOMS table function to generate this report. |
| SNAP_GET_CONTAINER _V82 | Displays information and statistics about each container that tablespaces in the current DB2 for LUW 8 database use. To generate this report, Toad uses the SNAP_GET_CONTAINER table function to retrieve information from the tablespace_container logical data group. |
| SNAP_GET_DB_V82 | Lists information and statistics captured for the current DB2 for LUW 8 database. To generate this report, Toad uses the SNAP_GET_DB table function to retrieve information from the database and detail_log logical data groups. |
| SNAP_GET_DYN_SQL_V82 | Lists statistics and information about the dynamic SQL statements executed against the current DB2 for LUW 8 database use. To generate this report, Toad uses the SNAP_GET_DYN_SQL table function to retrieve information from the dynsql logical data group. |
| SNAP_GET_TAB_V82 | Lists information and statistics about the tables in the current DB2 for LUW database 8. To generate the report, Toad uses the SNAP_GET_TAB table function to retrieve information from the table logical data group. |
| SNAP_GET_TBSP_PART_V82 | Lists information and statistics for the database partitions that make up each tablespace in the current DB2 for LUW 8 database. To generate this report, use the SNAP_GET_TBSP_PART table function to retrieve information from the tablespace_nodeinfo logical data group. |
| SNAP_GET_TBSP_V82 | Lists information and statistics for each tablespace in the current DB2 for LUW 8 database. To generate the report, Toad uses the SNAP_GET_TBSP table function to retrieve information from the tablespace logical data group. |
| SNAPSHOT_AGENT_V82 | Lists the agents working for the various applications connected to the current DB2 for LUW 8 database. To generate the report, Toad uses the SNAPSHOT_AGENT function to retrieve information from the application snapshot, especially from the agent logical group. |
| System Information_V82 | Displays information about the operating system in which the current DB2 for LUW 8 database operates and about the CPUs configured on this operating system. Toad uses the ENV_GET_SYS_INFO table function to generate this report. |
| Table Statistics Column View | Displays statistics for the tables under the current schema in the DB2 for LUW database and flags those tables that need reorganization. Toad uses the REORGCHK_TB_STATS procedure to generate this report. |
| Table Statistics | Displays statistics for the tables under the current schema in the DB2 for LUW database and flags those tables that need reorganization. Toad uses the REORGCHK_TB_STATS procedure to generate this report. |
The following reports are available from the Reports Manager (Tools | Reports | Reports Manager).
| Report Name | Description |
|---|---|
| Help Topic | Displays the first 10 rows of the mysql.help_topic table. |
The following reports are available for the Toad Sample Database in the Reports Manager (Tools | Reports | Reports Manager):
| Report Name | Description |
|---|---|
| Customer orders | Displays customer orders for contact IDs less than 10 from the Toad sample database. It is an example of master detail display using a single result set. |
| Customer list | Displays a list of customers from the Toad sample database. |
| Items to order | Displays items in stock that have a quantity of less than 50 and should be reordered from the Toad sample database. |
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center
