COPY (table spaces)

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

If you did not specify the name of a LISTDEF on the Db2® Utilities panel:
- If you entered information in the Database name or Table/index space name filter fields on the Db2® Utilities panel, the displayed rows are limited to the Db2® objects that match the information you specified.
- To select a table space from those displayed, type S in the Sel column. An asterisk (*) in the PRC column indicates selected table spaces.
- You can modify the COPY utility statement by changing the values in the following input fields:
  - FCP
  - Change Limits
  - RPO
- Sample JCL generated for COPY Utility (table spaces) shows an example of generated JCL for copying a table space.

If you did specify the name of a LISTDEF on the Db2® Utilities panel:

FM/Db2 displays an alternative form of the COPY Utility (Table Spaces) panel showing the specified LISTDEF and a number of editable fields that correspond to keywords in the COPY statement.

Sample JCL generated for COPY Utility (table spaces) with LISTDEF specified shows an example of generated JCL for copying a table space where a LISTDEF has been specified.

Figure 1. Sample JCL generated for COPY Utility (table spaces) with LISTDEF specified

   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 TABLESPACE LIST LDEFNAME
 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.LDEFNAME.F.D2601124,
 000016 //         UNIT=SYSALLDA,SPACE=(TRK,(1,1),RLSE)
 000017 //DSNUPROC.SYSIN    DD *
 000018 COPY LIST LDEFNAME
 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

Related references