BMC AMI SQL Performance for Db2^®

BMC AMI SQL Performance for Db2^® is a complete solution that manages SQL performance throughout the application lifecycle and audits privileged access to reduce risk.

• Perform SQL tuning with lower overhead and a focus on where resources are spent
• Validate SQL during development to ensure valid access paths and uphold SQL best practices
• Gather, manage, and understand historical performance data for trends and forecasting
• Analyze index usage, including identifying unused indexes and modeling index changes, to improve your indexing strategy

Incident and problem management in the database is easy with BMC AMI SQL Performance for Db2^®.

• Rapidly diagnose and track performance problems to their source
• Increase availability by pinpointing resource-consuming SQL statements without running expensive SQL traces
• Anticipate and resolve slowdowns to avoid bad SQL, bad access paths, and costly CPU upgrades
• Evaluate space and performance metrics to determine when reorganization is necessary
• Avoid change and migration problems by comparing workload access paths

This innovative capability provides a Jenkins plugin leveraging BMC AMI SQL Performance for Db2 to interrogate SQL and evaluate it in both its current environment and against target production environments.

• Shift left and ensure that SQL coding standards and performance issues are reported and resolved prior to moving to the next step
• Validate that your SQL syntax follows industry best practices and company standards
• Analyze both Static SQL and Dynamic SQL accessing your Db2 data by capturing and measuring against industry and company standards
• Automatically send alert notifications of exceptions to application developers during the development lifecycle