Introduction
Connect
Create ODBC Connections
Create Oracle Connections
Create SQL Server Connections
Understand Toad Connections
Troubleshoot SQL Server Connections
Understand
Determine the Best Method to Locate Objects
Object Explorer
Filter Databases and Objects
Understand a Table Using the Database Explorer
Search for Objects
Create an Database Diagram to Use as a Query Template
Browse Data in Related Tables
Query
Tutorial: Build a Query Visually
Create Cross-Connection Queries
Reverse Engineer Queries
Build a Subquery
Edit SQL
Editor Shortcut Keys
View Result Sets
Compare Differences in Data
Export Data with One Click Export
Share Excel Linked Queries
Report
Automate
DB2 Reports
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. |
MySQL Reports
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. |
ODBC Reports
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. |
Oracle Reports
The following reports are available from the Reports Manager (Tools | Reports | Reports Manager).
Cluster Reports| Report Name | Description |
|---|---|
| Clusters | Displays cluster information, including the cluster type, definitions, storage parameters, and affected tables. |
| Report Name | Description |
|---|---|
| Invalid objects | Displays any invalid objects for the selected schema and includes a subtotal of all invalid objects for that owner. |
| Loads into shared pool |
Displays packages that have been loaded five or more times, into the Oracle shared pool. Note: You must have DBA privileges for this report. |
| Non-system objects in SYSTEM tables |
Displays any objects in the SYSTEM tablespace that are not owned by SYSTEM. |
| Oracle initialization parameters | Displays the values for all parameters defined in the PFILE for the selected user. |
| Tablespaces near capacity | Displays tablespaces that over 90% full, and do not have the autoextend feature enabled. |
| Total shared pool reload stats |
Displays the number of times objects in the shared pool were reloaded. Note: You must have DBA privileges for this report. |
| User hit ratios | Displays the buffer cache hit ratio users and includes consistent gets, blocked gets, and physical reads. |
| User resource usage | Displays values for resource usage such as CPU used and SQL*Net roundtrips for each user. |
| Report Name | Description |
|---|---|
| Sequences | Displays the sequences that are within 10% of the maximum value. Any sequences that do not have a maximum value set, or those that cycle are excluded from the report. |
| Sequences near max | Displays the sequences that are within 10% of the maximum value. Any sequences that do not have a maximum value set, or those that cycle are excluded from the report. |
| Report Name | Description |
|---|---|
| Arguments of stand-alone stored programs | Displays any parameters required for the selected stored procedure. |
| Object type bodies | Displays the body or source code for a selected object. |
| Object types | Displays the type of objects owned by a user, including whether the objects are valid and when they were created or last modified. |
| Package bodies | Displays the body or source code for a selected package |
| Package specifications | Displays specifications for a selected package, including whether it is valid and when it was created or last modified. |
| Stand-alone stored programs | Displays the source code for a stored program, including the type of program and the last time DDL was generated. |
| Stored functions | Displays a list of stored functions for a selected owner. |
| Stored object with source | Displays a list of all stored programs including their source. |
| Stored procedures | Displays the source for stored procedures for a selected owner. |
| Report Name | Description |
|---|---|
| Synonyms | Displays information for each synonym, including the owner, table owner and name, and the DB link. |
| Report Name | Description |
|---|---|
| Indexes | Displays details for the index definition, storage parameters, and columns included in the index. |
| Non-indexed tables | Displays any tables that have not been indexed for the selected database. |
| Table comments | Displays any comments for the selected table. |
| Tables & columns | Displays all columns for a selected table, including the maximum transactions, used/free blocks, free lists and groups, min/max extents, and columns included in this index. |
| Tables & indexes | Displays any indexes for a selected table, including the status, uniqueness, and columns included in the index. |
| Report Name | Description |
|---|---|
| Triggers & columns | Displays triggers for a selected table, including the trigger event, status, WHEN clause, and columns associated with the trigger. |
| Report Name | Description |
|---|---|
| Sample | Displays a sample user report based on a select * from dual query. |
| Report Name | Description |
|---|---|
| View comments | Displays any comments for the selected view. |
| Views & columns | Displays all columns for a selected view, including the query and columns included in the view. |