COPY (index spaces)

This option corresponds to the COPY INDEXSPACE form of the COPY utility control statement.

  • If you did not specify the name of a LISTDEF on the Db2® Utilities panel:
    • When you use COPY (index spaces), you can use the following combinations of filter fields on the Db2® Utilities panel:
      • Database name, or Table/index space name.
      • Database name, Table/index owner, or Table/index name.
    • If you entered information in any of the preceding filter fields on the Db2® Utilities panel, the displayed rows are limited to the Db2® objects that match the information you specified.
    • To select an index space from those displayed, type S in the Sel column. An asterisk (*) in the PRC column indicates selected table spaces.
    • The COPY INDEXSPACE statements generated by FM/Db2 specify the database and index space name (rather than the index owner and index name), regardless of the way you specified the index to be copied. Sample JCL generated for COPY Utility (index spaces) shows an example of generated JCL for copying an index space.
      Figure 1. Sample JCL generated for COPY Utility (index spaces)
         File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help
────────────────────────────────────────────────────────────────────────────────
 EDIT       FMNUSER.SPFTEMP1.CNTL                           Columns 00001 00072
 ****** ***************************** Top of Data ******************************
 000001 //FMNUSERB JOB (IBMGSA),
 000002 //             FMNUSER,MSGCLASS=A,
 000003 //             NOTIFY=FMNUSER,CLASS=A,
 000004 //             MSGLEVEL=(1,1)
 000005 //*
 000006 //         JCLLIB ORDER=(DB2V810.DFA2.PROCLIB)
 000007 //*
 000008 //**********************************************************************
 000009 //* STEP COPY1: COPY INDEXSPACE JLV3D81A.XEMP2
 000010 //**********************************************************************
 000011 //COPY1    EXEC DSNUPROC,SYSTEM=DFA2,UID='FMNUSER'
 000012 //DSNUPROC.STEPLIB  DD DSN=DB2V810.DFA2.SDSNEXIT,DISP=SHR
 000013 //         DD DSN=DB2.V810.SDSNLOAD,DISP=SHR
 000014 //DSNUPROC.SYSCOPY  DD DISP=(NEW,CATLG,DELETE),
 000015 //         DSN=FMNUSER.JLV3D81A.XEMP2.F00000.D2601130,
 000016 //         UNIT=SYSALLDA,SPACE=(TRK,(1,1),RLSE)
 000017 //DSNUPROC.SYSIN    DD *
 000018 COPY INDEXSPACE JLV3D81A.XEMP2
 000019   COPYDDN(SYSCOPY)
 000020 /*
 ****** **************************** Bottom of Data ****************************

 Command ===>                                                  Scroll ===> PAGE
  F1=Help      F2=Split     F3=Exit      F5=Rfind     F6=Rchange   F7=Up
  F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel
  • If you did specify the name of a LISTDEF on the Db2® Utilities panel:
    • FM/Db2 displays an alternative form of the COPY Utility (Index Spaces) panel showing the specified LISTDEF and a number of editable fields that correspond to keywords in the COPY statement.

Related references