Catalog Manager commands
Command | Description |
|---|---|
ACCEL | From a table list, adds a table to an accelerator From an accelerator list (ACC), enables you to control an accelerator From an accelerator table list (ACCTB), provides access to Db2 accelerator commands that enable you to perform the following tasks:
|
2WL (Deprecated with PTF BQU0719 applied) | When used from the SQL Table list, creates a worklist from the selected SQL member |
ANALYZE | Displays a SELECT, INSERT, UPDATE, DELETE, or DECLARE CURSOR SQL statement from the Catalog Manager SQL_Table You can invoke the SQL Explorer Analysis function to analyze the SQL. |
APPLY | Creates SQL statements by using a model with host variables into which Catalog Manager will substitute values from the Db2 catalog The name of the host variable should correspond to the column name of the value to be substituted. |
AUDIT | Displays rows from the Catalog Manager Audit Log table |
BATCH | Generates JCL for a Catalog Manager job to run in batch mode Use BATCH when lengthy processing time makes running the job online undesirable. |
BROWSE | Invokes the Catalog Manager data browsing feature to browse data in the selected table or view |
CALL | Displays the Call Stored Procedure panel for the selected procedure On the panel you can set the parameters and execute the stored procedure. The output of the procedure is stored in the SQL OUTPUT data set, which is defined on the Datasets panel (OPT 4). |
CANCEL | Terminates the current display without saving any changes that might have been made |
CASCADE | Displays the privileges that the REVOKE command would revoke for the specified user |
CATALOGHELP | Displays information about columns in the Db2 catalog tables |
CLIPBOARD | Displays the Confirm SQL panel for the contents of the Catalog Manager clipboard On this panel, you can edit, save, and execute the SQL from the clipboard. Catalog Manager saves changes in the Catalog Manager SQL_Table, not in the clipboard. |
CLIST | Allows Catalog Manager to execute a CLIST that is available but is not in the commands table |
CMD | See COMMANDS. |
COMMANDS | Lists the valid Catalog Manager commands for the current list type For example, different commands are listed for table spaces and columns. |
COPYAUTHS | Generates SQL that will copy authorizations from a source user to a target user and will grant authorizations from a source object to a target object |
CUSTOMIZE | Allows you to customize the Catalog Manager Primary Menu panel to include a subset of the options |
D | Displays the catalog row for the selected object |
DCL | Generates GRANTs for explicit privileges that are held on an object or by a user |
DDL | Displays the DDL for the selected object |
DES | Displays a subset of the description that is provided by the DESCRIBE command for tables, databases, and DBRM packages |
DESCRIBE | Displays catalog information about the selected object In some instances, the information might come from more than one catalog table; for example, a DESCRIBE command on a database displays the plans that are associated with the database. |
DOPTS | Displays the installation options for this session of Catalog Manager |
DROPRECOVERY | Displays a list of objects that Catalog Manager dropped with Recovery On specified and allows you to select an object to recover |
EDIT | Invokes the Catalog Manager data editing feature to edit data in the selected table or view |
ENVIRONMENT | Displays some of the Catalog Manager variables You can use the ENVIRONMENT command to verify the plans and modules that are in use. |
EXPLAIN | Displays rows from the ownerName.PLAN_TABLE for the object |
F FIND | Find strings in customizable list columns |
GET | When used with the DESCRIBE command, displays a SELECT, INSERT, UPDATE, DELETE, or DECLARE CURSOR SQL statement that is stored in a DBRM or a package You can invoke the SQL Explorer Analysis function to analyze the SQL. |
HC | Displays a panel to build, edit, and submit a job to print the Catalog Manager PRINT data set while Catalog Manager is running |
HDDL | Generates hierarchical DDL (HDDL) for the selected object Catalog Manager options determine which dependent objects are included in the dependent DDL. (BMC.DB2.SPE2307) To determine which dependent objects are included in the DDL when you issue the HDDL command, use the OPTS or OPT option (such as HDDL OPTS). These options display the Object Options panel before the Confirm SQL panel. For more information about the Object Options panel, see Setting-object-use-options. |
HGRANT | Generates SQL GRANT statements to show the privileges that are held on the object for which the command was entered and for any dependent objects |
HSTATS | Generates SQL to migrate statistics to another Db2 subsystem Catalog Manager options determine the following DML contents:
|
HTDDL | Generates hierarchical DDL for the selected table, its dependent objects, parent database, and parent table space Catalog Manager options determine which dependent objects are included in the dependent DDL. (BMC.DB2.SPE2307) To determine which dependent objects are included in the DDL when you issue the HTDDL command, use the OPTS or OPT option (such as HTDDL OPTS). These options display the Object Options panel before the Confirm SQL panel. For more information about the Object Options panel, see Setting-object-use-options. |
IMPORT | Copies SQL from a PDS into the Catalog Manager SQL_TABLE You must issue this command from the Command line. |
JOIN | Builds an SQL SELECT statement template for multiple tables Enter JOIN on the first table or view in the list that you want to be included in the join. Enter an equal sign (=) on all other tables or views to be included. |
LCAT | Invokes a CLIST that executes a VSAM LISTCAT command for the selected data set |
LEDIT | Allows the current list to be edited, saved, or executed as a set of SQL statements |
LOGRBA | Displays the current Db2 log RBA and the associated time stamp LOGRBA also records this information in the Catalog Manager Drop Recovery Log. |
Converts a Db2 basic (6-byte) or extended (10-byte) LRSN value to date and time | |
MAINTAIN | Displays the Log Maintenance Menu, on which you can browse or purge the Session Log, DDL Audit Log, and Drop Recovery Log |
MDDL | Generates DDL for all objects that you have listed in the command into one stream You can save the information in the SQL_TABLE or a PDS. |
OPTIONS | Displays the Catalog Manager options panels |
ORDER | Allows you to specify the order in which columns will be displayed from left to right across a list |
PACKIT | Converts a plan to use only packages A PACKIT command generates a series of DSN commands, first to bind each DBRM referenced by the plan into a package and then to bind the plan again by using the packages instead of the original DBRMs. |
When issued on the Command line, prints the current list When issued on a list, a DESCRIBE command is executed and the output is routed to the PRINT data set. The PRINT command opens the data set for output the first time that you issue the command in each session. Additional print output is appended to the data set until you issue the HC command to submit the data set for printing or the PRINT CLOSE command to close and deallocate the data set. | |
PROFILE PROFILES | When issued on a list, displays the Profiles List panel, which lists all of the customized session profiles for Catalog Manager When issued on the Command line of the Utility Selections panel, PROFILE displays a list of user and site profiles for the selected utility type or types. When issued on the Command line of a Db2 command panel, PROFILE saves the Db2 command syntax to a Db2 command profile. (BMC.DB2.SPE2304) PRO is no longer a valid abbreviation for this command. |
REFRESH | When issued on the Command line, rebuilds the current list to include any changes that have occurred since the list was originally built |
RESET | Removes values and other input information from the list line (such as the information that results from running the COUNT command) |
RESPONSES | Restores the results of list line commands after using RESET to remove them |
S | Displays the information from the Db2 catalog for the selected row |
SEARCH | Discards all current lists and creates a new list based on the search criteria that you specify |
SESSION | Displays the current Session Log records |
SET | Allows you to change the current SQLID, several Catalog Manager switches, the rules for executing Type 2 CONNECT statements, and the session profile in use |
SORT | Allows you to sort the list by any displayed column |
SQL | Produces a list of saved SQL members |
SYSTEM | Displays records from the Session Log of actions taken |
TAILOR | Displays a command list that you can tailor for a specific profile |
TIMESTAMP | Converts a Db2 plan or package contoken to date and time |
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.BMCCLIB library. |
TYPES | Displays the valid abbreviations for all of the object types |
X | When entered in the Cmd column of a list line, excludes objects from being processed by the command that you specify on the Command line When issued from the Command line, the X command excludes all objects |
XX | Excludes all of the objects between the first XX command and the next XX command that you enter in the Cmd column of a list line from being processed by the command that you specify on the Command line |
X nnn | Excludes the object in a list line and the objects in the following nnn list lines from being processed by the command that you specify on the Command line |