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
 ──────────────────────────────────────────────────────────────────────────────
 FM/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:
  1. The system option, Show all catalog table columns, affects which columns FM/Db2 displays when you use the Object List utility.
  2. You can also customize which columns FM/Db2 displays when you use the Object List utility. For details, see the File Manager 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

Related tasks

Related references