COPY Utility (Index Spaces) panel

You use the COPY Utility (Index Spaces) panel to generate utility control statements using the COPY INDEXSPACE form of the COPY utility.

The format of the COPY Utility (Index Spaces) panel depends on which, if any, of the filter fields you specified on the Db2® Utilities panel:
Note: Indexes need to have been defined with the COPY YES clause. Indexes which have not been defined with the COPY YES clause cannot be selected for image copying in the panel.

Panel and field definitions

Figure 1. COPY Utility (Index Spaces) panel—default format
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)            COPY Utility (Index Spaces)           Row 1 to 8 of 8


 S P          Index
 e R Database Space    Part'n       Allocation
 l C Name     Name     Number     Primary Secdry       Space
     BILLSDB1 XDEPT1        0           3      3           0
     BILLSDB1 XDEPT2        0           3      3           0
     BILLSDB1 XDEPT3        0           3      3           0
     BILLSDB1 XEMP1         1           3      3           0
     BILLSDB1 XEMP1         2           3      3           0
     BILLSDB1 XEMP1         3           3      3           0
     BILLSDB1 XEMP1         4           3      3           0
     BILLSDB1 XEMP2         0           3      3           0
 ******************************* Bottom of data ********************************



 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel
Figure 2. COPY Utility (Index Spaces) panel—alternative format
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)            COPY Utility (Index Spaces)           Row 1 to 8 of 8


 S P
 e R Index    Index              Part'n       Allocation
 l C Creator  Name               Number     Primary Secdry       Space
     ARROWSB  XDEPT1                  0           3      3           0
     ARROWSB  XDEPT2                  0           3      3           0
     ARROWSB  XDEPT3                  0           3      3           0
     ARROWSB  XEMP1                   1           3      3           0
     ARROWSB  XEMP1                   2           3      3           0
     ARROWSB  XEMP1                   3           3      3           0
     ARROWSB  XEMP1                   4           3      3           0
     ARROWSB  XEMP2                   0           3      3           0
 ******************************* Bottom of data ********************************



 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel
Sel
Selection column. To select an index space, type S in this column. Selected index spaces show an asterisk (*) in the PRC column.
PRC
Processing indicator. An asterisk (*) indicates the index space is selected.
Database Name
The name of the database in which the index space is defined.
Index Space Name
The name of the index space.
Part'n Number
The partition number for the table space. This is 0 for a non-partitioned table space. A non-zero value indicates a partition of a partitioned table space. By default, when you select a non-partitioned table space for processing, the utility control statements do not include the DSNUM ALL parameter. When you select a partition, the utility control statements include a DSNUM nnn clause (nnn is the partition number you selected).
Primary
The primary allocation value for the table space. See the DB2 Utility Guide and Reference for a full explanation. This value gives some indication of the size of the table space (but is not definitive).
Secondary
The secondary allocation value for the table space. See the DB2 Utility Guide and Reference for a full explanation.
Space
The space allocation for the table space, as reported by the STOSPACE utility. See the DB2 Utility Guide and Reference for a full explanation. This value gives an accurate indication of the size of the table space when the STOSPACE utility was run.
Index Creator
The name of the index creator.
Index Name
The name of the index.

Parent panels

Child panels

None.

Related tasks