List commands
In addition to these list commands, you can use the codes displayed across the top of each list panel to produce other lists. The available codes depend on the type of object that the product displays.
The following table lists all the codes and describes the type of list produced:
Level-one list command | Description |
|---|---|
When entered in the Cmd column of a list line, the Navigation Commands List panel lists all of the valid list commands for that line. You can generate a secondary list from the Navigation Commands List panel by entering a listed command on the Command line. On the Command line, this command is not valid. | |
ACC | Lists all the accelerators defined on the system |
ACCPG | Lists all the accelerator packages |
ACCTB | Lists all accelerator tables defined on an accelerator |
AL | Lists the aliases for the selected object |
APO | Lists the audit policies in the SYSIBM.SYSAUDITPOLICIES table |
ARH | Lists historical information about autonomic stored procedures in the SYSIBM.SYSAUTORUNS_HIST table |
ATS | Lists statistics alerts from autonomic stored procedures in the SYSIBM.SYSAUTOALERTS table |
ATW | Lists time windows for running autonomic stored procedures in the SYSIBM.SYSAUTOTIMEWINDOWS table |
AU | Lists the authorizations |
BP | Lists the buffer pool privileges |
BR | Invokes the options for the Catalog Manager data browsing function To invoke the IBM Db2 data editor (if it is installed) and browse data from TB, VW, SY, and AL lists, uncomment the BR command in the Catalog Manager commands table. |
CA | Lists the column authorizations |
CD | Lists the check constraint dependencies |
CI | Lists the collection IDs |
CK | Lists the check constraints |
CL | Lists the column labels |
CO | Lists the columns |
CP | Lists the constraint dependencies |
CX | Lists the trusted contexts |
CXA | Lists the authorization IDs for trusted contexts |
CXT | Lists the attributes for trusted contexts |
C2 | Lists the check constraints (for tables created in Db2 Version 7 or later) |
DB | Lists the databases |
DM | Lists the DBRMs |
DP | Lists the dependencies |
DS | Lists the data sets When used with the SYSPROC.ADMIN_DS_LIST stored procedure, the DS command can display data set information on a remote SSID. |
DT | Lists the data types |
ED | Invokes the options for the Catalog Manager data editing function To invoke the IBM Db2 data editor (if it is installed) and edit data from TB, VW, SY, and AL lists, uncomment the ED command in the Catalog Manager commands table. |
EN | Lists the environments |
FK | Lists the foreign keys |
FN | Lists the routines (functions) |
FO | Lists the routine (function) options |
FP | Lists the function parameters |
FS | Lists the SQL procedure sources |
IC | Lists the image copies |
IL | Lists the IP addresses for a given location |
IM | Displays a mixed list with each index on one line, and each key column on a following line in key order |
IN | Lists the location names and IP addresses of remote systems. |
IP | Lists the index partitions |
IS | Lists the index spaces |
ISS | Lists the index space statistics from the SYSIBM.SYSINDEXSPACESTATS catalog table, which stores real-time statistics ( RTS) |
IX | Lists the indexes |
IXC | Lists the time windows that specify index cleanup processing from the SYSIBM.SYSINDEXCLEANUP table |
JB | Lists the objects from the installed JAR |
JC | Lists the Java class information for the installed JAR |
JP | Lists the build options that were used to build the installed JAR |
JT | Lists the Java paths |
KC | Lists the key columns |
KT | Displays the contents of the SYSIBM.SYSKEYTARGETS catalog table, which contains key-targets of extended indexes |
KTD | Displays the contents of the SYSIBM.SYSKEYTGTDIST catalog table, which contains distribution information for key-targets of extended index keys |
KTDH | Displays the contents of the SYSIBM.SYSKEYTGTDIST_HIST catalog table, which contains history information for key-targets of extended index keys |
KTDS | Displays the contents of the SYSIBM.SYSKEYTGTDISTSTATS catalog table, which contains the key-targets of data-partitioned secondary indexes |
KTH | Displays the contents of the SYSIBM.SYSKEYTARGETS_HIST catalog table, which contains history information for key-targets of extended indexes |
KTS | Displays the contents of the SYSIBM.SYSKEYTARGETSTATS catalog table, which contains partition statistics for key-targets of extended index keys |
KU | Lists the constraint key columns |
LI MX objectType qualifier | When issued from the Command line, displays a secondary list that shows multiple object types associated with certain source object types The object name must be fully qualified. |
LIST | When entered in the Cmd column of a list line, produces a sublist qualified by the object name on the current list Using LIST from the Command line discards all current lists and creates a new level-one list. LIST is also an ISPF command. To use the command on the Command line, you must either abbreviate the command (enter LI or LIS) or precede it with the command recognition character. |
LK | Lists the limit keys |
LL | Lists the logical unit (LU) names for a location from the SYSIBM.LULIST table |
LM | Lists the limits for LUNAMEs and MODENAMEs from the SYSIBM.LUMODES table |
LO | Lists the accessible remote locations from the SYSIBM.LOCATIONS table |
LS | Lists the mode names for SQL requests from the SYSIBM.LUMODESELECT table |
LU | Lists the remote locations that communicate with DB2 from the SYSIBM.LUNAMES table |
MK | Lists the column masks from the SYSIBM.SYSCONTROLS table |
MQT | Lists the materialized query tables |
MX | Displays a mixed list showing objects that are dependent on the selected object |
NP | Lists the native SQL stored procedures |
OB | Lists the online schema changes |
Displays the contents of the SYSIBM.SYSOBJEVENTS catalog table, which contains object level information and details about objects processed by a utility execution. | |
OS | Displays the contents of the SYSIBM.SYSLOBSTATS catalog table, which contains the statistics from LOB table spaces |
PA | Lists the plan authorizations |
PDD | Lists information about the objects that have pending changes to data definitions from the SYSIBM.SYSPENDINGDDL table |
PG | Lists the packages The PG command can be issued on a sequence object in a Sequences List. The dependency of the package on the sequence object must be specified in the SYSIBM.SYSPACKDEP catalog table. |
PGC | Lists the package copies from the SYSIBM.SYSPACKCOPY table |
PI | Lists the packages that a plan can use |
PK | Lists the primary keys |
PL | Lists the plans |
PM | Lists the row permissions from the SYSIBM.SYSCONTROLS table |
PR | Lists the procedures |
PS | Lists the package statements from the SYSIBM.SYSPACKSTMT table |
PSD | Displays the contents of the SYSIBM.SYSPACKSTMTDEP catalog table, which contains dependency information for statements in the SYSPACKSTMT catalog table. |
PT | Lists the partitions |
QRO | Lists the optimization parameters for queries from the SYSIBM.SYSQUERYOPTS table |
QRP | Lists the plan hint information for queries from the SYSIBM.SYSQUERYPLAN table |
QRY | Lists the queries from the SYSIBM.SYSQUERY table |
RD | Lists the object role dependencies |
RE | Lists the referential constraints from the SYSIBM.SYSRELS table |
RI | Displays the referential integrity list, which shows all tables and relations contained in the selected object The RI list also displays an asterisk (*) on the rows in which an object is included in the selected object. |
RO | Lists the object roles |
SC | Lists the schemas |
SE | Lists the identity columns in sequences from the SYSIBM.SYSSEQUENCES table |
SG | Lists the storage group objects |
SSR | Lists the SmartSwitch rules |
SST | Lists the contents of the SmartSwitch tracking table, which contains information on when, why, and whether classic utilities are switched to BMC AMI Utilities |
ST | Lists the strings |
SU | Lists the system privileges for the AUTHID pattern that you entered |
SVC | Lists the contents of the SYSIBM.DSNSERVICE table, which contains information on the IBM Db2 REST services. |
SY | Lists the synonyms |
SYNC | Lists the columns from the BMCSYNC table for the BMC utilities The BMCSYNC table contains information about the status of the objects that the currently executing utilities are accessing. This command is valid only from a BMCUTIL list or from rows for BMC utilities in a STATUS list. |
TB | Lists the tables |
TBP | Lists the table profiles from the SYSIBM.SYSTABLES_PROFILES catalog table |
TC | Lists the column authorizations |
TM | Displays a mixed list of table space sets |
TN | Lists the type of object and the qualified table name The product lists the following Catalog Manager object types:
|
TP | Lists the table space partitions |
TR | Lists the triggers |
TS | Lists the table spaces |
TSS | Lists the table space statistics from the SYSIBM.SYSTABLESPACESTATS catalog table, which stores real-time statistics (RTS) |
TT | Lists the table space sets |
UA | Lists the user authorizations |
UN | Lists the user names |
US | Lists the users (authorization IDs) |
UTL | Displays the contents of the SYSIBM.SYSUTILITIES catalog table, which contains details for utilities in the SYSCOPY catalog table. |
VAR | Lists the global variables from the SYSIBM.SYSVARIABLES table |
VL | Lists the volumes |
VW | Lists the views |
XC | Lists the BMC AMI Copy cabinet copies |
XR | Lists the XML relationships |
XS | Lists the XML strings |
XSR | Displays a mixed list of the Db2 for z/OS XML schema repository (XSR) tables that store XML schema documents from the SYSIBM.XSROBJECTS and related XSR catalog tables |
XT | Lists the auxiliary and base tables |