Share Your Product Experience
Help the community by sharing your experience with mainframe products. Your insights help others make informed decisions.
Share Your ExperienceProduct Overview
The architecture of BMC AMI SQL Explorer for Db2 comprises several key components designed to optimize SQL performance within a Db2 environment on z/OS. The primary components include the SQL Analyzer, the Access Path Optimizer, the Object Browser, and the BMC Common Explain component. The SQL Analyzer parses SQL statements, checks for syntax errors, and enforces predefined coding standards.
The Access Path Optimizer analyzes the access paths used by SQL statements, identifying potential performance bottlenecks and suggesting optimizations. The Object Browser provides a view of the Db2 objects accessed by SQL statements, aiding in understanding data relationships and object dependencies. The BMC Common Explain component enhances the Db2 Explain functionality, providing detailed information about query execution plans.
These components communicate through the z/OS environment, leveraging Db2's internal catalog and statistics. The tool is administered through a TSO/ISPF interface, providing a CLI for configuration and management. User access is managed through the z/OS security system, supporting RBAC.
The tool interacts directly with the Db2 database, utilizing Db2's internal mechanisms for analysis and optimization. Compared to other Db2 performance tools, BMC AMI SQL Explorer for Db2 offers enhanced integration with the BMC AMI suite and a focus on SQL coding standards enforcement.
Frequently Asked Questions
Related Products
More from BMC
3270 SUPEROPTIMIZER/CICS
Supported3270 SUPEROPTIMIZER/CICS is designed to optimize 3270 data streams originating from CICS applications on z/OS. The core functionality centers around real-time compression and decompression of...
View Details →3270 SUPEROPTIMIZER/IMS
Not SupportedAlternatives available
3270 SUPEROPTIMIZER/IMS was designed to optimize 3270 data streams from IMS applications. The core functionality involved intercepting 3270 data, compressing it using proprietary algorithms, and...
View Details →Administrative Assistant for DB2
SupportedAdministrative Assistant for DB2 is a comprehensive suite designed to enhance the efficiency and reduce the complexity of DB2 database administration on z/OS. The product...
View Details →Alter for DB2
SupportedAlternatives available
Alter for DB2 simplifies the process of modifying Db2 resources on z/OS. The tool's architecture centers around an ISPF interface, which interacts with Db2 to...
View Details →Application Restart Control for DB2
SupportedARC/DB2 and AR/VR are designed to enhance the reliability and efficiency of batch processing in Db2 environments on z/OS. The primary function is to provide...
View Details →Application Restart Control for IMS
SupportedAlternatives available
Application Restart Control for IMS provided a solution for batch job restart and backout within IMS environments. The system comprised the Restart Manager, Checkpoint Manager,...
View Details →Similar Products
4Tune
Not SupportedAlternatives available
4Tune was a performance monitoring solution for z/OS systems, offering real-time and historical insights into system behavior. It collected data via SMF records and proprietary...
View Details →Ab Initio BRE is a comprehensive BRMS designed to streamline the development, deployment, and maintenance of rules-based applications. The core components include the Rule Engine,...
View Details →Access Manager for CICS
SupportedAccess Manager for CICS provides a robust solution for integrating CICS applications with Oracle databases on z/OS. The product's architecture includes the CICS Interface, Oracle...
View Details →Access Manager for IMS
SupportedAccess Manager for IMS provides a solution for integrating IMS applications with Oracle databases on z/OS. The primary components include the IMS Connect client, the...
View Details →ACCOLADE
SupportedACCOLADE is a software solution designed to streamline the development and maintenance of CICS/COBOL applications on z/OS and zVSE. It functions as a CASE toolset...
View Details →Adabas Caching Facility
ActiveAdabas Caching Facility (ACF) is designed to optimize ADABAS database performance by caching frequently accessed data in memory. The main components include the Cache Manager,...
View Details →Help Improve This Directory
Notice outdated information? Have insights about this product? Help the mainframe community stay informed with accurate, current data.
Are You a Vendor? Claim Your Listing
Take control of your product listings. Add verified information, showcase updates, and unlock a Claimed Vendor badge across the directory.
Claim Your Listing Now