REORG (table spaces)
To include a UNLDDN clause in the generated REORG statement, specify
the required template name in UNLDDN template name for the
REORG TABLESPACE statement on the second TEMPLATE Options panel.
Note: The Unload
External option on the REORG Utility (Table Spaces) panel for
the selected table space must be set to
Y.
This option corresponds to the REORG TABLE SPACE 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. - Sample JCL generated for REORG Utility (table spaces) shows an example of generated
JCL for reorganizing table spaces.
Figure 1. Sample JCL generated for REORG Utility (table 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 SETPARM: OVERRIDE ANY GLOBAL DATASET SIZING VALUES HERE 000010 //********************************************************************** 000011 //SETPARM SET ALLOC='TRK',PRI='1',SEC='1' 000012 //* 000013 //********************************************************************** 000014 //* STEP RORG1: REORG TABLESPACE DSN8D81A.DSN8S81D 000015 //********************************************************************** 000016 //RORG1 EXEC DSNUPROC,SYSTEM=DFA2,UID='FMNUSER' 000017 //DSNUPROC.STEPLIB DD DSN=DB2V810.DFA2.SDSNEXIT,DISP=SHR 000018 // DD DSN=DB2.V810.SDSNLOAD,DISP=SHR 000019 //DSNUPROC.SYSREC DD UNIT=SYSALLDA, 000020 // SPACE=(&ALLOC,(&PRI,&SEC),RLSE) 000021 //DSNUPROC.SYSUT1 DD UNIT=SYSALLDA, 000022 // SPACE=(&ALLOC,(&PRI,&SEC),RLSE) 000023 //DSNUPROC.SORTOUT DD UNIT=SYSALLDA, 000024 // SPACE=(&ALLOC,(&PRI,&SEC),RLSE) 000025 //DSNUPROC.SYSIN DD * 000026 REORG TABLESPACE DSN8D81A.DSN8S81D LOG NO 000027 SORTDATA 000028 /* ****** **************************** 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 REORG (Table Spaces) panel showing the specified LISTDEF and a number of editable fields that correspond to keywords in the REORG statement.
- Sample JCL generated for
REORG Utility (table spaces) with LISTDEF specified shows an example of generated
JCL for recovering table spaces where a LISTDEF has been specified.
Figure 2. Sample JCL generated for REORG 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 SETPARM: OVERRIDE ANY GLOBAL DATASET SIZING VALUES HERE 000010 //********************************************************************** 000011 //SETPARM SET ALLOC='TRK',PRI='1',SEC='1' 000012 //* 000013 //********************************************************************** 000014 //* STEP RORG1: REORG TABLESPACE LIST LDEFNAME1 000015 //********************************************************************** 000016 //RORG1 EXEC DSNUPROC,SYSTEM=DFA2,UID='FMNUSER' 000017 //DSNUPROC.STEPLIB DD DSN=DB2V810.DFA2.SDSNEXIT,DISP=SHR 000018 // DD DSN=DB2.V810.SDSNLOAD,DISP=SHR 000019 //DSNUPROC.SYSREC DD UNIT=SYSALLDA, 000020 // SPACE=(&ALLOC,(&PRI,&SEC),RLSE) 000021 //DSNUPROC.SYSUT1 DD UNIT=SYSALLDA, 000022 // SPACE=(&ALLOC,(&PRI,&SEC),RLSE) 000023 //DSNUPROC.SORTOUT DD UNIT=SYSALLDA, 000024 // SPACE=(&ALLOC,(&PRI,&SEC),RLSE) 000025 //DSNUPROC.SYSIN DD * 000026 REORG TABLESPACE LIST LDEFNAME1 LOG NO 000027 SORTDATA 000028 /* ****** **************************** 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 tasks
Related references