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 Catalog Manager for Db2 13.1.

Db2 action commands

Catalog Manager generates the following Db2 commands.

Related topic

Commands


To execute a command, type the command in the Cmd column next to an appropriate item on a list. The following table lists the Db2 action commands:

Command

Description

ACTIVATE

For a native SQL procedure, generates an SQL ALTER PROCEDURE ACTIVATE statement

ACTIVATE is valid only for stored procedures in which ORIGIN is N.

ALTER

Generates an SQL ALTER statement for the object

BIND

Displays the Bind panels, from which you can perform the following tasks:

  • Use the Explain option to indicate whether access path information is saved in ownerName.PLAN_TABLE.
  • Input options to bind plans, packages, or DBRMs.

BINDCOPY

Binds all packages in a collection ID (CI) into a different CI, or binds all packages in a list into a single CI

BINDDEPLOY

Displays the Bind Deploy Package panel, from which you can specify the locations to which you want to generate BIND commands

If the locations or wildcard pattern that you specify do not match any locations in your SYSIBM.LOCATIONS table, the product does not generate any BIND DEPLOY commands. However, if the locations or wildcard pattern match more than one location, the product groups the commands for the selected packages by location name.

For a native SQL procedure, the command generates a DSN BIND PACKAGE DEPLOY statement.

BINDDEPLOY is valid only for packages in which TYPE is N.

COMMENT

Displays a panel to generate SQL to create or replace a comment on an alias, table, distinct type, function, index, procedure, trigger, or view

CONNECT

Enables you to remain in your current Catalog Manager session and access another Db2 subsystem on the same or another z/OS system

COUNT

Executes an SQL COUNT(*) statement for an object and displays the number of rows in the object

CREATE

Displays a panel from which you can input options to create an object

If entered on a list line, CREATE works as a CREATE LIKE of the object.

DB2COMMAND

Lists the Db2 commands that have been saved

Enter DB2COMMAND PROMPT to display the same panel as the Db2 Commands action from the Catalog Manager Primary Menu.

DCLGEN

Displays panels from which you can input options to create DSN DCLGEN commands

DELETE

Builds an SQL DELETE template for a table or view, and invokes the ISPF editor to allow you to customize the template

DIS

DISPLAY

Displays the status of the selected object

DISDATABASE

Displays the status of the selected database

DISTHREAD

Displays active threads for the current subsystem

DROP

Generates an SQL DROP statement for the specified object and displays the Confirm SQL panel

From this panel, you can select actions and options, including the drop recovery option.

When you issue the DROP command on the Pending DDL List panel, Catalog Manager generates the ALTER TABLESPACE DROP PENDING CHANGES statement.

When you issue the DROP command on an advanced trigger with multiple versions, Catalog Manager generates the following command and drops only the specified version of the advanced trigger:

ALTER schema.triggername TRIGGER DROP version

DSNZPARM

Executes either the IBM SYSPROC.ADMIN_INFO_SYSPARM or SYSPROC.DSNWZP stored procedure and formats the information for display

Note

Db2 requires MONITOR1 authorization.

EXCHANGE

Exchanges data between two tables, one of which must be a clone of the other table

FREE

Generates SQL to free versions of plans or packages depending on the option provided.

The following table lists the parameters that specify the plan management (PLANMGMT) options for the FREE PACKAGE commands:

Option

Description


Generates SQL to free active versions of plans or packages

Displays the Free Package panel from which you can input options.

ALL

Generates SQL to free all versions of the plans or packages

Specifies the Db2 PLANMGMTSCOPE(ALL) clause

INACT

INACTIVE

Generates SQL to free inactive versions of plans or packages

Specifies the Db2 PLANMGMTSCOPE(INACTIVE) clause

PREV

PREVIOUS

Generates SQL to free previous versions of plans or packages

Specifies the Db2 PLANMGMTSCOPE(PREVIOUS) clause

ORIG

ORIGINAL

Generates SQL to free original versions of plans or packages

Specifies the Db2 PLANMGMTSCOPE(ORIGINAL) clause

PHASE

PHASEOUT

Generates SQL to free phased-out versions of plans or packages

Specifies the Db2 PLANMGMTSCOPE(PHASEOUT) clause

The following table lists parameters that limit the included plans or packages:

Parameter

Description

ALL

If entered in the Cmd field, specifies the Db2 PLANMGMTSCOPE(ALL) clause.
If entered on the Command line, generates SQL to include all plans or packages in a list except those you marked for exclusion with an X in the Cmd field.

INVALID

INVALIDONLY

Specifies the INVALIDONLY(YES) parameter.

GRANT

Generates SQL to grant privileges

INSERT

Builds an SQL INSERT statement template for a table or view, and invokes the ISPF editor to allow you to customize the statement

LABEL

Generates an SQL LABEL command for the selected object

QCONNECT

Displays the Connections List panel, which lists saved connections from the current SSID

If no saved connections exist, QCONNECT displays the Change Access panel, from which you can type parameters for a connection.

REBIND

Displays the Rebind panels, from which you can perform the following tasks:

  • Use the Explain option to indicate whether access path information is saved in OwnerName.PLAN_TABLE
  • Input options to rebind plans, packages, or DBRMs

REFRESH

When issued on a list line of a materialized query table (MQT), as REFRESH integer refreshes the data in the MQT

integer represents the number that is associated with the SQL statement in the QUERYNO clause.

REGENERATE

Regenerates the data in a view or an index

REGENERATE also generates an ALTER PROCEDURE REGENERATE VERSION statement for a native SQL procedure. REGENERATE is valid only for stored procedures in which ORIGIN is N.

RENAME

Displays a panel to input a new table, index, or column name and generate RENAME SQL

REVOKE

Displays panels from which you can input options to revoke privileges

SEE

Allows you to modify Db2 special registers

SELECT

Generates an SQL SELECT statement for the specified table or view, and displays a confirmation panel

START

Executes the DB2 START DATABASE command

From a table space list, START CLONE executes the START DATABASE command for a clone table.

STOP

Executes the DB2 STOP DATABASE command

From a table space list, STOP CLONE executes the STOP DATABASE command for a clone table.

TRANSFER

Transfers ownership of a supported object (database, index, storage group, table space, table, or view) from a user to a ROLE or another user

TRUNCATE

Deletes all rows for a base or global temporary table

UPDATE

Builds an SQL UPDATE statement template for a table or view, and invokes the ISPF editor for you to customize the statement

 

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