Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Supported commands


This topic describes the supported commands that you can edit and run directly from 

BMC AMI Command Center for Db2

.

Note

The HDDL command is available if you have a valid license for the BMC AMI Database Administration for Db2 solution.

Command

Button
(in the Classic console)

Description

DDL

ddl-24.png

Displays the Data Definition Language (DDL) for a selected object

HDDL

hddl-24.png

Displays the Hierarchical Data Definition Language (HDDL) for the selected object and its dependents

DCL

dcl-24.png

Displays the Data Control Language(DCL ) for the selected object

DROP

drop.png

Displays the DROP command for the selected object

BIND

bind-24.png

Displays the BIND command for the selected package, plan, or collection ID

REBIND

rebind-24.png

Displays the REBIND command for the selected package, plan, or collection ID

FREE

free-24.png

Displays the FREE command for the selected package or plan

DISPLAY

display-24.png

Displays the status of the selected object

START

execute-24.png

Displays the START command for a database, table space, table, index, view, or stored procedure

STOP

stop-24.png

Displays the STOP command for a database, table space, table, index, view, or stored procedure

SELECT

g_gud_select-24.png

Displays the SELECT command for a table, alias, or view

INSERT

g_gud_insert-24.png

Displays the INSERT command for a table, alias, or view

UPDATE

g_gud_update-24.png

Displays the UPDATE command for a table, alias, or view

DELETE

g_gud_delete-24.png

Displays the DELETE command for a table, alias, or view

NA

Invokes a native or external stored procedure

NA

Displays the TERM command for a BMC PLUS utility



 

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