BMC AMI Command Center for Db2® (previously Workbench for Db2®) provides secure self-service for DBAs and application developers with an intuitive, web-based interface to manage Db2 databases and data.

Modernize your mainframe and make it easier for your DBAs and developers to manage custom Db2 applications

• DBAs and developers can easily access Db2 catalog information
• Leverage powerful what-if technology to improve application SQL performance
• Visualize SQL access paths with BMC Explain with both static and dynamic SQL
• Enable modern access to BMC Db2 applications to manage DBA tasks
• Generate DDL/HDDL for databases or tables to quickly duplicate them in a new environment

Drive greater agility and performance in your business with a modern toolset

Agility: Learn and develop apps easily and quickly

By presenting Db2 database information in an intuitive graphical user interface, BMC AMI Command Center for Db2 makes database information easier to use, faster to manipulate, and simple to learn.

• Explore and interact with Db2 information with a user-friendly, web-based front end
• Organize, build, and share custom workspaces—collections of database objects and information that can be used throughout the development process
• Enforce existing security and permissions, limiting users to only the data and actions for which they have been cleared
• Reduce training time

Performance: Modernize and optimize SQL performance

Use BMC AMI Command Center for Db2® to explore the database catalog and test your SQL against performance thresholds.

• Use advanced BMC Explain capabilities to compare, test, and optimize SQL performance
• Root out potential performance issues by checking SQL code against established best practices and performance guidelines
• Integrate with BMC AMI Apptune for Db2 to quickly identify poor performing SQL in development and production environments