Modifying Physical Database Definitions › Increasing the Size of an Area › Extending the Page Range of an Area

Extending the Page Range of an Area

Steps

To extend the number of pages in an area, follow these steps:

1. If the additional pages being added to the area will reside in a new file, define the file.
2. Change the definition of the area specifying the number of additional pages to add to the area by using the EXTEND SPACE clause. On the EXTEND SPACE clause, specify to which file the additional pages will be mapped by using the WITHIN FILE clause.

   If the additional pages would cause the number of pages in the area to exceed the maximum space allowed, you can use the MAXIMUM SPACE clause to increase the maximum provided the page numbers are not assigned to another area that will be used in the same DMCL as the area being expanded.

3. Generate, punch and link all DMCLs that contain the segment with which the area is associated.
4. Allocate a new database file to contain the additional pages and initialize the file using the new DMCL.
5. If new pages are being added to the last file of the area:
   • Make the area to be processed unavailable for update under the central version.
   • Backup the area using an old DMCL.
   • Restore the area using an old DMCL, but referencing the new file through JCL statements.

     Note: If the area maps to its file on a one-to-one basis, it is necessary to include IDMSQSAM=ON in the RESTORE utility's SYSIDMS file.

   • Delete the old file and rename the new file.
   • Backup the expanded area.
6. Make the DMCLs and the new file available to the runtime environment.