Toad Data Point 6.0 - User Guide

Welcome to Toad Data Point Understand Toad's Workflow

Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint 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

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Manage Reports

About Managing Reports

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. See About Designing Toad Data Reports for more information.
Save the report.
To add the report to the Reports Manager window:
1. Navigate to the open Reports Manager window.
2. Right-click the folder where you want to add the report, and select Add Existing Report.

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.

To share reports with other users, specify a shared network directory in Network Share Options (Tools | Options | Environment | Network Share).

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: ADCL DB2—Application Development Client ADMCL DB2—Administration Client CONEE DB2—Connect Enterprise Edition, DB2 Connect Unlimited Edition, or DB2 Connect Application Server Edition CONPE DB2—Connect Personal Edition CUBE DB2—Cube Views DLM DB2—Data Links Manager ESE DB2—Enterprise Server Edition EXP DB2—Express Edition or DB2 Express Edition processor option GSE DB2—Spatial extender PE DB2—Personal Edition QP DB2—Query patroller RTCL DB2—Run time client WM DB2—Warehouse Manager WSUE DB2—Workgroup Server Unlimited Edition
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.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Toad Data Point 6.0 - User Guide

Manage Reports

About Managing Reports

DB2 Reports

MySQL Reports