When a REORG job completes, it prints a status report of the current REORG process. This report can also be produced using the REORG STATUS REPORT ONLY option. The report is made up of several sections, which contains an analysis of the current REORG operation and a status of the REORG tasks.
REORG Status Report - Section 1
The first section of the REORG Status Report identifies an overall status of the REORG operation.
****************************************************************************** * * * REORG Status Report * * Identifying time stamp: 2005-11-17-13.44.06.388141 * * Unload subschema=EMPTSS01 Unload segment=EMPDEMO Unload DMCL=EMPTDMCL * * Reload subschema=EMPTSS01 Reload segment=EMPBDEMO Reload DMCL=EMPBDMCL * * * ****************************************************************************** Options in effect ----------------- Divide processing 3 ways Notify interval=1 Job submission=YES SHARE=YES STOP AFTER CLEANUP CREATE ALL WORKFILES reuse workfiles=NO SORTEXIT=NO Overflow Percentage=10 Concurrent jobs=5 GENERATE DBKEYS FILES=YES Current status -------------- SETUP=completed UNLOAD=completed RELOAD=completed CLEANUP=completed total tasks=23 tasks completed=23 reload areas are not locked
REORG Status Report - Section 2
The next section identifies all the records and sets being processed by the REORG operation. The sequence numbers are assigned by REORG and are used to identify RECORDS and SETS in REORG work files. They have no relation to record or index IDs that are assigned to database records.
System indexes are assigned to groups. All indexes in the same group are offloaded and rebuilt together. Indexes are assigned to the same group when they share a common page range.
Records and Sets ---------------- Set=EMP-NAME-NDX Sequence=1 Index group=1 Set=JOB-TITLE-NDX Sequence=2 Index group=2 Set=SKILL-NAME-NDX Sequence=3 Index group=2 Set=COVERAGE-CLAIMS Sequence=4 Set=DEPT-EMPLOYEE Sequence=5 Set=EMP-COVERAGE Sequence=6 Set=EMP-EXPERTISE Sequence=7 Set=EMP-EMPOSITION Sequence=8 Set=MANAGES Sequence=9 Set=REPORTS-TO Sequence=10 Set=JOB-EMPOSITION Sequence=11 Set=OFFICE-EMPLOYEE Sequence=12 Set=SKILL-EXPERTISE Sequence=13 Record=COVERAGE Sequence=1 Record=DENTAL-CLAIM Sequence=2 Record=DEPARTMENT Sequence=3 Record=EMPLOYEE Sequence=4 Record=EMPOSITION Sequence=5 Record=EXPERTISE Sequence=6 Record=HOSPITAL-CLAIM Sequence=7 Record=INSURANCE-PLAN Sequence=8 Record=JOB Sequence=9 Record=NON-HOSP-CLAIM Sequence=10 Record=OFFICE Sequence=11 Record=SKILL Sequence=12 Record=STRUCTURE Sequence=13
REORG Status Report - Section 3
The next section of the report identifies unique page ranges within the source and target databases. All records in the same page range share one or more pages and do not overlap with records outside the page range. These ranges are used by REORG setup to determine how to slice up a database.
Page ranges that contain only indexes are also identified.
Areas and Slices ---------------- Unload area=EMPDEMO.EMP-DEMO-REGION low page=175001 high page=175400 Records only area subrange low page=175021 high page=175400 Index only area subrange low page=175002 high page=175017 Unload area=EMPDEMO.INS-DEMO-REGION low page=175401 high page=175600 Records only area subrange low page=175421 high page=175600 Records only area subrange low page=175402 high page=175419 Unload area=EMPDEMO.ORG-DEMO-REGION low page=175601 high page=175800 Records only area subrange low page=175621 high page=175800 Index only area subrange low page=175602 high page=175619 Reload area=EMPBDEMO.EMP-DEMO-REGION low page=275001 high page=275800 Records only area subrange low page=275041 high page=275800 Index only area subrange low page=275002 high page=275033 Reload area=EMPBDEMO.INS-DEMO-REGION low page=276001 high page=276400 Records only area subrange low page=276041 high page=276400 Records only area subrange low page=276002 high page=276037 Reload area=EMPBDEMO.ORG-DEMO-REGION low page=277001 high page=277400 Records only area subrange low page=277041 high page=277400 Index only area subrange low page=277002 high page=277037 Index only area subrange low page=277002 high page=277037
REORG Status Report - Section 4
The next section reports the portions of each page range assigned to each slice.
Unload slice=1 Unload slice range low page=175021 high page=175147 Unload slice range low page=175421 high page=175520 Unload slice range low page=175402 high page=175419 Unload slice range low page=175621 high page=175720 Unload slice=2 Unload slice range low page=175148 high page=175274 Unload slice range low page=175521 high page=175600 Unload slice range low page=175721 high page=175800 Unload slice=3 Unload slice range low page=175275 high page=175400 Reload slice=1 Reload slice range low page=275041 high page=275294 Reload slice range low page=276281 high page=276400 Reload slice range low page=277161 high page=277280 Reload slice=2 Reload slice range low page=275295 high page=275547 Reload slice range low page=276041 high page=276160 Reload slice range low page=276002 high page=276037 Reload slice range low page=277281 high page=277400 Reload slice=3 Reload slice range low page=275548 high page=275800 Reload slice range low page=276161 high page=276280 Reload slice range low page=277041 high page=277160
REORG Status Report - Section 5
The next section describes the status of each task and the work files assigned to the task. The data set name is displayed only if dynamic work file allocation is used.
Tasks and Work File Usage ------------------------- Task#=1 Task=UNLOAD type=S slice=1 status=completed SYS002 O/P DDNAME=WU00001 DSN=USERA01.EMPDEMO.WORKFILE.WU00001 SYS002 O/P DDNAME=WU00002 DSN=USERA01.EMPDEMO.WORKFILE.WU00002 SYS002 O/P DDNAME=WU00003 DSN=USERA01.EMPDEMO.WORKFILE.WU00003 SYS003 O/P DDNAME=WU00010 DSN=USERA01.EMPDEMO.WORKFILE.WU00010 Task#=2 Task=UNLOAD type=S slice=2 status=completed SYS002 O/P DDNAME=WU00004 DSN=USERA01.EMPDEMO.WORKFILE.WU00004 SYS002 O/P DDNAME=WU00005 DSN=USERA01.EMPDEMO.WORKFILE.WU00005 SYS002 O/P DDNAME=WU00006 DSN=USERA01.EMPDEMO.WORKFILE.WU00006 SYS003 O/P DDNAME=WU00011 DSN=USERA01.EMPDEMO.WORKFILE.WU00011 Task#=3 Task=UNLOAD type=S slice=3 status=completed SYS002 O/P DDNAME=WU00007 DSN=USERA01.EMPDEMO.WORKFILE.WU00007 SYS002 O/P DDNAME=WU00008 DSN=USERA01.EMPDEMO.WORKFILE.WU00008 SYS002 O/P DDNAME=WU00009 DSN=USERA01.EMPDEMO.WORKFILE.WU00009 SYS003 O/P DDNAME=WU00012 DSN=USERA01.EMPDEMO.WORKFILE.WU00012
REORG Status Report - Section 6
The next section shows the work file summary. This example shows the general-purpose files used during the unload and reload phases. Other sections show index files, sorted data files, and DBKEYS files.
All work file summary reports show the estimated size of each file and the attributes used in determining those sizes. BPT is Blocks Per Track; TPC is Tracks Per Cylinder; and *3390* indicates that attributes were based on a generic 3390 device, as opposed to a specific volume.
An asterisk (*) following a DDNAME indicates that the file was created by a REORG job executing as part of the current operation and therefore will be deleted automatically during cleanup.
Unload/Reload work file summary ------------------------------- DDname DSN Estimated Size ------ --- -------------- WU00001 * USERA01.EMPDEMO.WORKFILE.WU00001 1 Trk Estimate based on: VOLSER=*3390* BLKSIZE=27998 BPT=02 TPC=15 UNIT=SYSDA SPACE=Trk PRI=1 SEC=1 WU00002 * USERA01.EMPDEMO.WORKFILE.WU00002 1 Trk Estimate based on: VOLSER=*3390* BLKSIZE=27998 BPT=02 TPC=15 UNIT=SYSDA SPACE=Trk PRI=1 SEC=1 &vellip. WU00039 * USERA01.EMPDEMO.WORKFILE.WU00039 1 Trk Estimate based on: VOLSER=*3390* BLKSIZE=27998 BPT=02 TPC=15 UNIT=SYSDA SPACE=Trk PRI=1 SEC=1 Total primary space: 0 Cyl 39 Trk 0 Blk
REORG Status Report - Section 7
The next section is a recap of tasks that have completed in task order. It shows when the task was started, when it was completed, and the job that processed the task.
****************************************************************************** * * * Recap of TASK activity * * * ****************************************************************************** Task#=1 Task=UNLOAD type=S slice=1 status=completed jobname=USERA01Y jobid=JOB01048 UT019000 Task 1 UNLOAD slice 1 starting at 2005-11-17-13.44.35.255392 UT019003 Task 1 UNLOAD slice 1 completed at 2005-11-17-13.44.35.884474 Task#=2 Task=UNLOAD type=S slice=2 status=completed jobname=USERAXXA jobid=JOB05591 UT019000 Task 2 UNLOAD slice 2 starting at 2005-11-17-13.44.35.752587 UT019003 Task 2 UNLOAD slice 2 completed at 2005-11-17-13.44.36.077111
REORG Status Report - Section 8
The next section shows the tasks processed by each job in job name sequence.
****************************************************************************** * * * Recap of JOB activity * * * ****************************************************************************** jobname=USERA01Y jobid=JOB01048 UT019000 Task 1 UNLOAD slice 1 starting at 2005-11-17-13.44.35.255392 UT019003 Task 1 UNLOAD slice 1 completed at 2005-11-17-13.44.35.884474 jobname=USERAXXA jobid=JOB05591 UT019000 Task 2 UNLOAD slice 2 starting at 2005-11-17-13.44.35.752587 UT019003 Task 2 UNLOAD slice 2 completed at 2005-11-17-13.44.36.077111 jobname=USERAXXB jobid=JOB05592 UT019000 Task 3 UNLOAD slice 3 starting at 2005-11-17-13.44.35.826364 UT019003 Task 3 UNLOAD slice 3 completed at 2005-11-17-13.44.36.103013
REORG Status Report - Section 9
The last section shows task activity in chronological order. When completed, it shows the elapsed time from when REORG was started to when it completed.
****************************************************************************** * * * Recap of activity by time of day * * * ****************************************************************************** USERA01Y JOB01048 UT019000 Task 1 UNLOAD slice 1 starting at 2005-11-17-13.44.35.255392 USERAXXA JOB05591 UT019000 Task 2 UNLOAD slice 2 starting at 2005-11-17-13.44.35.752587 USERAXXB JOB05592 UT019000 Task 3 UNLOAD slice 3 starting at 2005-11-17-13.44.35.826364 USERAXXC JOB05593 UT019002 Task 4 UNLOAD index group 1 starting at 2005-11-17-13.44.35.866943 USERA01Y JOB01048 UT019003 Task 1 UNLOAD slice 1 completed at 2005-11-17-13.44.35.884474 USERAXXC JOB05593 UT019005 Task 4 UNLOAD index group 1 completed at 2005-11-17-13.44.35.985660 USERAXXA JOB05591 UT019003 Task 2 UNLOAD slice 2 completed at 2005-11-17-13.44.36.077111 USERAXXB JOB05592 UT019003 Task 3 UNLOAD slice 3 completed at 2005-11-17-13.44.36.103013 USERA01Z JOB01069 UT019000 Task 5 RELOAD1 slice 1 starting at 2005-11-17-13.46.56.274321 USERA01Z JOB01069 UT019003 Task 5 RELOAD1 slice 1 completed at 2005-11-17-13.46.57.381739 . . . USERAXXA JOB05622 UT019005 Task 22 REBUILD4 index group 1 completed at 2005-11-17-13.47.21.060599 USERA01Z JOB01069 UT019005 Task 23 REBUILD4 index group 2 completed at 2005-11-17-13.47.21.228884 USERA01Z JOB01069 UT019014 All REORG phases have been completed at 2005-11-17-13.47.48.448372 USERA01Z JOB01069 UT019015 REORG elapsed time: 0 days 0 hours 3 minutes 42 seconds
RELOAD Statistics Report - Section 1
The following example shows standard database statistics as returned from an ACCEPT DATABASE STATISTICS command. The values reflect the processing done by the current RELOAD1 or RELOAD2 task.
UT005002 DATABASE LOAD STATISTICS DATABASE LOADED ON 01/15/08 AT 21:24:53 PAGES READ ................... 62 PAGES WRITTEN ................ 59 PAGES REQUESTED .............. 86 CALC RCDS IN TARGET PAGE ..... 268 CALC RCDS OVERFLOWED ......... 0 VIA RCDS IN TARGET PAGE ...... 3,869 VIA RCDS OVERFLOWED .......... 0 LINES REQUESTED BY IDMS ...... 1,742 RCDS MADE CURRENT OF R/U ..... 4,137 CALLS TO IDMS ................ 4,144 FRAGMENTS STORED ............. 0 RECORDS RELOCATED ............ 0
RELOAD Statistics Report - Section 2
The following example shows additional statistics produced by REORG when reloading a database. The values reflect the processing done by the current RELOAD1 or RELOAD2 task.
RELOAD STATS RCDS READ .................... 4,380 RCDS STORED IN DATABASE ...... 4,137 RCDS STORED ON TARGET PAGE ... 3,998 RCDS STORED TARGET PERCENT ... 96 RCDS WRITTEN TO OVERFLOW ..... 243 RCDS CACHED .................. 357 RCDS STORED FROM CACHE ....... 139 RCDS OVERFLOW FROM CACHE ..... 218 CACHE STORAGE USED ........... 16,384 CACHE STORAGE LIMIT .......... 16,384
The fields reported are the following:
The total database records read from a work file. This does not include pointer and other work records
The number of database records stored in the database.
The number of database records stored on the intended target page.
The percentage of database records stored on their target page.
The number of database records written to a SYSOF2 file, to be processed by the RELOAD2 overflow task.
The number of database records written to the memory cache.
The number of database records that were written to memory cache and then stored in the database.
The number of database records that were written to memory cache and then written to the overflow work file.
The amount of allocated cache storage at the end of task. If this is the same as the storage limit, the cache reached its limit and records may have been written to the overflow file.
The maximum storage allowed for the overflow cache. This can be changed using the OVERFLOW CACHE option.
|
Copyright © 2014 CA.
All rights reserved.
|
|