这个困扰了我两天的问题终于解决了,在运行这个job时:总是提示
A REQUIRED DD CARD OR TEMPLATE IS MISSING NAME=SYSDISCA REQUIRED DD CARD OR TEMPLATE IS MISSING NAME=SYSPUNCH
一直在努力找为什么这两个DD不存在,明明是默认的好吗,加上对JCL以及主机Z不熟悉,导致一直认为这应该用的是系统配置好的data set。
PUNCHDDN ddname Specifies the DD statement for a data set that is to receive the LOAD utility control statements that are generated by REORG TABLESPACE UNLOAD EXTERNAL or REORG TABLESPACE DISCARD FROM TABLE … WHEN. ddname is the DD name. The default value is SYSPUNCH.
DISCARDDN ddname Specifies the DD statement for a discard data set, which contains copies of records that meet the DISCARD FROM TABLE … WHEN specification. ddname is the DD name. If you omit the DISCARDDN option, the utility saves discarded records only if a SYSDISC DD statement is in the JCL input. The default value is SYSDISC. The DISCARDDN keyword specifies either a DD name or a TEMPLATE name specification from a previous TEMPLATE control statement. If utility processing detects that the specified name is both a DD name in the current job step and a TEMPLATE name, the utility uses the DD name.
直到今天下午,仔细看了描述,觉得应该是用来存放东西的,虽然有些描述看不懂,但试着自己创建了一下。(这里有个插曲,之前也试着重建过,但可能是因为重建所用的参数不对,导致还是有问题,这次直接模仿的别人已有的,再次运行,成功reorg)
//SYSDISC DD DSN=&&SYSDISC1,DISP=(NEW,DELETE), // UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSPUNCH DD DSN=&&SYSPUNC1,DISP=(NEW,DELETE), // UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
====
一些其他资料:
The REORG TABLESPACE online utility reorganizes a table space to improve access performance and to reclaim fragmented space. In addition, the utility can reorganize a single partition or range of partitions of a partitioned table space.
You can specify the degree of access to your data during reorganization. If you specify REORG TABLESPACE UNLOAD EXTERNAL, the data is unloaded in a format that is acceptable to the LOAD utility of any DB2® subsystem. You can also delete rows during the REORG job by specifying the DISCARD option.
You can determine when to run REORG for non-LOB table spaces by using the OFFPOSLIMIT or INDREFLIMIT catalog query options. If you specify the REPORTONLY option, REORG produces a report that indicates whether a REORG is recommended without actually performing the REORG. These options are not applicable and are disregarded if the target object is a directory table space.
Control statement :
http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/db2z_reorgtablespacesyntax.dita?lang=en
Sample REORG TABLESPACE control statements
Use the sample control statements as models for developing your own REORG TABLESPACE control statements.
Example 1: Reorganizing a table space.
The following control statement specifies that the REORG TABLESPACE utility is to reorganize table space DSN8S10D in database DSN8D10A.
REORG TABLESPACE DSN8D10A.DSN8S10D
Example 2: Reorganizing a table space and specifying the unload data set
The following control statement specifies that REORG TABLESPACE is to reorganize table space DSN8D81A.DSN8S81D. The DD name for the unload data set is UNLD, as specified by the UNLDDN option.
//STEP1 EXEC DSNUPROC,UID='IUJLU101.REORG',// UTPROC='',// SYSTEM='DSN'//UTPRINT DD SYSOUT=*//UNLD DD DSN=IUJLU101.REORG.STEP1.UNLD,DISP=(MOD,DELETE,CATLG),// UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)//SORTWK01 DD DSN=IUJLU101.REORG.STEP1.SORTWK01,DISP=(MOD,DELETE,CATLG),// UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)//SORTWK02 DD DSN=IUJLU101.REORG.STEP1.SORTWK02,DISP=(MOD,DELETE,CATLG),// UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)//SYSIN DD *REORG TABLESPACE (DSN8D10A.DSN8S10D) UNLDDN (UNLD)//*
Example 3: Reorganizing a table space partition
The following control statement specifies that REORG TABLESPACE is to reorganize partition 3 of table space DSN8D10A.DSN8S10E. The SORTDEVT option indicates the device type for the temporary data sets that are to be dynamically allocated by the sort program.
REORG TABLESPACE DSN8D10A.DSN8S10E PART 3 SORTDEVT SYSDA
Example 4: Reorganizing a table and using parallel index build
The following control statement specifies that REORG TABLESPACE is to reorganize table space DSNDB04.DSN8S81D and to use a parallel index build to rebuild the indexes. The indexes are built in parallel, because more than one index needs to be built and the job allocates the data sets that the sort program needs. Note that you no longer need to specify SORTKEYS; it is the default.
The job allocates the sort work data sets in two groups, which limits the number of pairs of utility subtasks to two. This example does not require UTPRINnn DD statements because it uses DSNUPROC to invoke utility processing. DSNUPROC includes a DD statement that allocates UTPRINT to SYSOUT.
LOG NO specifies that records are not to be logged during the RELOAD phase. This option puts the table space in COPY-pending status.
//SAMPJOB JOB …//STEP1 EXEC DSNUPROC,UID='SAMPJOB.REORG',UTPROC='',SYSTEM='DSN'//SYSREC DD DSN=SAMPJOB.REORG.STEP1.SYSREC,DISP=(NEW,DELETE,CATLG),// UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//* First group of sort work data sets for parallel index build//SW01WK01 DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//SW01WK02 DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//SW01WK03 DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//* Second group of sort work data sets for parallel index build//SW02WK01 DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//SW02WK02 DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//SW02WK03 DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//* Sort work data sets for use by SORTDATA//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND)//SYSIN DD *REORG TABLESPACE DSNDB04.DSN8S10D LOG NO /*
Example 5: Reorganizing a table while allowing read-write access
The following control statement specifies that REORG TABLESPACE is to reorganize table space DSNDB04.DSN8S81E and to use a parallel index build to rebuild the indexes. The sort program dynamically allocates sort work data sets. This example does not require UTPRINnn DD statements because it uses DSNUPROC to invoke utility processing. DSNUPROC includes a DD statement that allocates UTPRINT to SYSOUT. The SORTDEVT option indicates the device type for the temporary data sets that are to be dynamically allocated by the sort program. The SHRLEVEL CHANGE option specifies that while the table is being reorganized, users have read-write access. The name of the mapping table is DSN8MAP. This table is used to map the RIDs of data records in the original copy of the area to the corresponding RIDs in the shadow copy.
//SAMPJOB JOB …//STEP1 EXEC DSNUPROC,UID='SAMPJOB.REORG',UTPROC='',SYSTEM='DSN'//SYSCOPY DD UNIT=SYSDA,SPACE=(CYL,(10,20),,,ROUND),// DSN=SAMPJOB,COPY,DISP=(NEW,CATLG,CATLG)//SYSIN DD *REORG TABLESPACE DSNDB04.DSN8S10E LOG NO SORTDEVT SYSDA SORTNUM 4 SHRLEVEL CHANGE MAPPINGTABLE DSN8MAP/*
Example 6: Specifying a deadline for the SWITCH phase while reorganizing a table
The following control statement specifies that REORG TABLESPACE is to reorganize table space DSN8D81A.DSN8S10D. The DEADLINE option indicates that the deadline for start of the SWITCH phase is eight hours from the start of the REORG job. The COPYDDN and RECOVERYDDN options indicate that the utility is to take an image copy of the table space. DB2® is to write the primary image copy at the local site to a data set that is defined by the MYCOPY1 DD statement and to write the primary image copy at the recovery site to a data set that is defined by the MYCOPY2 DD statement. SHRLEVEL REFERENCE indicates that access is restricted during reorganization.
REORG TABLESPACE DSN8D10A.DSN8S10D COPYDDN(MYCOPY1) RECOVERYDDN(MYCOPY2) SHRLEVEL REFERENCE DEADLINE CURRENT TIMESTAMP + 8 HOURS
Example 7: Setting a deadline for a REORG TABLESPACE job
The following control statement specifies that REORG TABLESPACE is to reorganize table space DSN8D10A.DSN8S10D. The DEADLINE option indicates that the deadline for the start of the SWITCH phase is eight hours from the start of the REORG job. The name of the mapping table is DSN8810.MAP_TBL. The maximum amount of time for log processing in the read-only (last) iteration of log processing is 240 seconds, as indicated by the MAXRO option. If DB2 is not reading the log quickly enough after the applications write to the log, DB2 drains the write claim class after sending the LONGLOG message to the operator. That draining takes place at least 900 seconds after the LONGLOG message is sent, as indicated by the DELAY option. DB2 is also to take inline image copies for the local site and recovery site, as indicated by the COPYDDN and RECOVERYDDN options.
REORG TABLESPACE DSN8D10A.DSN8S10D COPYDDN(MYCOPY1) RECOVERYDDN(MYCOPY2) SHRLEVEL CHANGE DEADLINE CURRENT TIMESTAMP + 8 HOURS MAPPINGTABLE DSN8A10.MAP_TBL MAXRO 240 LONGLOG DRAIN DELAY 900
Example 8: Reorganizing a range of table space partitions
The following control statement specifies that REORG TABLESPACE is to reorganize partitions 3 through 5 of table space DSN8D10A.DSN8S10E. The SORTDEVT option indicates the device type for the temporary data sets that are to be dynamically allocated by the sort program. The SHRLEVEL NONE option indicates that while the data is being unloaded, applications can read but can't write. While the data is being reloaded, applications can have read-write access. SHRLEVEL NONE is the default. The COPYDDN option indicates that the utility is to take an image copy of the table space and to write the primary image copy to the data set that is defined by the SYSCOPY DD statement.
REORG TABLESPACE DSN8D10A.DSN8S10E PART 3:5 SORTDEVT SYSDA SHRLEVEL NONE COPYDDN SYSCOPY
Example 9: Reorganizing a partition and updating the statistics
The following control statement specifies that REORG TABLESPACE is to reorganize partition 3 of table space DSN8D10A. DSN8S10E. The STATISTICS option indicates that the utility is also to update statistics in the catalog for that partition. Note that the STATISTICS option is not valid for LOB table spaces.
REORG TABLESPACE DSN8D10A.DSN8S10E STATISTICS PART 3
Example 10: Reorganizing a table space and reporting table space and index statistics
The following control statement specifies that REORG TABLESPACE is to reorganize table space DSN8D10A.DSN8S10E. The SORTDATA option indicates that the data is to be unloaded and sorted in clustering order. This option is the default and does not need to be specified. The STATISTICS, TABLE, INDEX, and REPORT YES options indicate that the utility is also to report catalog statistics for all tables in the table space and for all indexes that are defined on those tables. The FREQVAL, NUMCOLS, and COUNT options indicate that DB2 is to collect 10 frequent values on the first key column of the index. UPDATE NONE indicates that the catalog tables are not to be updated. This option requires that REPORT YES also be specified. Because both STATISTICS and INDEX are specified, the utility also collects statistics on the values in the key columns of indexes.
REORG TABLESPACE DSN8D10A.DSN8S10E SORTDATA STATISTICS TABLE INDEX(ALL) FREQVAL NUMCOLS 1 COUNT 10 REPORT YES UPDATE NONE
Example 11: Determining whether a table space should be reorganized
The following control statement specifies that REORG TABLESPACE is to report if the OFFPOSLIMIT and INDREFLIMIT values for partition 11 of table space DBHR5201.TPHR5201 exceed the specified values (11 for OFFPOSLIMIT and 15 for INDREFLIMIT).
//STEP1 EXEC DSNUPROC,UID='HUHRU252.REORG2',TIME=1440,// UTPROC='',// SYSTEM='DSN'//SYSREC DD DSN=HUHRU252.REORG2.STEP1.SYSREC,DISP=(MOD,DELETE,CATLG),// UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)//SYSCOPY DD DSN=HUHRU252.REORG2.STEP1.SYSCOPY,DISP=(MOD,CATLG,CATLG),// UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)// SPACE=(4000,(20,20),,,ROUND)//SYSIN DD *REORG TABLESPACE DBHR5201.TPHR5201 PART 11 NOSYSREC REPORTONLY SHRLEVEL CHANGE MAPPINGTABLE ADMF001.MAP1 COPYDDN (SYSCOPY) OFFPOSLIMIT 11 INDREFLIMIT 15/*
On successful completion, DB2 returns output that is similar to the output in the following sample output. This sample output shows that the limits have been met.
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = HUHRU252.REORG2 DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC DSNU050I DSNUGUTC - REORG TABLESPACE DBHR5201.TPHR5201 PART 11 NOSYSREC REPORTONLY SHRLEVEL CHANGEMAPPINGTABLE ADMF001.MAP1 COPYDDN(SYSCOPY) OFFPOSLIMIT 11 INDREFLIMIT 15 DSNU286I = DSNURLIM - REORG TABLESPACE DBHR5201.TPHR5201 OFFPOSLIMIT SYSINDEXPART ROWS* CREATOR.IXNAME : ADMF001.IPHR5201 CREATOR.TBNAME : ADMF001.TBHR5201 PART: 1 CARDF: 6.758E+03 FAROFFPOSF: 2.892E+03 NEAROFFPOSF: 8.18E+02 STATSTIME: 2003-04-1113.32.06 DSNU287I = DSNURLIM - REORG TABLESPACE DBHR5201.TPHR5201 INDREFLIMIT SYSTABLEPART ROWS DBNAME .TSNAME PART CARD FARINDREF NEARINDREF STATSTIME DBHR5201.TPHR5201 1 6758 0 0 2003-04-11-13.32.06 DSNU289I = DSNURLIM - REORG LIMITS HAVE BEEN MET DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
Example 12: Conditionally reorganizing a table space
In the following example, the RUNSTATS utility control statement specifies that the utility is to update space statistics in the catalog for table space DBHR5201.TPHR5201. This RUNSTATS job ensures that the space statistics for this table space are current. The subsequent REORG TABLESPACE control statement specifies that if any of the values for OFFPOSLIMIT or INDREFLIMIT exceed 9, the utility is to reorganize the table space.
//******************************************************************//* COMMENT: UPDATE STATISTICS//******************************************************************//STEP1 EXEC DSNUPROC,UID='HUHRU252.REORG1',TIME=1440,// UTPROC='',// SYSTEM='DSN'//SYSREC DD DSN=HUHRU252.REORG1.STEP1.SYSREC,DISP=(MOD,DELETE,CATLG),// UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)// SPACE=(4000,(20,20),,,ROUND)//SYSIN DD *RUNSTATS TABLESPACE DBHR5201.TPHR5201 UPDATE SPACE/*//******************************************************************//* COMMENT: REORG THE TABLESPACE//******************************************************************//STEP2 EXEC DSNUPROC,UID='HUHRU252.REORG1',TIME=1440,// UTPROC='',// SYSTEM='DSN'//SYSREC DD DSN=HUHRU252.REORG1.STEP1.SYSREC,DISP=(MOD,DELETE,CATLG),// UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)//SYSCOPY1 DD DSN=HUHRU252.REORG1.STEP1.SYSCOPY1,// DISP=(MOD,CATLG,CATLG),UNIT=SYSDA,// SPACE=(4000,(20,20),,,ROUND)//SYSIN DD *REORG TABLESPACE DBHR5201.TPHR5201 SHRLEVEL CHANGE MAPPINGTABLE MAP1 COPYDDN(SYSCOPY1) OFFPOSLIMIT 9 INDREFLIMIT 9/*
On successful completion, DB2 returns output for the REORG TABLESPACE job that is similar to the output in the following sample output.
DSNU050I DSNUGUTC - REORG TABLESPACE DBHR5201.TPHR5201 SHRLEVEL CHANGE MAPPINGTABLE MAP1 COPYDDN(SYSCOPY1)OFFPOSLIMIT 9 INDREFLIMIT 9DSNU286I = DSNURLIM - REORG TABLESPACE DBHR5201.TPHR5201 OFFPOSLIMIT SYSINDEXPART ROWS* CREATOR.IXNAME : ADMF001.IPHR5201CREATOR.TBNAME : ADMF001.TBHR5201 PART: 1 CARDF: 3.6E+01 FAROFFPOSF: 0.0E0 NEAROFFPOSF: 1.2E+01STATSTIME: 2002-05-28-16.22.18 CREATOR.IXNAME : ADMF001.IPHR5201 CREATOR.TBNAME : ADMF001.TBHR5201 PART: 2 CARDF: 5.0E+00 FAROFFPOSF: 0.0E0 NEAROFFPOSF: 0.0E0 STATSTIME: 2002-05-28-16.22.18... * CREATOR.IXNAME : ADMF001.IPHR5201 CREATOR.TBNAME : ADMF001.TBHR5201 PART: 11 CARDF: 6.758E+03 FAROFFPOSF: 2.892E+03 NEAROFFPOSF: 8.18E+02 STATSTIME: 2002-05-28-16.22.18DSNU287I = DSNURLIM - REORG TABLESPACE DBHR5201.TPHR5201 INDREFLIMIT SYSTABLEPART ROWS DBNAME .TSNAME PART CARD FARINDREF NEARINDREF STATSTIME DBHR5201.TPHR5201 1 36 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 2 5 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 3 54 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 4 30 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 5 21 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 6 5 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 7 4 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 8 35 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 9 25 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 10 1 0 0 2002-05-28-16.22.18 DBHR5201.TPHR5201 11 6758 0 0 2002-05-28-16.22.18DSNU289I = DSNURLIM - REORG LIMITS HAVE BEEN METDSNU290I = DSNURLIM - REORG WILL BE PERFORMEDDSNU252I DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=6985 FOR TABLESPACE DBHR5201.TPHR5201DSNU250I DSNUGSRT - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:01DSNU304I = DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=6985 FOR TABLE ADMF001.TBHR5201DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=6985DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:29DSNU042I DSNUGSOR - SORT PHASE STATISTICS - NUMBER OF RECORDS=34925 ELAPSED TIME=00:00:00 DSNU348I = DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=36 FOR INDEX ADMF001.IPHR5201 PART 1DSNU348I = DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=5 FOR INDEX ADMF001.IPHR5201 PART 2...DSNU349I = DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=6985 FOR INDEX ADMF001.IUHR5210DSNU258I DSNURBXD - BUILD PHASE STATISTICS - NUMBER OF INDEXES=5DSNU259I DSNURBXD - BUILD PHASE COMPLETE, ELAPSED TIME=00:00:18DSNU386I DSNURLGD - LOG PHASE STATISTICS. NUMBER OF ITERATIONS = 1, NUMBER OF LOG RECORDS = 194DSNU385I DSNURLGD - LOG PHASE COMPLETE, ELAPSED TIME = 00:01:10DSNU400I DSNURBID - COPY PROCESSED FOR TABLESPACE DBHR5201.TPHR5201 NUMBER OF PAGES=1073 AVERAGE PERCENT FREE SPACE PER PAGE = 14.72 PERCENT OF CHANGED PAGES =100.00 ELAPSED TIME=00:01:58DSNU387I DSNURSWT - SWITCH PHASE COMPLETE, ELAPSED TIME = 00:01:05DSNU428I DSNURSWT - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE DBHR5201.TPHR5201
Example 13: Reorganizing a table space after waiting for SQL statements to complete.
The following control statement specifies that REORG TABLESPACE is to reorganize the table space in the REORG_TBSP list, which is defined in the preceding LISTDEF utility control statement. Before reorganizing the table space, REORG TABLESPACE is to wait for 30 seconds for SQL statements to finish adding or changing data. This interval is indicated by the DRAIN_WAIT option. If the SQL statements do not finish, the utility is to try again up to four times, as indicated by the RETRY option. The utility is to wait 10 seconds between retries, as indicated by the RETRY_DELAY option.
The TEMPLATE utility control statements define the data set characteristics for the data sets that are to be dynamically allocated during the REORG TABLESPACE job. The OPTIONS utility control statement indicates that the TEMPLATE statements and LISTDEF statement are to run in PREVIEW mode.
//STEP1 EXEC DSNUPROC,UID='HUHRU257.REORG',TIME=1440, // UTPROC='', // SYSTEM='DSN' //UTPRINT DD SYSOUT=* //SYSIN DD * OPTIONS PREVIEW TEMPLATE CPYTMP UNIT(SYSDA) DSN(HUHRU257.REORG.T&TI..SYSCOPY1) TEMPLATE SREC UNIT(SYSDA) DISP(NEW,CATLG,CATLG) DSN(HUHRU257.REORG.&ST..SREC) TEMPLATE SDISC UNIT(SYSDA) DISP(NEW,CATLG,CATLG) DSN(HUHRU257.REORG.&ST..SDISC) TEMPLATE SPUNCH UNIT(SYSDA) DISP(NEW,CATLG,CATLG) DSN(HUHRU257.REORG.&ST..SPUNCH) LISTDEF REORG_TBSP INCLUDE TABLESPACE DBHR5701.TPHR5701 OPTIONS OFF REORG TABLESPACE LIST REORG_TBSP DRAIN_WAIT 30 RETRY 4 RETRY_DELAY 10 STATISTICS TABLE (ALL) SAMPLE 60 INDEX (ALL FREQVAL NUMCOLS 2 COUNT 15) SHRLEVEL CHANGE MAPPINGTABLE MAP5702 LONGLOG DRAIN MAXRO DEFER DELAY 30 COPYDDN (CPYTMP) SORTDEVT SYSDA SORTNUM 8 PUNCHDDN SPUNCH DISCARDDN SDISC UNLDDN SREC
On successful completion, DB2 returns output similar to the output in the following sample output.
DSNU000I 280 14:54:37.27 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = HUHRU257.REORGDSNU1044I 280 14:54:37.43 DSNUGTIS - PROCESSING SYSIN AS EBCDIC DSNU050I 280 14:54:37.45 DSNUGUTC - OPTIONS PREVIEW DSNU1000I 280 14:54:37.45 DSNUZODR - PROCESSING CONTROL STATEMENTS IN PREVIEW MODEDSNU1035I 280 14:54:37.45 DSNUZODR - OPTIONS STATEMENT PROCESSED SUCCESSFULLYDSNU050I 280 14:54:37.45 DSNUGUTC - TEMPLATE CPYTMP UNIT(SYSDA) DSN(HUHRU257.REORG.STEP12.SYSCOPY1)DSNU1035I 280 14:54:37.45 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLYDSNU050I 280 14:54:37.46 DSNUGUTC - TEMPLATE SREC UNIT(SYSDA) DISP(NEW, CATLG, CATLG) DSN(HUHRU257.REORG.&ST..SREC)DSNU1035I 280 14:54:37.46 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLYDSNU050I 280 14:54:37.46 DSNUGUTC - TEMPLATE SDISC UNIT(SYSDA) DISP(NEW, CATLG, CATLG) DSN(HUHRU257.REORG.&ST..SDISC)DSNU1035I 280 14:54:37.46 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLYDSNU050I 280 14:54:37.46 DSNUGUTC - TEMPLATE SPUNCH UNIT(SYSDA) DISP(NEW, CATLG, CATLG) DSN(HUHRU257.REORG.&ST..SPUNCH)DSNU1035I 280 14:54:37.46 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY DSNU050I 280 14:54:37.46 DSNUGUTC - TEMPLATE SUT1 UNIT(SYSDA) DISP(NEW, DELETE, CATLG) DSN(HUHRU257.REORG.&ST..SUT1)DSNU1035I 280 14:54:37.46 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY DSNU050I 280 14:54:37.46 DSNUGUTC - TEMPLATE SOUT UNIT(SYSDA) DISP(NEW, DELETE, CATLG) DSN(HUHRU257.REORG.&ST..SOUT)DSNU1035I 280 14:54:37.46 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLYDSNU050I 280 14:54:37.46 DSNUGUTC - LISTDEF REORG_TBSP INCLUDE TABLESPACE DBHR5701.TPHR5701DSNU1035I 280 14:54:37.47 DSNUILDR - LISTDEF STATEMENT PROCESSED SUCCESSFULLYDSNU1020I @ 280 14:54:37.47 DSNUILSA - EXPANDING LISTDEF REORG_TBSPDSNU1021I @ 280 14:54:37.47 DSNUILSA - PROCESSING INCLUDE CLAUSE TABLESPACE DBHR5701.TPHR5701DSNU1022I @ 280 14:54:37.47 DSNUILSA - CLAUSE IDENTIFIES 1 OBJECTSDSNU1023I @ 280 14:54:37.47 DSNUILSA - LISTDEF REORG_TBSP CONTAINS 1 OBJECTSDSNU1010I 280 14:54:37.47 DSNUGPVV - LISTDEF REORG_TBSP EXPANDS TO THE FOLLOWING OBJECTS: LISTDEF REORG_TBSP -- 00000001 OBJECTS INCLUDE TABLESPACE DBHR5701.TPHR5701DSNU050I 280 14:54:37.47 DSNUGUTC - OPTIONS OFFDSNU1035I 280 14:54:37.47 DSNUZODR - OPTIONS STATEMENT PROCESSED SUCCESSFULLYDSNU050I 280 14:54:37.47 DSNUGUTC - REORG TABLESPACE LIST REORG_TBSP SHRLEVEL CHANGE MAPPINGTABLE MAP5702LONGLOG DRAIN MAXRO DEFER DELAY 30 DRAIN_WAIT 30 RETRY 4 RETRY_DELAY 10 COPYDDN(CPYTMP) SORTKEYS SORTDEVT SYSDASORTNUM 8 PUNCHDDN SPUNCH DISCARDDN SDISC UNLDDN SREC WORKDDN(SUT1, SOUT) STATISTICS TABLE(ALL) SAMPLE 60 INDEX(ALL KEYCARD FREQVAL NUMCOLS 2 COUNT 15) DSNU1033I 280 14:54:37.48 DSNUGULM - PROCESSING LIST ITEM: TABLESPACE DBHR5701.TPHR5701DSNU1038I 280 14:54:42.97 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=CPYTMP DDNAME=SYS00001 DSN=HUHRU257.REORG.STEP12.SYSCOPY1DSNU397I 280 14:54:43.01 DSNURPCT - NUMBER OF TASKS CONSTRAINED BY VIRTUAL STORAGEDSNU397I 280 14:54:43.01 DSNURPCT - NUMBER OF TASKS CONSTRAINED BY CPUSDSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACEDBHR5701.TPHR5701 PART 1DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACEDBHR5701.TPHR5701 PART 2DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACEDBHR5701.TPHR5701 PART 3DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACEDBHR5701.TPHR5701 PART 4DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE DBHR5701.TPHR5701 PART 5DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACEDBHR5701.TPHR5701 PART 6DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACEDBHR5701.TPHR5701 PART 7DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACEDBHR5701.TPHR5701 PART 8DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACEDBHR5701.TPHR5701 PART 9DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE DBHR5701.TPHR5701 PART 10DSNU251I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=2520 FOR TABLESPACEDBHR5701.TPHR5701 PART 11 DSNU252I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=2520 FOR TABLESPACEDBHR5701.TPHR5701DSNU250I 280 14:54:43.40 DSNUGSRT - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00 DSNU395I 280 14:54:43.95 DSNURPIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 6DSNU397I 280 14:54:43.95 DSNURPIB - NUMBER OF TASKS CONSTRAINED BY VIRTUAL STORAGEDSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701 PART=1DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701 PART=2DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701 PART=3DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701 PART=4DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701 PART=5DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701 PART=6DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701 PART=7DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701 PART=8DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701 PART=9DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ADMF001.TBHR5701PART=10DSNU303I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=2520 FOR TABLE ADMF001.TBHR5701PART=11DSNU304I @ 280 14:55:42.47 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=2520 FOR TABLE ADMF001.TBHR5701DSNU302I 280 14:55:42.48 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=2520DSNU300I 280 14:55:42.48 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:59DSNU394I @ 280 14:55:42.69 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=2520 FOR INDEX ADMF001.IXHR5702DSNU394I @ 280 14:55:42.77 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=2520 FOR INDEX ADMF001.IXHR5704DSNU394I @ 280 14:55:42.83 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=2520 FOR INDEX ADMF001.IXHR5706DSNU393I @ 280 14:55:42.63 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=2520 FOR INDEX ADMF001.IPHR5701 PART11DSNU394I @ 280 14:55:42.73 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=2520 FOR INDEX ADMF001.IUHR5710DSNU394I @ 280 14:55:42.82 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=2520 FOR INDEX ADMF001.IXHR5703DSNU394I @ 280 14:55:42.94 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=2520 FOR INDEX ADMF001.IXHR5705DSNU391I 280 14:55:43.15 DSNURPTB - SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 7DSNU392I 280 14:55:43.15 DSNURPTB - SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:00:00DSNU386I 280 14:57:33.94 DSNURLGD - LOG PHASE STATISTICS. NUMBER OF ITERATIONS = 23, NUMBER OF LOG RECORDS = 0DSNU385I 280 14:57:33.94 DSNURLGD - LOG PHASE COMPLETE, ELAPSED TIME = 00:01:50DSNU400I 280 14:57:33.95 DSNURBID - COPY PROCESSED FOR TABLESPACE DBHR5701.TPHR5701 NUMBER OF PAGES=394 AVERAGE PERCENT FREE SPACE PER PAGE = 13.70 PERCENT OF CHANGED PAGES =100.00 ELAPSED TIME=00:02:50DSNU387I 280 14:57:35.53 DSNURSWT - SWITCH PHASE COMPLETE, ELAPSED TIME = 00:00:01DSNU428I 280 14:57:35.54 DSNURSWT - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE DBHR5701.TPHR5701DSNU610I @ 280 14:57:36.78 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR DBHR5701.TPHR5701 SUCCESSFULDSNU610I @ 280 14:57:36.78 DSNUSUPT - SYSTABSTATS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFULDSNU610I @ 280 14:57:36.85 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFULDSNU610I @ 280 14:57:36.85 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFULDSNU610I @ 280 14:57:36.92 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFULDSNU610I @ 280 14:57:36.93 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR DBHR5701.TPHR5701 SUCCESSFULDSNU610I @ 280 14:57:37.42 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFULDSNU610I @ 280 14:57:37.44 DSNUSUPI - SYSINDEXSTATS CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFULDSNU610I @ 280 14:57:37.45 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFULDSNU610I @ 280 14:57:37.45 DSNUSUPD - SYSCOLDISTSTATS CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFULDSNU610I @ 280 14:57:37.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5702 SUCCESSFULDSNU610I @ 280 14:57:37.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5703 SUCCESSFULDSNU610I @ 280 14:57:37.47 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5704 SUCCESSFULSNU610I @ 280 14:57:37.47 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5705 SUCCESSFULDSNU610I @ 280 14:57:37.48 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5706 SUCCESSFULDSNU610I @ 280 14:57:37.48 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFULDSNU610I @ 280 14:57:37.48 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFULDSNU610I @ 280 14:57:37.54 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.IXHR5702 SUCCESSFULDSNU610I @ 280 14:57:37.54 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5702 SUCCESSFULDSNU610I @ 280 14:57:37.57 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.IXHR5703 SUCCESSFULDSNU610I @ 280 14:57:37.57 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5703 SUCCESSFULDSNU610I @ 280 14:57:37.60 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.IXHR5704 SUCCESSFULDSNU610I @ 280 14:57:37.60 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5704 SUCCESSFULDSNU610I @ 280 14:57:37.63 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.IXHR5705 SUCCESSFULDSNU610I @ 280 14:57:37.63 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5705 SUCCESSFULDSNU610I @ 280 14:57:37.66 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.IXHR5706 SUCCESSFULDSNU610I @ 280 14:57:37.66 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5706 SUCCESSFULDSNU610I @ 280 14:57:37.71 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFULDSNU610I @ 280 14:57:37.71 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5702 SUCCESSFULDSNU610I @ 280 14:57:37.72 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5703 SUCCESSFULDSNU610I @ 280 14:57:37.72 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5704 SUCCESSFULDSNU610I @ 280 14:57:37.73 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5705 SUCCESSFULDSNU610I @ 280 14:57:37.74 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5706 SUCCESSFULDSNU620I @ 280 14:57:37.74 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2010-10-07-14.54.43.844498DSNU010I 280 14:57:42.23 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
DSNU394I = DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=331 FOR INDEX ADMF001.IXHR5706 DSNU394I = DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=331 FOR INDEX ADMF001.IXHR5705 DSNU610I = DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5702 SUCCESSFUL DSNU610I = DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5702 SUCCESSFUL DSNU610I = DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFUL DSNU610I = DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5702 SUCCESSFUL DSNU610I = DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5705 SUCCESSFUL DSNU610I = DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5705 SUCCESSFUL DSNU610I = DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFUL DSNU610I = DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5705 SUCCESSFUL DSNU620I = DSNURDRI - RUNSTATS CATALOG TIMESTAMP = 2002-08-05-16.25.21.292235 DSNU610I = DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5703 SUCCESSFUL DSNU610I = DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5703 SUCCESSFUL DSNU610I = DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFUL DSNU610I = DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5703 SUCCESSFUL DSNU610I = DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5706 SUCCESSFUL DSNU610I = DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5706 SUCCESSFUL DSNU610I = DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFUL DSNU610I = DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5706 SUCCESSFULDSNU620I = DSNURDRI - RUNSTATS CATALOG TIMESTAMP = 2002-08-05-16.25.22.288665 DSNU393I = DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=331 FOR INDEX ADMF001.IPHR5701 PART 11 DSNU394I = DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=331 FOR INDEX ADMF001.IPHR5701DSNU394I = DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=331 FOR INDEX ADMF001.IXHR5704 DSNU610I = DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFUL DSNU610I = DSNUSUPI - SYSINDEXSTATS CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFUL DSNU610I = DSNUSUPD - SYSCOLDISTSTATS CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFUL DSNU610I = DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFUL DSNU610I = DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFUL DSNU610I = DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFUL DSNU610I = DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IPHR5701 SUCCESSFUL DSNU610I = DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ADMF001.IXHR5704 SUCCESSFUL DSNU610I = DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ADMF001.IXHR5704 SUCCESSFUL DSNU610I = DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ADMF001.TBHR5701 SUCCESSFUL DSNU610I = DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ADMF001.IXHR5704 SUCCESSFUL DSNU620I = DSNURDRI - RUNSTATS CATALOG TIMESTAMP = 2002-08-05-16.25.20.886803 DSNU391I DSNURPTB - SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 7 DSNU392I DSNURPTB - SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:00:04 DSNU377I = DSNURLOG - IN REORG WITH SHRLEVEL CHANGE, THE LOG IS BECOMING LONG, MEMBER= , UTILID=HUHRU257.REORG DSNU377I = DSNURLOG - IN REORG WITH SHRLEVEL CHANGE, THE LOG IS BECOMING LONG, MEMBER= , UTILID=HUHRU257.REORG... DSNU377I = DSNURLOG - IN REORG WITH SHRLEVEL CHANGE, THE LOG IS BECOMING LONG, MEMBER= , UTILID=HUHRU257.REORG DSNU1122I = DSNURLOG - JOB T3161108 PERFORMING REORG WITH UTILID HUHRU257.REORG UNABLE TO DRAIN DBHR5701.TPHR5701. RETRY 1 OF 4 WILL BE ATTEMPTED IN 10 SECONDS DSNU1122I = DSNURLOG - JOB T3161108 PERFORMING REORG WITH UTILID HUHRU257.REORG UNABLE TO DRAIN DBHR5701.TPHR5701. RETRY 2 OF 4 WILL BE ATTEMPTED IN 10 SECONDS DSNU386I DSNURLGD - LOG PHASE STATISTICS. NUMBER OF ITERATIONS = 32, NUMBER OF LOG RECORDS = 2288 DSNU385I DSNURLGD - LOG PHASE COMPLETE, ELAPSED TIME = 00:03:43DSNU400I DSNURBID - COPY PROCESSED FOR TABLESPACE DBHR5701.TPHR5701 NUMBER OF PAGES=377 AVERAGE PERCENT FREE SPACE PER PAGE = 5.42 PERCENT OF CHANGED PAGES =100.00 ELAPSED TIME=00:04:02 DSNU387I DSNURSWT - SWITCH PHASE COMPLETE, ELAPSED TIME = 00:00:02 DSNU428I DSNURSWT - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE DBHR5701.TPHR5701 DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
Example 14: Using a mapping table
In the following example, a mapping table and mapping table index are created. Then, a REORG TABLESPACE job uses the mapping table, and finally the mapping table is dropped. Some parts of this job use the EXEC SQL utility to execute dynamic SQL statements.
The first EXEC SQL control statement contains the SQL statements that create a mapping table that is named MYMAPPING_TABLE. The second EXEC SQL control statement contains the SQL statements that create mapping index MYMAPPING_INDEX on the table MYMAPPING_TABLE.
The REORG TABLESPACE control statement then specifies that the REORG TABLESPACE utility is to reorganize table space DSN8D81P.DSN8S81C and to use mapping table MYMAPPING_TABLE.
Finally, the third EXEC SQL statement contains the SQL statements that drop MYMAPPING_TABLE.
EXEC SQL CREATE TABLE MYMAPPING_TABLE (TYPE CHAR( 01 ) NOT NULL, SOURCE_RID CHAR( 05 ) NOT NULL, TARGET_XRID CHAR( 09 ) NOT NULL, LRSN CHAR( 06 ) NOT NULL) IN DSN8D81P.DSN8S81Q CCSID EBCDIC ENDEXECEXEC SQL CREATE UNIQUE INDEX MYMAPPING_INDEX ON MYMAPPING_TABLE (SOURCE_RID ASC, TYPE, TARGET_XRID, LRSN) USING STOGROUP DSN8G710 PRIQTY 120 SECQTY 20 ERASE NO BUFFERPOOL BP0 CLOSE NO ENDEXEC REORG TABLESPACE DSN8D81P.DSN8S81C COPYDDN(COPYDDN) SHRLEVEL CHANGE DEADLINE CURRENT_TIMESTAMP+8 HOURS MAPPINGTABLE MYMAPPING_TABLE MAXRO 240 LONGLOG DRAIN DELAY 900 SORTDEVT SYSDA SORTNUM 4 STATISTICS TABLE(ALL) INDEX(ALL) EXEC SQL DROP TABLE MYMAPPING_TABLE ENDEXEC
Example 15: Discarding records from one table while reorganizing a table space
The following control statement specifies that REORG TABLESPACE is to reorganize table space DSN8D51A.DSN8S51E. During reorganization, records in table DSN8510.EMP are discarded if they have the value D11 in the WORKDEPT field. This discard criteria is specified in the WHEN clause that follows the DISCARD option. Because a SYSDISC DD statement is included in the JCL, any discarded rows are to be written to the data set that is identified by this DD statement.
The COPYDDN option specifies that during the REORG, DB2 is also to take an inline copy of the table space. This image copy is to be written to the data set that is identified by the SYSCOPY DD statement.
//REORGDIS EXEC DSNUPROC,TIME=1440, // UTPROC='', // SYSTEM='DSN',UID='REORGDIS.EMP' //SYSREC DD DISP=(NEW,CATLG,CATLG), // DSN=SYSADM.REORGDIS.SYSREC, // UNIT=SYSDA,SPACE=(TRK,(15,15)) //SYSDISC DD DISP=(NEW,CATLG,CATLG), // DSN=SYSADM.REORGDIS.SYSDISC, // UNIT=SYSDA,SPACE=(TRK,(15,15)) //SYSPUNCH DD DISP=(NEW,CATLG,CATLG), // DSN=SYSADM.REORGDIS.SYSPUNCH, // UNIT=SYSDA,SPACE=(TRK,(15,15)) //SYSCOPY DD DISP=(NEW,CATLG,CATLG), // UNIT=SYSDA,SPACE=(TRK,(30,30)), // DSN=SYSADM.DSN8D51A.DSN8S51E.COPY //SYSIN DD * REORG TABLESPACE DSN8D81A.DSN8S81E DISCARD FROM TABLE DSN8810.EMP WHEN (WORKDEPT = 'D11') SHRLEVEL NONE COPYDDN SYSCOPY
Example 16: Discarding records from multiple tables while reorganizing a table space
The following control statement specifies that REORG TABLESPACE is to reorganize table space DBKC0501.TLKC0501. During reorganization, the following records are discarded:
- Records in table TBKC0501 that have a value in the QT_INV_TRANSACTION column that is less than or equal to 700, and a value in the NO_DEPT column that is equal to X'33303230'.
- Records in table TBKC0502 that have a value in the NO_WORK_CENTER column that is equal to either X'333031303120' or X'333032303620'.
This discard criteria is specified with the DISCARD option. Any discarded rows are to be written to the SYSDISC data set, as specified by the DISCARDDN option.
//STEP1 EXEC DSNUPROC,UID='IUKCU105.REORG2', // UTPROC='', // SYSTEM='SSTR' //UTPRINT DD SYSOUT=* //SYSDISC DD DSN=IUKCU105.REORG2.STEP1.SYSDISC, // DISP=(MOD,CATLG,CATLG), // UNIT=SYSDA,SPACE=(2000,(20,20),,,ROUND), // DCB=(RECFM=FB,LRECL=80,BLKSIZE=2400) //SYSREC DD DSN=IUKCU105.REORG2.STEP1.SYSREC, // DISP=(MOD,CATLG,CATLG), // UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSCOPY DD DSN=IUKCU105.REORG2.STEP1.SYSCOPY, // DISP=(MOD,CATLG,CATLG), // UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //LOADSTMT DD DSN=IUKCU105.REORG2.STEP1.SYSPUNCH, // DISP=(MOD,CATLG,CATLG), // UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) // UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSIN DD * REORG TABLESPACE DBKC0501.TLKC0501 SHRLEVEL REFERENCE PUNCHDDN LOADSTMT DISCARDDN SYSDISC UNLOAD CONTINUE DISCARD FROM TABLE TBKC0501 WHEN (QT_INV_TRANSACTION <= 700 AND NO_DEPT = X'33303230') FROM TABLE TBKC0502 WHEN (NO_WORK_CENTER = X'333031303120' OR NO_WORK_CENTER = X'333032303620') /*
Example 17: Reorganizing only those partitions that are in REORG-pending status
The following control statement specifies that REORG TABLESPACE is to reorganize only those partitions of table space DBKQAA01.TPKQAA01 that are in the range from 2 to 10 and are in REORG-pending status.
//STEP1 EXEC DSNUPROC,UID='JUKQU1AA.REORG6', // UTPROC='',SYSTEM='SSTR' //SYSREC DD DSN=JUKQU1AA.REORG6.STEP1.SYSREC, // DISP=(MOD,DELETE,CATLG), // UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSCOPY DD DSN=JUKQU1AA.REORG6.STEP1.SYSCOPY, // DISP=(MOD,DELETE,CATLG), // UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSUT1 DD DSN=JUKQU1AA.REORG6.STEP1.SYSUT1, // DISP=(MOD,DELETE,CATLG), // UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SORTOUT DD DSN=JUKQU1AA.REORG6.STEP1.SORTOUT, // DISP=(MOD,DELETE,CATLG),UNIT=SYSDA,// SPACE=(4000,(20,20),,,ROUND)//SYSIN DD * REORG TABLESPACE DBKQAA01.TPKQAA01 SCOPE PENDING PART 2:10/*
Example 18: Creating a FlashCopy image copy with REORG TABLESPACE
The following REORG TABLESPACE utility control statement reorganizes table space DSN8SA1D and creates a FlashCopy® image copy.
//SYSADMA JOB (ACCOUNT),'NAME',NOTIFY=&SYSUID//* //UTIL EXEC DSNUPROC,SYSTEM=VA1A,UID='TEMP',UTPROC='' //DSNUPROC.SYSREC DD DSN=SYSOPS.DSNAME, // DISP=(NEW,DELETE), // SPACE=(CYL,(20,20),RLSE), // UNIT=SYSDA,VOL=SER=SCR03 //DSNUPROC.SYSUT1 DD DSN=SYSOPS.SYSUT1, // DISP=(NEW,DELETE,DELETE), // SPACE=(CYL,(9,90),RLSE), // UNIT=SYSDA,VOL=SER=SCR03 //DSNUPROC.SYSIN DD * LISTDEF COPY_LIST INCLUDE TABLESPACE DSN8DA1A.DSN8SA1D TEMPLATE SCOPY UNIT(SYSDA) DISP(NEW,CATLG,DELETE) DSN(DSNT1.&DB..&TS..CPY1.D&TIME.) TEMPLATE FCOPY UNIT(SYSDA) DISP(NEW,CATLG,DELETE) DSN(DSNFC.&DB..&TS..P&PA..D&TIME.) REORG TABLESPACE LIST COPY_LIST SHRLEVEL REFERENCE FLASHCOPY YES FCCOPYDDN(FCOPY) COPYDDN(SCOPY)
Example 19: Reorganizing only clone tables
The REORG TABLESPACE control statement indicates that REORG TABLESPACE is to reorganize only clone tables from the specified table spaces.
REORG TABLESPACE DBKQBS01.TPKQBS01 CLONE