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 ALTER and BMC AMI Change Manager for Db2 13.1.

Command line commands


Every panel has a Command line. The Command line usually appears directly beneath the title bar, although its position depends on your ISPF profile.

You can issue Command line commands to:

  • Navigate among panels without using the menus
  • Display BMC environment information
  • Modify the appearance of panels
  • Modify the function of the components of ALTER and BMC AMI Change Manager for Db2
  • Display any BMC Administrative or Utility product message

You can enter the commands listed in the following table in uppercase or lowercase letters. Use the HELP command (F1) from any panel to see what commands are available from that panel. Some panels list frequently used commands at the bottom of the panel.

Command

Description

AI

Displays the Archive Table Information panel

ALTER

Displays the Create, Alter, or Drop Db2 Objects panel

You can issue this command only from the Main Menu.

ATTR

Displays the panel attributes panel, from which you can change screen attributes and attributes for viewing objects with names that are too long to be displayed

ATTR RESET

Resets the screen colors to the default colors

AX

Displays a list of the auxiliary objects that are associated with the large object (LOB) columns in a base table (TBB)

You can issue this command only from the Table Detail Panel (for a base table) or the Table Column Detail panel (for a LOB column).

BROWSE

Invokes the ISPF BROWSE function on a named diagnostic data set

You cannot use the BROWSE command if you specify TERM or SYSOUT for diagnostics. You can issue this command only from a panel in which a data set is named.

CAL

CR AL

Creates an alias

CANcel

Exits the current panel without saving changes

CAX

Creates an auxiliary table space, table, and index for an existing base table from the Table Column Detail panel

CCK

CR CK

Creates a check constraint

CDB

CR DB

Creates a database

CFK

CR FK

Creates a foreign key

CGT

CR GT

Creates a global temporary table

In the Mixed List panel, this command is available for an existing table or base table or from the Command line.

CH

Displays a changed object list from an object Specification panel or Mixed List panel

Orphaned auxiliary indexes are displayed in the Unattached Objects Section of the list.

CIX

CR IX

Creates an index or an auxiliary index for a large object (LOB) column in an existing base table

CM

Displays a comment panel for a table, base table, auxiliary table, table column, view, view column, alias, index, or auxiliary index from the appropriate detail or auxiliary template panel

CMK

CR MK

Creates a column mask for a table

CO

Displays a column list for the object from an object detail panel

CReate

Creates Db2 objects from the Mixed List panel, Changed Objects List panel, detail panel, or create panel

CRP

CR RP

Creates a row permission for a table

CSG

CR SG

Creates a storage group

CSP

CR SP

Creates an external stored procedure or a native SQL stored procedure

CSQ

CR SQ

Creates a sequence

CSY

CR SY

Creates a synonym

CTB

CR TB

Creates a table or an auxiliary table for a large object (LOB) column in an existing auxiliary table space

CTC

Creates a clone table of an existing table

This command is not valid on materialized query tables (MQTs), global temporary tables, other clone tables, or system-period temporal tables.

CTR

CR TR

Creates a trigger

CTS

CR TS

Creates a table space or an auxiliary table space for a large object (LOB) column in an existing base table

CUC

CR UC

Creates a unique or primary constraint

CVW

CR VW

Creates a view

DOPTS

Displays a list of the keywords and values in the installation options module in an ISPF edit session

This list does not include the installation option keywords that have been replaced by keywords in the product options file (POF).

You can assemble the installation options in the session to create an additional installation options module.

DROPALL

Drops all objects in the list

Objects are selected to be dropped if the Act column is blank or marked ‘$’ for space estimation only. In the Mixed List panel, this command also applies to orphaned auxiliary objects. If an auxiliary object has been LIKEd, this command removes the requested changes for the object. That is, the command performs the actions of an UNDOALL command.

DV

Displays the Table Column Default Value panel from the Table Column Detail panel

END

Exits the current panel, saves any changes, and displays the next panel in sequence

ENVI

ENVIRONMENT

Displays the BMC Environment panel that contains information such as product name, version, installation options module name, ship date, and plan names

FInd

Locates character strings in a scrollable list

The syntax of the command is as follows:

FInd[ string,'string', or 'string'][ NEXT, FIRST, LAST, or PREV]

In the preceding syntax line:

  • Keywords are shown in uppercase characters.
  • All parameters are optional.
  • NEXT is the default parameter.

The parameters are described as follows:

  • string

    The string of characters to find. If the string contains spaces, it must be enclosed with single quotation marks. If the string contains single quotation marks, it must be enclosed with double quotation marks. If the string parameter is specified, it must be the first parameter.

  • NEXT—finds the next occurrence of the string
  • FIRST—finds the first occurrence of the string
  • LAST—finds the last occurrence of the string
  • PREV—finds the previous occurrence of the string

If you issue the FIND command with no parameters, the previously found string is located if it exists. If no previously found string exists, the cursor is located at the first item in the list, as displayed on the panel.

FP

Displays the Table Column Fieldproc Parms panel from a Table Column Detail Panel

HELP

Displays help information

HI

Displays the History Table Information panel

ICP

Converts a table to index-controlled partitioning from the Table Detail panel

ID

Displays the Identity Column Detail panel from the Table Column Detail panel

JCLDEBUG OFF/ON

Turns foreground JCL Generation debugging off or on

KY

Displays the Index Keys List panel from an Index Detail panel

For a table that uses table-controlled partitioning, you can type KY to display the Partitioning Key Mixed List panel from the Table Detail panel.

This command is not valid for an index that is defined on an XML column.

LIX

Displays a list of the auxiliary indexes that are associated with a large object (LOB) column from a column detail panel

LK

Displays the Limit Key Detail panel from an Index Partition Detail panel (for index-controlled partitioning) or the Tablespace Partition Detail panel

For a table that uses table-controlled partitioning, you can type LK on the Table Detail panel or the Tablespace Detail panel to display the Tablespace Parts List panel.

LTB

Displays a list of the auxiliary tables that are associated with a large object (LOB) column from a column detail panel

LTS

Displays a list of the auxiliary table spaces that are associated with a large object (LOB) column from a column detail panel

MAINT

Displays the Product Maintenance List panel that contains information about fixes (PTFs) that you have applied to the product and the product components

You can issue this command only from the BMC Environment panel.

MAX

Displays the maximum assigned value for an identity column in the Identity Column Detail panel, or for a sequence in the Create Sequence panel or Sequence Detail panel

MIGALL

Selects all objects, except auxiliary objects, in the mixed list for migration

To migrate the associated auxiliary objects for a table, you must select tables and auxiliary objects from the Migrate Options Overrides panel. You cannot migrate orphaned auxiliary objects.

Objects are selected for migration if the Act column is blank or marked ‘$’ for space estimation only.

MIGRATE

Displays the Migrate Db2 Objects Using Specification panel

You can issue this command only from the Main Menu.

MP

Displays the parameters for a materialized query table (MQT) from the MQT Detail or Create MQT panel

MQT

Converts a table to a materialized query table (MQT) from the Table Detail panel, or creates an MQT from the Create Table panel

On the View Detail panel, you can issue this command to create an MQT that is based on the definition of the view.

MT

Displays text for a materialized query table (MQT) from the Create MQT, MQT Detail, Create MQT Parameters, or MQT Parameters panel

PA

Displays the path for a trigger, view, or check constraint

PEALL

Propagates the estimated space to the primary quantity (PRIQTY) for all of the partitions in an index in the Index Space Estimation panel or in a table space in the Tablespace Estimation (Partitioned) panel

PCO

Displays the Parent Key Columns panel from the Create Foreign Key panel

This command is valid only when the parent table’s primary key is not used.

PK

Displays the Constraint Key Mixed List panel from the Table Detail panel or Table Columns List panel

POP

Toggles pop-up message boxes on or off

PREVIOUS

Exits the current panel and displays the previous panel

PT

Displays an object partition or attribute list panel from a detail or template panel

For a table that uses table-controlled partitioning, you can type PT on the Table Detail panel or the Tablespace Detail panel to display the Tablespace Parts List panel.

SE

Displays space estimation information from a Tablespace Detail or Index Detail panel

SORT

Displays the Sort Specifications panel, from which you can specify the columns on which to sort a list of work IDs

You can specify the sequence of the columns and the order of the data in the columns. You can also sort on a single column by placing the cursor within the heading for that column and pressing Enter. To return to the original sort order, issue the SORT command. If you specify a sequence for the Stat Date column, you cannot specify a sequence for the Stat YYYY, Stat MM, or Stat DD column.

TCP

Converts a table to table-controlled partitioning from the Table Detail panel

TSO POFRESET

TSO POFRESET POF(dataSetName(POFMember))

Resets all of the ISPF variables in the ISPF profile with the variables in the initial POF

TSO POFRESET POF(dataSetName(POFMember)) resets all of the ISPF variables in the ISPF profile with the variables in the specified initial or user POF name.

The POFRESET CLIST enables these commands. The CLIST is located in the HLQ.DBCLIB library.

TX

Displays the view text, trigger text, check constraint text, materialized query table (MQT) text, index on an expression, or index defined on an XML column from the Mixed List panel, a Detail panel, or a Create panel

The product formats some of the text for all of the objects, except for indexes on expressions and indexes defined on XML columns.

UNDOALL

Removes the requested changes for all of the objects on the list

In the Mixed List panel, this command also applies to orphaned auxiliary objects.

VIEWX

Displays the execution status of a work ID from the Execution JCL Processing Interface panel

VL

Displays the Volume List and SMS Classes panel for VCAT-defined table spaces from the Auxiliary Tablespace Attribute Detail panel or the Auxiliary Index Attribute Detail panel

W

Enables you to edit the worklist for a work ID from the WORKID Selection List panel

The work ID must have a status of Analyzed, Exec Strt, or Exec Comp. In addition, the work ID must not be used with an outbound migrate profile that specifies multiple locations, because the profile can be used to generate multiple worklists.

XP

Displays the parameters for an index that is defined on an XML column from the Index Detail or Create Index panel

 

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