Using the REORG Utility in ACR to REORG a Database

In this article, we'll go over how to use the REORG Utility to re-organize a database in ACR.

The sections below cover performing a REORG in the following methods:

• Performing a REORG in ACR/Summary via panels
• Performing a REORG in ACR/Detail via panels
• Performing a REORG in ACR/Summary via JCL
• Performing a REORG in ACR/Detail via JCL

Performing a REORG in ACR/Summary via panels

1) Go to Setup -> Database Utilities (option number 4)

2) Select "Database update utilities" (option number 2)

3) Select "Reorganize history" (option number 4)

4) In the next window that appears, hit F5 after confirming your JCL Library Information.

5) Next, choose if you want to REORG the database itself or if you want to REORG and put the contents into a new database. If you are performing a REORG to remove old pointers or clean up deleted entries, then use option 1. If you are performing a REORG to increase the amount of Job Ids or Histories in your database, or to make a copy of a database, then select option 2. 

6) Specify your Volume and a new number of estimated Job Ids and Histories. Note that if you are performing a reorg to resolve space issues, these estimates must be larger than the current size. If you are uncertain what your current limit of Jobs or History is, you can find this information via a List History report

7) After entering in the information required, hit F5 and submit the JCL. If the Return Code is 0000, then you have successfully performed a REORG.

Performing a REORG in ACR/Detail via panels

1) Go to Setup -> Database Utilities (option number 4)

2) Select "Database update utilities" (option number 2)

3) Select "Reorganize history" (option number 4)

4) In the next window that appears, hit F5 after confirming your JCL Library Information.

5) If performing a REORG in ACR/Detail, the next window that appears will have you confirm the databases you want to REORG. Submit the JCL that follows after hitting F5.

Performing a REORG in ACR/Summary via JCL

If possible, it is recommended to perform a REORG via the panels, outlined in an earlier section of this article. Those instructions automatically perform all actions within this section. If you do not have access to the panels, or the panels aren't configured in your environment, then continue with the instructions in this section.

Reorg a history database into itself

This method is generally performed to remove old pointers or clean up deleted entries.

1. Download the sample SUMHFR JCL
2. Update the license, library and database names with your actual dataset names. Use the same database for both the UNIHF1 and UNIHF2 parameters.
3. Run the JCL

Reorg a history database into a new file

This method is generally performed when copying your history database into a secondary file, or to resize your database into a smaller or larger database. 

1. Download the sample SUMHFR2 JCL. The JCL is used to reorg an existing database (UNIHF1) into a new database (UNIHF2).
2. Update the license, library and database names with your actual dataset names. Use the a different database name for the UNIHF1 and UNIHF2 parameters.
3. If you are unsure what the size of your current database is, you can find the size via a List History report. Your current database size is required to determine your new database size.
   
   The two lines of interest from the List History report are:
   
   
4. Adjust the values in STEP2.UNIINP based on the following calculations of the values within your List History report. 
   
   The current database job limit based on the sample List History report is 100. To double this size in a REORG, adjust the first 8-digit values to 00000200:
   

    REORG HF 0000020000010000

   Next, multiply your new job limit by the average number of histories per job ID from your List History Report. The sample report has 50 histories per job, so this value will be 10000. This becomes the last 8-digits values:
   

    REORG HF 0000020000010000

5. Update the RECORDS specification within the STEP1.SYSIN step based on the following calculation: take your new maximum histories (the last 8-digits from Step 4) and add 0.5% to it. This is a close approximation of what the panels calculates. It's better to overestimate than to underestimate this value. Following the same example above, the estimated value would be:
   

   RECORDS(00010050)) 

6. Run the JCL

Performing a REORG in ACR/Detail via JCL

If possible, it is recommended to perform a REORG via the panels, outlined in an earlier section of this article. Those instructions automatically perform all actions within this section. If you do not have access to the panels, or the panels aren't configured in your environment, then continue with the instructions in this section.

1. Download the sample DETDHFR JCL
2. Update the license, library and database names with your actual dataset names.
3. Run the JCL