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 Centerincludes 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.SPE2507) Generating GRANT statements
    You can generate, edit, and run GRANT DCL statements for tables and views. You can apply privileges to user names and roles that you specify.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*