InfoTrace Modernization Guide

InfoTrace captures DB2 SQL statement execution details, providing insights into performance bottlenecks and resource consumption. It allows users to identify long-running queries, frequently executed statements, and inefficient SQL code.

InfoTrace uses configuration files to define tracing parameters, such as the DB2 subsystems to monitor, the types of SQL statements to capture, and the level of detail to include in the trace data. These files are typically maintained by system administrators.

InfoTrace supports integration with other Infotel products, such as INFO-OPTIMIZER, to provide a comprehensive solution for DB2 performance management. It may also offer APIs for integration with third-party monitoring and analysis tools.

InfoTrace captures SQL statement text, execution statistics (CPU time, elapsed time, I/O counts), bind variables, and other relevant information. The level of detail can be configured to balance the need for comprehensive data with the overhead of tracing.

The trace data is typically stored in DB2 tables or sequential datasets. The format of the data is documented in the InfoTrace manuals.

InfoTrace uses standard z/OS security mechanisms, such as RACF, ACF2, or Top Secret, to control access to its functions and data. User management is typically handled by system administrators.

Common commands include START TRACE (to begin tracing), STOP TRACE (to end tracing), DISPLAY TRACE (to view trace status), and MODIFY TRACE (to change tracing parameters).

By identifying and resolving performance bottlenecks, InfoTrace helps to improve application response times, reduce resource consumption, and increase overall system throughput. This can lead to cost savings and improved user satisfaction.

InfoTrace provides detailed insights into DB2 SQL statement execution, enabling developers and DBAs to optimize SQL code and database design. This can lead to significant performance improvements and reduced costs.

Improved application performance can lead to increased user satisfaction, reduced operational costs, and a better overall business outcome.

InfoTrace leverages z/OS security features, such as RACF, ACF2, or Top Secret, to control access to its functions and data. It supports role-based access control (RBAC) to restrict access based on user roles.

InfoTrace provides audit logging capabilities to track user activity and system events. This information can be used for security monitoring and compliance reporting.

InfoTrace does not encrypt the trace data itself. However, the underlying DB2 system may use encryption to protect sensitive data.

InfoTrace is administered through a combination of ISPF panels and command-line interfaces. System administrators use these interfaces to configure tracing parameters, manage user access, and monitor system activity.

InfoTrace provides monitoring capabilities to track the performance of DB2 subsystems and the overhead of tracing. This information can be used to optimize tracing parameters and ensure that tracing does not negatively impact system performance.

InfoTrace generates log files that contain information about system events, errors, and user activity. These log files can be used for troubleshooting and auditing.