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.