REORG Utility (Table Spaces) panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)            REORG Utility (Table Spaces)       Row 1 to 12 of 229


 S P          Table        Avg Avg Unload        Reuse
 e R Database Space    Prt Ind Off External Log  Data
 l C Name     Name     Num Ref Pos (Y/N)   (Y/N) Set
     BILLSDB1 TS1D       0   ?   ?   N       N     N
     BILLSDB1 TS1E       1   ?   ?   N       N     N
     BILLSDB1 TS1E       2   ?   ?   N       N     N
     BILLSDB1 TS1E       3   ?   ?   N       N     N
     BILLSDB1 TS1E       4   ?   ?   N       N     N
     BILLSDB2 UTILTS1    0   ?   ?   N       N     N
     CJMAODA  CJMAOSD    0   0   0   N       N     N
     CJMAODA  CJMAOSE    1   0   0   N       N     N
     CJMAODA  CJMAOSE    2   ?   ?   N       N     N
     CJMAODA  CJMAOSE    3   0   0   N       N     N
     CJMAODA  CJMAOSE    4   ?   ?   N       N     N
     CJMAODA  CJMAOSP    0   0   0   N       N     N

 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel

Sel

Selection column. Type S to select a table space.

PRC

Processing column. An asterisk (*) indicates the selected table space.

Database Name

The name of the database in which the table space is defined.

Table Space Name

The name of the table space.

Prt Num

The partition number for the table space. This is 0 for a non-partitioned table space. Partitioned table spaces appear as multiple rows, one row for each partition of the table space. This is a display-only field.

Avg Ind Ref

This is a display-only field. This is an average value for the number of rows relocated out of their original position. If the table space/partition's cardinality is greater than zero, the calculated value is:

(AVG(NEARINDREF + FARINDREF) * 100)/CARD

This value helps you identify table spaces that might require organization. For more information about these values, see the DB2 Utility Guide and Reference.

Avg Off Pos

This is a display-only field. This is an average value for the number of rows relocated out of their optimal position for all indexes within the table space or partition. The average is for all indexes which have a CARD value greater than zero, using the expression:

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

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

Unload External (Y/N)

Whether the REORG process leaves the data in external format and therefore acts as an unload utility:

Y

REORG processing halts at the unload phase and leaves the data in external format in the SYSREC00 data set. Load control cards are produced in the SYSPUNCH data set. The data produced is in a format suitable for loading into any similar table structure, in any Db2® subsystem. The DD names in the job and resultant SYSPUNCH are compatible with the DSNTIAUL sysrec naming (for example, SYSREC00), therefore the FM/Db2 LOAD Utility can accept both formats, without requiring any JCL editing before submission.

N

Full REORG performed.

Log (Y/N)

LOG option:

Y

Changes written to the Db2® log.

N

Changes not written to the Db2® log. This is the default setting.

For more information, see the DB2 Utility Guide and Reference.

Reuse Data Set

Reuse option:

Y

The data set for the table space is not deleted and re-defined as part of the RECOVER utility processing.

N

The data set for the table space is deleted and redefined as part of the RECOVER utility processing.