REORG Utility (Indexes) panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)              REORG Utility (Indexes)          Row 1 to 12 of 344


 S P                                 U C C              Reuse
 e R Index    Index              Prt n l l Cls Leaf Off Data
 l C Owner  + Name             + Num i g d Rat Dist Pos Set
     fmdb2    TABLE19_UNIQUE       0 U Y Y   ?   ?    ?   N
     fmdb2!   TABLE20_UNIQUE       0 U Y Y   ?   ?    ?   N
     thing    ix1                  0 U Y N   ?   0    ?   N
     ARROWSB  T1_IX1               0 P Y Y   ?   ?    ?   N
     ARROWSB  T3_IX1               0 P Y Y   ?   ?    ?   N
     ARROWSB  XDEPT1               0 P N N   ?   ?    ?   N
     ARROWSB  XDEPT2               0 D N N   ?   ?    ?   N
     ARROWSB  XDEPT3               0 D N N   ?   ?    ?   N
     ARROWSB  XEMP1                1 P Y Y   ?   ?    ?   N
     ARROWSB  XEMP1                2 P Y Y   ?   ?    ?   N
     ARROWSB  XEMP1                3 P Y Y   ?   ?    ?   N
     ARROWSB  XEMP1                4 P Y Y   ?   ?    ?   N

 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

Sel

Selection column. Type S to select an index.

PRC

Processing column. An asterisk (*) indicates the selected index.

Index Creator

The name of the creator of the index.

Index Name

The name of the index.

Part Num

The partition number for the index. For a non-partitioned index, this is 0. Partitioned indexes appear as multiple rows, one row for each partition of the index. This is a display-only field

Uni

The UNIQUERULE flag for the index, from the SYSINDEXES catalog table

Clg

The CLUSTERING flag for the index, from the SYSINDEXES catalog table.

Cld

The CLUSTERED flag for the index, from the SYSINDEXES catalog table.

Cls Rat

The CLUSTERRATIO flag for the index, from the SYSINDEXES catalog table.

Leaf Dist

The LEAFDIST flag for the index, from the SYSINDEXPART catalog table.

Off Pos

This is a display-only field. This value indicates the number of rows relocated out of their optimal position for the index. If the CARD value for the index is greater than zero, the value is calculated using the expression:

(AVG(NEAROFFPOS + FAROFFPOS) * 100)/CARD

This value helps you identify indexes that might require organization. For more information, see the DB2 Utility Guide and Reference.

Reuse Data set

Whether Db2® physically deletes and redefines the data sets for the index:

Y

Data set for the index reused.

N

Data set for the index not reused. This is the default setting.