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 setsYou 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 statementsFor 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 outputYou can browse Job Entry Subsystem (JES) jobs running on the LPAR where the UIM server is active.
• Executing Db2 commandsYou can navigate to a Db2 object and display and edit the syntax of a command for any of the supported Db2 commands. For more information, see Supported-commands.
• Migrating object statisticsYou 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 schemasYou 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 recoveryYou 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 DDLYou can edit and generate ALTER DDL for databases, table spaces, tables, indexes, native procedures, and storage groups.
• Managing object setsYou can create and edit object sets, and share object sets with other BMC products that use them.
• Setting up BMC AMI Utility ManagerYou 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 rulesThe 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 are using the most resources to run.

• Assuring SQL DML statement quality  (SPE2104)

   
  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 (BMC.DB2.SPE2110)
  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.