Product features

The BMC AMI Command Center for Db2 product offers a web-based graphical user interface (GUI) to IBM Db2 application developers and DBAs. With BMC AMI Command Center, you can use a web browser (see Supported browsers) to perform common tasks on your IBM z/OS mainframe.

 
BMC AMI Command Center includes the following features:

• Browsing the Db2 catalog and data sets
  You can browse a Db2 object or set of objects, or any Db2 statement in the Db2 statement cache or in a package. You can also browse data set members and use the Scratchpad text editor to edit them.
• Tuning SQL statements
  For a selected statement, you can create alternative What-If options, use graphical Explain plans to compare the alternatives, and then tune your statement accordingly. In the graphical Explain plan, nodes represent each step in the statement; clicking a node displays details for that step from the Explain plan tables.
• Viewing jobs and job output
  You can browse Job Entry Subsystem (JES) jobs running on the LPAR where the Common Interface Server (CIS) is active.
• Executing Db2 commands
  You can navigate to a Db2 object and display and edit the syntax of the command for any of the supported Db2 commands. For more information, see Supported commands.
• Migrating object statistics
  You can migrate the access path statistics for a set of objects from one subsystem to another, or from one schema to another within the same subsystem.
• Comparing Db2 schemas
  You can compare two sets of data structures and generate reports showing the extent of the required changes. You can also generate Change Definition Language (CDL) that you can save and execute with the ALTER or Change Manager product to make the schema structures identical.
• Managing backup and recovery
  You can generate reports to determine whether your object sets are recoverable. You can also view the progress of an ongoing recovery, and create What-If scenarios to estimate how long it would take to back up or recover.
• Edit and generate ALTER DDL
  You can edit and generate ALTER DDL for databases, table spaces, tables, indexes, native procedures, and storage groups.
• Managing object sets
  You can create and edit object sets, and share object sets with other BMC products that use them.
• Setting up BMC AMI Utility Manager
  You can set up the BMC AMI Utility Manager tables, which are used by the BMC AMI Utility Manager to identify which database objects are to be processed by BMC AMI Utility Manager.
• Managing SmartSwitch rules
  The SmartSwitch feature enables you to take advantage of BMC AMI Utility Manager by using the JCL jobs that you created or generated for your classic utilities. You can use the BMC AMI Command Center to create, edit, and delete SmartSwitch rules 
• Troubleshooting SQL statements
  You can discover SQL statements that return error codes or use the most resources.  You can also view SQL statements that exceed user-defined performance thresholds.
• Trend analysis 
  You can analyze performance trends for SQL statements that use the most resources or violate user-defined performance thresholds.
• Assuring SQL DML statement quality  
  You can view details about SQL DML statements that violate expert rules used to evaluate SQL DML statement performance. You can also manage rules that permit violations of the expert rules.
• Managing site standards for SQL DDL statements 
  You can create rules and rule sets to enforce required schema standards for all application development. You can also manage rules that permit violations of schema rules
• (BMC.DB2.SPE2510) BMC Runtime Insights
  With BMC Runtime Insights, you can gain actionable visibility into Db2 utility usage that helps you manage performance, optimize resources, and support compliance. For more information, see Examining product usage data.
• (BMC.DB2.SPE2507) Generating GRANT statements
  You can generate, edit, and run GRANT DCL statements for the following Db2 objects:
  • Databases (BMC.DB2.SPE2510)
  • Collections (BMC.DB2.SPE2510)
  • Packages (BMC.DB2.SPE2510)
  • Procedures (BMC.DB2.SPE2510)
  • Tables
  • Views
  You can apply privileges to user names and roles that you specify. For more information, see Generating and running GRANT DCL statements.
• (BMC.DB2.SPE2510) Generating REVOKE statements
  You can generate, edit, and run REVOKE DCL statements for tables and views. You can remove privileges from user names and roles that you specify. For more information, see Generating and running REVOKE DCL statements.