REORG TABLESPACE with UNLOAD PAUSE and one user skeleton
An example of a basic REORG TABLESPACE job output with UNLOAD PAUSE and one user skeleton is provided in this topic.
The following output shows a REORG TABLESPACE job with the UNLOAD PAUSE option. The object profile contained two table spaces and two indexes. The utility profile specified REORG PAUSE with inline copy. A user skeleton was included in the utility profile. (For brevity's sake, the registration step and job card are not shown.)
Here is the skeleton:
//TUSERDD JOB TUSERA,CLASS=A,NOTIFY=&SYSUID
//*
//*
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* *
//* This is JKL's test job *
//* *
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* *
//* *
//USERSTEP EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
DELETE 'SS01..DSNDBC.&USRTSDBN.&USRTSNAM..I0001.A001'
SET MAXCC = 0
DEFINE CLUSTER -
( NAME(SS01..DSNDBC.&USRTSDBN.&USRTSNAM..I0001.A001) -
LINEAR -
REUSE -
VOLUMES(* *) -
RECORDS(10 10) -
SHAREOPTIONS(3 3) ) -
DATA -
( NAME(SS01..DSNDBD.&USRTSDBN.&USRTSNAM..I0001.A001))
/*
//* When the job was built, the output appears as follows. Note lines 106 and 219; these are the locations where the user PAUSE skeleton was included.
000064 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000065 //* *
000066 //* Step: RP01001 *
000067 //* *
000068 //* Desc: This step will invoke the IBM Reorg Tablespace Utility *
000069 //* *
000070 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000071 //* *
000072 //RP01001 EXEC PGM=DSNUTILB,REGION=0000M,COND=(4,LT),
000073 // PARM=(SS01,)
000074 //*
000075 //STEPLIB DD DSN=HAA.WRK0220.LOADLIB,DISP=SHR
000076 // DD DSN=FEC.MNT0130.LOADLIB,DISP=SHR
000077 // DD DSN=FEC.PRD0130.LOADLIB,DISP=SHR
000078 // DD DSN=SS01.SDSNEXIT,DISP=SHR
000079 // DD DSN=DSN.V810.SDSNLOAD,DISP=SHR
000080 //SYSOUT DD SYSOUT=*
000081 //UTPRINT DD SYSOUT=*
000064 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000065 //* *
000066 //* Step: RP01001 *
000067 //* *
000068 //* Desc: This step will invoke the IBM Reorg Tablespace Utility *
000069 //* *
000070 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000071 //* *
000072 //RP01001 EXEC PGM=DSNUTILB,REGION=0000M,COND=(4,LT),
000073 // PARM=(SS01,)
000074 //*
000075 //STEPLIB DD DSN=HAA.WRK0220.LOADLIB,DISP=SHR
000076 // DD DSN=FEC.MNT0130.LOADLIB,DISP=SHR
000077 // DD DSN=FEC.PRD0130.LOADLIB,DISP=SHR
000078 // DD DSN=SS01.SDSNEXIT,DISP=SHR
000079 // DD DSN=DSN.V810.SDSNLOAD,DISP=SHR
000080 //SYSOUT DD SYSOUT=*
000081 //UTPRINT DD SYSOUT=*
000082 //SYSPRINT DD SYSOUT=*
000083 //SYSREC DD DSN=TEST.TESTING4.RC01001.REORG.SYSREC,
000084 // DISP=(MOD,CATLG,CATLG),
000085 // UNIT=(VIO,5),SPACE=(CYL,(5,1),,,ROUND)
000086 //SYSUT1 DD DSN=TEST.TESTING4.RC01001.REORG.SYSUT1,
000087 // DISP=(MOD,CATLG,CATLG),
000088 // UNIT=(VIO,5),SPACE=(CYL,(5,1),,,ROUND)
000089 //SORTOUT DD DSN=TEST.TESTING4.RC01001.REORG.SORTOUT,
000090 // DISP=(MOD,CATLG,CATLG),
000091 // UNIT=(VIO,5),SPACE=(CYL,(5,1),,,ROUND)
000092 //SORTWK01 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000093 //SORTWK02 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000094 //SORTWK03 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000095 //R1LP0001 DD DSN=&&R1LP0001,DISP=(NEW,DELETE,DELETE),
000096 // UNIT=VIO,SPACE=(TRK,(0,0))
000097 //SYSIN DD *
000098 REORG TABLESPACE ADHDB2.ADHTS2
000099 LOG YES
000100 COPYDDN (R1LP0001)
000101 SHRLEVEL NONE
000102 UNLOAD PAUSE
000103
000104 /*
000105 //*
000106 //TUSERDD JOB TUSERA,CLASS=A,NOTIFY=
000107 //*
000108 //*
000109 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000110 //* *
000111 //* This is JKL's test job *
000112 //* *
000113 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000114 //* *
000115 //* *
000116 //USERSTEP EXEC PGM=IDCAMS
000117 //SYSPRINT DD SYSOUT=*
000118 //SYSOUT DD SYSOUT=*
000119 //SYSIN DD *
000120 DELETE 'SS01.DSNDBC.ADHTS2.I0001.A001'
000121 SET MAXCC = 0
000122 DEFINE CLUSTER -
000123 ( NAME(SS01.DSNDBC.ADHTS2.I0001.A001) -
000124 LINEAR -
000125 REUSE -
000126 VOLUMES(* *) -
000127 RECORDS(10 10) -
000128 SHAREOPTIONS(3 3) ) -
000129 DATA -
000130 ( NAME(SS01.DSNDBD.ADHTS2.I0001.A001))
000131 /*
000132 //*
000133 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000134 //* *
000135 //* Step: RCER001 *
000136 //* *
000137 //* Desc: This step will invoke the IBM Reorg Tablespace Utility *
000138 //* *
000139 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000140 //* *
000141 //RCER001 EXEC PGM=DSNUTILB,REGION=0000M,COND=(4,LT),
000142 // PARM=(SS01,,RESTART)
000143 //*
000144 //STEPLIB DD DSN=HAA.WRK0220.LOADLIB,DISP=SHR
000145 // DD DSN=FEC.MNT0130.LOADLIB,DISP=SHR
000146 // DD DSN=FEC.PRD0130.LOADLIB,DISP=SHR
000147 // DD DSN=SS01.SDSNEXIT,DISP=SHR
000148 // DD DSN=DSN.V810.SDSNLOAD,DISP=SHR
000149 //SYSOUT DD SYSOUT=*
000150 //UTPRINT DD SYSOUT=*
000151 //SYSPRINT DD SYSOUT=*
000152 //SYSREC DD DSN=TEST.TESTING4.RC01001.REORG.SYSREC,
000153 // DISP=(MOD,DELETE,CATLG),
000154 // UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000155 //SYSUT1 DD DSN=TEST.TESTING4.RC01001.REORG.SYSUT1,
000156 // DISP=(MOD,DELETE,CATLG),
000157 // UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000158 //SORTOUT DD DSN=TEST.TESTING4.RC01001.REORG.SORTOUT,
000159 // DISP=(MOD,DELETE,CATLG),
000160 // UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000161 //SORTWK01 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000162 //SORTWK02 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000163 //SORTWK03 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000164 //R1LP0001 DD DSN=TUSER.ADHDB2.ADHTS2.P00000,
000165 // DISP=(MOD,CATLG,CATLG),
000166 // UNIT=(3390,5),
000167 // SPACE=(TRK,(1,1),RLSE)
000168 //SYSIN DD *
000169 REORG TABLESPACE ADHDB2.ADHTS2
000170 LOG YES
000171 COPYDDN (R1LP0001)
000172 SHRLEVEL NONE
000173 UNLOAD PAUSE
000174
000175 /*
000176 //*
000177 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000178 //* *
000179 //* Step: RP02001 *
000180 //* *
000181 //* Desc: This step will invoke the IBM Reorg Tablespace Utility *
000182 //* *
000183 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000184 //* *
000185 //RP02001 EXEC PGM=DSNUTILB,REGION=0000M,COND=(4,LT),
000186 // PARM=(SS01,)
000187 //*
000188 //STEPLIB DD DSN=HAA.WRK0220.LOADLIB,DISP=SHR
000189 // DD DSN=FEC.MNT0130.LOADLIB,DISP=SHR
000190 // DD DSN=FEC.PRD0130.LOADLIB,DISP=SHR
000191 // DD DSN=SS01.SDSNEXIT,DISP=SHR
000192 // DD DSN=DSN.V810.SDSNLOAD,DISP=SHR
000193 //SYSOUT DD SYSOUT=*
000194 //UTPRINT DD SYSOUT=*
000195 //SYSPRINT DD SYSOUT=*
000196 //SYSREC DD DSN=TEST.TESTING4.RC02001.REORG.SYSREC,
000197 // DISP=(MOD,CATLG,CATLG),
000198 // UNIT=(VIO,5),SPACE=(CYL,(5,1),,,ROUND)
000199 //SYSUT1 DD DSN=TEST.TESTING4.RC02001.REORG.SYSUT1,
000200 // DISP=(MOD,CATLG,CATLG),
000201 // UNIT=(VIO,5),SPACE=(CYL,(5,1),,,ROUND)
000202 //SORTOUT DD DSN=TEST.TESTING4.RC02001.REORG.SORTOUT,
000203 // DISP=(MOD,CATLG,CATLG),
000204 // UNIT=(VIO,5),SPACE=(CYL,(5,1),,,ROUND)
000205 //SORTWK01 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000206 //SORTWK02 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000207 //SORTWK03 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000208 //R1LP0002 DD DSN=&&R1LP0002,DISP=(NEW,DELETE,DELETE),
000209 // UNIT=VIO,SPACE=(TRK,(0,0))
000210 //SYSIN DD *
000211 REORG TABLESPACE ADHTSTDB.ADHTSTTS
000212 LOG YES
000213 COPYDDN (R1LP0002)
000214 SHRLEVEL NONE
000215 UNLOAD PAUSE
000216
000217 /*
000218 //*
000219 //TUSERDD JOB TUSERA,CLASS=A,NOTIFY=
000220 //*
000221 //*
000222 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000223 //* *
000224 //* This is JKL's test job *
000225 //* *
000226 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000227 //* *
000228 //* *
000229 //USERSTEP EXEC PGM=IDCAMS
000230 //SYSPRINT DD SYSOUT=*
000231 //SYSOUT DD SYSOUT=*
000232 //SYSIN DD *
000233 DELETE 'SS01.DSNDBC.ADHTSTTS.I0001.A001'
000234 SET MAXCC = 0
000235 DEFINE CLUSTER -
000236 ( NAME(SS01.DSNDBC.ADHTSTTS.I0001.A001) -
000237 LINEAR -
000238 REUSE -
000239 VOLUMES(* *) -
000240 RECORDS(10 10) -
000241 SHAREOPTIONS(3 3) ) -
000242 DATA -
000243 ( NAME(SS01.DSNDBD.ADHTSTTS.I0001.A001))
000244 /*
000245 //*
000246 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000247 //* *
000248 //* Step: RCER001 *
000249 //* *
000250 //* Desc: This step will invoke the IBM Reorg Tablespace Utility *
000251 //* *
000252 //** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
000253 //* *
000254 //RCER001 EXEC PGM=DSNUTILB,REGION=0000M,COND=(4,LT),
000255 // PARM=(SS01,,RESTART)
000256 //*
000257 //STEPLIB DD DSN=HAA.WRK0220.LOADLIB,DISP=SHR
000258 // DD DSN=FEC.MNT0130.LOADLIB,DISP=SHR
000259 // DD DSN=FEC.PRD0130.LOADLIB,DISP=SHR
000260 // DD DSN=SS01.SDSNEXIT,DISP=SHR
000261 // DD DSN=DSN.V810.SDSNLOAD,DISP=SHR
000262 //SYSOUT DD SYSOUT=*
000263 //UTPRINT DD SYSOUT=*
000264 //SYSPRINT DD SYSOUT=*
000265 //SYSREC DD DSN=TEST.TESTING4.RC02001.REORG.SYSREC,
000266 // DISP=(MOD,DELETE,CATLG),
000267 // UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000268 //SYSUT1 DD DSN=TEST.TESTING4.RC02001.REORG.SYSUT1,
000269 // DISP=(MOD,DELETE,CATLG),
000270 // UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000271 //SORTOUT DD DSN=TEST.TESTING4.RC02001.REORG.SORTOUT,
000272 // DISP=(MOD,DELETE,CATLG),
000273 // UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000274 //SORTWK01 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000275 //SORTWK02 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000276 //SORTWK03 DD UNIT=(VIO,5),SPACE=(CYL,(20,1),,,ROUND)
000277 //R1LP0002 DD DSN=TUSER.ADHTSTDB.ADHTSTTS.P00000,
000278 // DISP=(MOD,CATLG,CATLG),
000279 // UNIT=(3390,5),
000280 // SPACE=(TRK,(1,1),RLSE)
000281 //SYSIN DD *
000282 REORG TABLESPACE ADHTSTDB.ADHTSTTS
000283 LOG YES
000284 COPYDDN (R1LP0002)
000285 SHRLEVEL NONE
000286 UNLOAD PAUSE
000287
000288 /*
000289 //*