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