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 ZDT/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 HFMUSER.SPFTEMP1.CNTL Columns 00001 00072 ****** ***************************** Top of Data ****************************** 000001 //HFMUSERB JOB (IBMGSA), 000002 // HFMUSER,MSGCLASS=A, 000003 // NOTIFY=HFMUSER,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='HFMUSER' 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=HFMUSER.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
- When you use COPY (index spaces), you can use the following combinations
of filter fields on the Db2® Utilities
panel:
- If you did specify the name of a LISTDEF on the Db2® Utilities panel:
- ZDT/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