REORG Utility (Indexes) panel

You use the REORG Utility (Indexes) panel to generate utility control statements using the REORG INDEX form of the REORG utility.

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.

Parent panels

Child panels

None.

Related tasks