Application Audit Online Help
Compuware Enterprise Services
Fault Analytics
ISPW Web Interface
ThruPut Manager Web
Topaz For Java Performance
Topaz for Total Test Web Client User Guide
- Welcome to Topaz for Total Test
- Topaz for Total Test Non-virtualized Test Overview
- Getting Started
  - Getting Started Tutorial
  - Using the Web Client
  - Create a Test Suite from Browser
- Test Virtualization
  - Test Virtualization
  - Stubs in the Web Client
  - Recording Input Data to Sub Modules
- Extending Non-virtualized Test with Custom Data Definitions
- Code Coverage
- Configuring the Topaz for Total Test Repository Server
- Working with the Repository
  - Working with the Repository
  - General Information for All Artifacts
  - Defining and Using Components
  - Components in the Web Client
  - Connections
  - Environments
  - Systems
  - Categories
  - User Groups
  - Skins/Data and Execute
  - Stubs
  - Job Definitions
  - Dataset Skins
  - Test Scenarios
  - Suites
  - Reports
- Sample Programs
- Appendix A Tutorial Add a Component to the Repository with the Web Client
- Welcome to Topaz for Total Test
- Get a License
- Topaz for Total Test Functional Test Overview
- Getting Started
  - Getting Started Tutorial
  - Using the Web Client
  - Create a Test Suite from Browser
- Test Virtualization
  - Test Virtualization
  - Stubs in the Web Client
  - Recording Input Data to Sub Modules
- Extending Functional Test with Custom Data Definitions
  - Extending Functional Test with Custom Data Definitions
  - Extending a Test Scenario
  - Extending the Execution Context
- Code Coverage and IDz Integration
  - Code Coverage and IDz Integration
  - Browser Client
  - Eclipse Client
- Utility Tools
  - Utility Tools
  - Environment Specific Host UserIDs
  - Management Of Saved Host Credentials
  - Browse Datasets
  - Get Job Info and Spool Files
  - Copy And Delete Datasets
- Configuring the Topaz for Total Test Repository Server
  - Configuring the Topaz for Total Test Repository Server
- Working with the Repository
  - Working with the Repository
  - General Information for All Artifacts
  - Defining and Using Components
  - Components in the Web Client
  - Connections
  - Environments
  - Systems
  - Categories
  - User Groups
  - Skins/Data and Execute
  - Stubs
  - Job Definitions
  - Dataset Skins
  - Test Scenarios
  - Suites
  - Reports
  - Schedules
- Sample Programs
  - Sample Programs
  - Program XAPGMTST
  - Program XADB2TST
  - Program XAMOCTST
  - Program XAPGMCAL
  - Program XAPGMBT1
  - Program XARISCAL
  - Program XADTSTMP
  - Program XADGTIME
  - Program XADUTF8
iStrobe Online Help

DDF SQL Activity Exec View

DDF SQL Activity Exec View shows the distribution by Package of CPU and elapsed time used by SQL statements for an executing statement within a Package that ran in the DDF address space.

PROFILE_NAME	The name of the profile.
JOB_MEASUREMENT_TS	The timestamp when the Strobe measurement was started.
PACKAGE_NAME	Package name specifies the package for which SQL Analysis produces SQL access path information.
EXEC_STMT_NUM	The number of the SQL statement generated and executed on behalf of the target statement.
EXEC_STMT_TEXT	The text of the SQL statement generated and executed on behalf of the target statement.
TARGET_STMT_NUM	The statement number of the user's SQL statement as generated by Strobe for Db2 DDF.
TARGET_STMT_TEXT	The SQL text of the user's SQL statement.
TARGET_STMT_TYPE	This shows the category to which the target statement belongs: Static - non-cursor Static - cursor Dynamic - non-cursor Dynamic - cursor
CPU_STMT_CNT	Shows the number of SQL statement executions.
ELAPSED_AVG_TM_SEC	Shows the total elapsed time in seconds divided by the total SQL statement count.
ELAPSED_MAX_TM_SEC	Shows the most amount of elapsed time in seconds used by any one SQL statement.
ELAPSED_TOTAL_TM_SEC	Shows the total amount of elapsed time used, which is the Avg Elapsed time multiplied by the total SQL count for this Package.
PARALLEL_SP_CPU	Shows the CPU time in seconds executed on a specialty processor such as a zIIP while in parallel processing for the SQL statement.
PARALLEL_TOTAL_CPU	Shows the CPU time in seconds executed in parallel processing on all processors for the SQL statement.
CPU_AVG_TM_SEC	Shows the total in_DB2 SQL CPU time in seconds for the Package divided by the total SQL statement count for the Package.
CPU_MAX_TM_SEC	Shows the greatest amount of in_DB2 SQL CPU time in seconds used by any one of the SQL statements in the Package.
CPU_TOTAL_TM_SEC	The in_DB2 SQL CPU time in seconds used by this Package during the measurement. This includes the in_DB2 SQL CPU time from all parallel execution on both central and special processors.