what are the choices to expand an IDMS database area

Document ID : KB000117673
Last Modified Date : 18/10/2018
Show Technical Document Details
Question:
What different choices do I have for increasing the size of an IDMS database area?
Answer:
There are three choices.

  The best choice is also the one that involves the most work and time.  This is to Unload and Reload the records in the Area based on a new definition of the area that has a greater number of pages.
  This can be done using the UNLOAD and RELOAD utilities or the newer REORG utility, both documented in the Utilities Guide
https://docops.ca.com/ca-idms-ref/19/en/utilities

KD KB000024632  for basic UNLOAD/RELOAD
  https://comm.support.ca.com/kb/what-are-the-steps-to-run-a-basic-unloadreload/kb000024632

KD KB000027396  for basic REORG
https://comm.support.ca.com/kb/how-can-i-get-started-on-the-first-execution-of-the-new-reorg-utility-to-expand-a-database-area/kb000027396
 
  Second best choice is EXPAND PAGE utility which keeps the same number of pages in the area but increases the Page Size.
  This choice does not do any record level access so no re-clustering or re-organizing is done.  It simply adds more space on each page to contain more records.
  Depending on the current page size or the size of the records that will be stored on those pages, this choice may not provide the additional space you need.  The page size may already be large and the page size may have originally been calculated to be the optimal size for the records being stored in the area.
  Every database SEGMENT has a clause that indicates the maximum number of records per page.  Default is 255.  So if the pages in the area are already near 255 records per page, increasing page size will not help much, or at all.
 
Doc for EXPAND PAGE
 https://docops.ca.com/ca-idms-ref/19/en/utilities/utility-statements/expand-page
 
       The third choice is an EXTEND SPACE modification to the AREA definition, which allows you to add an additional FILE to the area, but again no reorganization of records/clusters is done and the additional file is only available for overflow.
 NOTE:  If this is done it should be considered an emergency operation and very temporary. Unload/Reload or REORG should be scheduled as soon as possible to reload all records into the larger area using a definition that includes the new file as primary space.
 
KD KB000024352 for basic  EXTEND SPACE
https://comm.support.ca.com/kb/what-is-the-procedure-and-syntax-required-to-do-an-extend-space-on-an-area/kb000024352
 
also see  https://comm.support.ca.com/kb/i-am-wondering-about-the-performance-impact-of-extend-space-vs-expand-page/kb000032810  
 
 
Additional Information:
https://docops.ca.com/ca-idms/19/en/administrating/administrating-ca-idms-database/modifying-physical-database-definitions/increasing-the-size-of-an-area