The following shows the command to obtain a DATANE detail report when the RECORDS= parameter contains a value. In this detail report, we are requesting a detailed efficiency line for every 1000 records. By generating detail lines, you are able to determine how the efficiency ratings vary within the table. The variations can occur when a data table has been reorganized into sequential order, but follow-up processing has deleted and added rows in a random fashion in one or more areas of the table.
The online reorganization process allows you to limit the data rows that are being reorganized (FIRSTKEY and LASTKEY). A DATANE detail report with a reasonable number of detail lines can assist you in determining if such a limited OLREORG is helpful.
Note: Use the following as a guide to prepare your JCL. The JCL statements are for example only. Lowercase letters in a statement indicate a value you must supply. Code all statements to your site and installation standards.
//jobname See the previous note and JCL Requirements. // EXEC PGM=DBUTLTY,REGION=2M //STEPLIB See the previous note and JCL Requirements. //CXX DD DSN=cxx.data.set,DISP=SHR Directory data set //SYSIN DD * Command Input REPORT TYPE=DATANE,TABLE=REO,DBID=1022,RECORDS=01000 /*
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|