Indexes panel
You use the Indexes panel to list index object types in the Db2® catalog.
Panel and field definitions
The columns that are displayed include the SEL field and columns of SYSIBM.SYSINDEXES.
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────
ZDT/Db2 (DFG2) Indexes
Location: Format TABL
+
SEL CREATOR NAME TBNAME TBCREATOR UNIQUEE
* * * * *
---- #2--+----1-- #1--+----1----+--- #3--+----1----+--- #4--+----1-- #48-+--
**** Top of data ****
CARLAND XPMR91932 PMR91932 CARLAND Unique
DSN8810 XACT1 ACT DSN8810 Unique
DSN8810 XACT2 ACT DSN8810 Yes
DSN8810 XCONA1 TCONA DSN8810 Yes
DSN8810 XDEPT1 DEPT DSN8810 Unique
DSN8810 XDEPT2 DEPT DSN8810 Duplica
DSN8810 XDEPT3 DEPT DSN8810 Duplica
DSN8810 XDSPTXT1 TDSPTXT DSN8810 Yes
DSN8810 XEMP1 EMP DSN8810 Unique
DSN8810 XEMP2 EMP DSN8810 Duplica
DSN8810 XEMPPROJACT1 EMPPROJACT DSN8810 Yes
Command ===> Scroll PAGE
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F6=RChange
F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel
Note:
- The system option, Show all catalog table columns, affects which columns ZDT/Db2 displays when you use the Object List utility.
- You can also customize which columns ZDT/Db2 displays when you use the Object List utility. For details, see the Z Data Tools Customization Guide.
To view other columns on this panel, press the Right function key (F11).
For
a complete list of columns, refer to Db2® catalog
tables
in the DB2 for z/OS SQL Reference relevant
to your version of Db2®.
- SEL
- Line command area. For a list of the line commands you can use on this panel, see Object list line commands.
Parent panels
Child panels
To display this panel… | Use/do this |
---|---|
Alter Index panel | Line command A |
Columns in Index panel | Line command COL |
Create Index panel | Line command CR |
Databases panel | Line command D |
See Drop panels | Line command DR |
Generate SQL From Db2 Catalog panel | Line command GEN |
Details panels | Line command I |
Recovery Information panel | Line command ICS |
Application Packages panel | Line command PKG |
Application Plans panel | Line command PL |
Index Parts panel | Line command PT |
Display Row panel | Line command ROW |
Tables, Views and Aliases panel | Line command T |
Db2 Utilities panel | Line command UTL |
Sort Fields panel | Primary command SORT |