Identifying an object type
Type the appropriate code to choose an object type.
For example, to create a list of all databases, type DB in the Obj type field and press Enter. Catalog Manager generates a list of all databases in the current catalog.
Object types displayed on the Primary Menu panel
Object type code | Object type |
|---|---|
AL | Alias |
BP | Buffer pool |
CA | Column authorization |
CD | Check dependent |
CI | Collection ID |
CK | Check constraint |
CL | Column label 1 |
CP | Constraint dependent |
CO | Column |
CX | Trusted context |
CXA | Trusted context authorization ID 2 |
CXT | Trusted context attribute 2 |
C2 | Check constraint (for tables created in Db2 Version 7 or later) |
DB | Database |
DM | DBRM |
DS | Data set 1 |
DT | Data or distinct type |
EN | Environment variables |
FK | Foreign key 4 |
FN | Function routine |
FO | Routine option |
FP | Routine parameter |
FS | Routine source |
IC | Image copy 1 |
IL | IP list |
IN | IP name |
IP | Index space partition |
IS | Index space |
ISS | Index space statistics 3 |
IX | Index |
IXC | Index cleanup |
JB | Jar object |
JC | Jar contents |
JP | Java option |
JT | Java path |
KC | Key column 1 |
KT | Key-target |
KTD | Key-target distribution 4 |
KTDH | Key-target distribution history |
KTDS | Key-target distribution statistics history |
KTH | Key-target history 4 |
KTS | Key-target statistics 4 |
KU | Key column user |
LL | LU list |
LM | LU mode |
LO 1 | Location |
LS | LU mode select |
LU | LU names |
MQT MQ (main menu) | Materialized query table |
NP | Native SQL procedure |
OB | Online schema changes |
Object events | |
OS | LOBSTATS |
PA | Plan authorization 1 |
PG | Package |
PI | Packlist 1 |
PK | Primary key 1 |
PL | Plan |
PM | Row permissions |
PR | Stored Procedure |
Package statements | |
PT | Index and table space partition |
RD | Object role dependency |
RE | Relation |
RO | Roles |
SC | Schema |
SE | Identity column |
SG | Storage group |
ST | String |
SU | System privilege user |
SY | Synonym |
TB | Table |
TC | Table constraint |
TN | Table names list Lists all object in SYSTABLES regardless of the type. |
TP | Table space partition |
TR | Trigger |
TS | Table space |
TSS | Table space statistics |
UA | User authorization 1 |
UN | User name |
US | User |
UTL | Utilities (from the SYSUTILITIES catalog table) |
VAR | Variables |
VW | View |
XC | BMC Next Generation Technology Copy for DB2 for z/OS cabinet copy |
XR | XML relationship |
XS | XML string |
XT | Auxiliary table 2 |
1The product displays the object type on the panel if the Distributed Data Facility (DDF) is defined to Catalog Manager.
2An auxiliary table contains a single large object (LOB) column. An auxiliary table resides in an auxiliary (or LOB) table space.
3This object code is also available from a CX list.
4This object code is valid if DDF is defined to Catalog Manager.
5This object code is also available from an IS list.
6This object code is also available from a KT list.
7This object code is valid for displaying limit keys on a table that uses table-controlled partitioning.
8This object code displays only the tables in the table space that have referential integrity.
The following table lists the Db2 object types that are supported but are not displayed on the Primary Menu panel. Unless otherwise noted, you can enter the code in the Obj Type field or on the Command line on the Primary Menu panel. Press HELP from the Primary Menu panel to list all supported object types.
Object type code | Object type |
|---|---|
AU | Authorization 1 |
DP | Dependency |
IM | Index mixed 1 |
LK | |
MX | Mixed object types 1 |
RI | Referential integrity 1 |
TM | |
TT | Table space set 1 |
1This object code is not valid in the Obj type field of the Primary Menu panel.
2This object code is also available from a CX list.
3This object code is valid if DDF is defined to Catalog Manager.
4This object code is also available from an IS list.
5This object code is also available from a KT list.
6This object code is valid for displaying limit keys on a table that uses table-controlled partitioning.
7This object code displays only the tables in the table space that have referential integrity.
The following table lists the four-character object type codes that are available from the Command line of a KT list.
Object type code | Type |
|---|---|
KTDH | Key-target distribution history |
KTDS | Key-target distribution statistics history |