Speeding up CA DB/Reorg

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

 

Question:

Using CA DB/Reorg, program USRDRVR, what are some ways to speed up performance of the DB/REORG utility?

 

Answer:

Regarding DB/REORG performance, there are many ways you can improve the DB/REORG job execution time:  AREA SIZE:  If this is a very large REORG, you can run the REORG by area.  REORG execution time is directly related to the size of the areas, number of records in the areas and the number of set linkages for these records. The jobs can also be run step by step, although  this will not reduce the overall time it will allow them to break up the job into perhaps more manageable time portions.  INDEX SR8 records.  If you have many SR8 Index records, DB/REORG can rebuild them however you may find a MAINTAIN INDEX faster. On the other hand, if the DB/REORG is reorganizing an index set sorted by db-key, or an area containing integrated index sets sorted by db-key, these areas have to be included in the PROCESS statement, COPY AREA setting.

 
SYSIDMS PREFETCH 
DB/REORG does utilize the PREFETCH parameter for read-ahead processing. 

Lastly, when executing DB/REORG ensure that no CV or local update jobs 
are accessing the database as DB Reorg will not attempt to run against an area 
locked for update. 

18.0 DB/REORG PTF:

RI47284 DB/REORG SORT MESSAGES ARE SHOWN IN SYSOUT FILE

18.5 DB/REORG PTF: 
RI70751 DB/REORG SAMPLE JCL USES SORTMSG DD STATEMENT 

Problem IDMS Problem #: 5005 
PROBLEM DESCRIPTION: 
If an attempt to read or write a database page fails in the DBIO 
routines due to a possible DMCL mismatch, the likely status that 
results is an 09DD. The minor code 'DD' is not documented. 
***** Product Documentation Change ***** 
CA IDMS DB Reorg User Guide Release 18.5.00 
Chapter 7: Messages 
Message Text 
DBIO Error Codes: 
<after:> 
DA = DBNAME not valid or segment name cannot be used as DBNAME 

<add:> 
DD = Attempt to read/write a page failed; possible DMCL mismatch. 

PRODUCT(S) AFFECTED: CA IDMS Release 18.5, Release 18.0
------------------------------------------------------------------------------------------

Additional Information:

CA DB/REORG User Guide, Chapter 6: Operations, section ‘Database Access’.

 

 

 

Environment

Release: IDADSO00100-18.5-ADS-for CA-IDMS
Component: