Expetune DB Modernization Guide

Expetune DB analyzes static and dynamic SQL statements to identify performance bottlenecks. It gathers Explain data without executing the SQL, analyzes access paths, and highlights inefficient SQL code.

Expetune DB identifies inefficient SQL statements, analyzes access paths to DB2 data, and provides recommendations for optimization. It helps reduce CPU consumption and improve application response times.

Expetune DB can analyze both static SQL embedded within application programs and dynamic SQL submitted at runtime. This comprehensive analysis helps identify performance issues across the entire application landscape.

Expetune DB gathers Explain data without requiring the actual execution of SQL statements. This allows for performance analysis in a non-production environment without impacting production systems.

Expetune DB analyzes access paths used by DB2 to retrieve data. It identifies inefficient access paths that lead to full table scans or excessive I/O operations. It provides recommendations for creating or modifying indexes to improve access path efficiency.

Expetune DB uses configuration files to define DB2 subsystem parameters, SQL statement thresholds, and reporting options. These files allow users to customize the analysis process to meet specific requirements.

Expetune DB does not expose public APIs. It primarily functions as a standalone performance analysis tool.

Expetune DB communicates with DB2 using standard DB2 call interfaces. It retrieves Explain data and SQL statement information directly from DB2.

By identifying and optimizing inefficient SQL statements, Expetune DB reduces CPU consumption, improves application response times, and lowers overall IT costs. It helps organizations achieve better performance with existing infrastructure.

Expetune DB helps organizations improve the performance of critical business applications that rely on DB2 databases. By optimizing SQL and access paths, it ensures that applications can handle increasing workloads and deliver timely results.

Expetune DB helps reduce the need for costly hardware upgrades by optimizing existing SQL and database configurations. It allows organizations to maximize the utilization of their current infrastructure.

Expetune DB leverages the security features of the underlying z/OS and DB2 environments. It relies on DB2's authentication and authorization mechanisms to control access to sensitive data and functions.

Expetune DB uses the access control model provided by DB2. Access to DB2 data and functions is controlled through DB2's grant and revoke mechanisms.

Expetune DB does not directly encrypt data. It relies on DB2's encryption capabilities to protect sensitive data at rest and in transit.

Expetune DB provides monitoring and logging capabilities to track SQL analysis activities, identify potential performance issues, and ensure system stability. Logs can be reviewed to identify trends and troubleshoot problems.

Expetune DB is administered through a combination of ISPF panels and batch jobs. ISPF panels are used for interactive configuration and analysis, while batch jobs are used for automated analysis and reporting.

User management in Expetune DB is handled through z/OS security mechanisms, such as RACF. Access to Expetune DB functions is controlled through RACF profiles and permissions.