The EXPAND PAGE utility increases the page size of an area by transferring a database file to a new file with an expanded block size.
The EXPAND PAGE utility increases the page size of an area by transferring a database file to a new file with an expanded block size.
This article describes the following information:
You need this privilege
Expand the pages of a file
All areas that map to the file.
  ►►─── EXPAND page for FILE segment-name.file-name ───────────────────────────►  ►─── INTO ddname ───────────────────────────────────────────────────────────►  ►─── NEWSIZE new-page-size ─────────────────────────────────────────────────►◄  
  • FILE
    Specifies the file whose pages are to be expanded.
  • segment-name
    The name of the segment associated with the file.
  • file-name
    The name of the file.
  • INTO
    Specifies the external name of the output file.
  • ddname
    The external z/OS or CMS name of the new file.
  • filename
    The external z/VSE name of the new file.
    Specifies the new page size.
  • new-page-size
    The new page size, in bytes. The new page size must be a multiple of four and greater than the current page size.
A page at a time from the old file is read. The page is expanded adding the new space before the footer section of the page. The space management entry for the page is adjusted to reflect the added space. The space management pages are also expanded, but they continue to have the same number of entries as before.
How to submit the EXPAND PAGE statement
You submit the EXPAND PAGE statement only through the batch command facility. You must be running CA IDMS/DB in local mode. You must also vary affected areas to retrieval mode or offline in all currently executing DC/UCF systems.
If an area maps to more than one file
You can expand pages in only one file at a time. If you are expanding the pages for an area that maps to more than one file, you must run the EXPAND PAGE utility once for each file the area is associated with.
Regenerate DMCL modules
After running the EXPAND PAGE utility, you must:
  • Alter the page size of the area to the new page size in all files where the area is used. Please remember that you should only change the PAGE SIZE on the ALTER AREA segment, because altering the PRIMARY SPACE even to the current value can result in any EXTEND SPACE attribute being removed.
  • Regenerate all DMCLs containing the file's segment.
The pages are expanded but the space management pages are not relocated. Therefore, when you redefine an area whose page size has been expanded, you must use the ORIGINAL PAGE SIZE clause of the AREA statement.
JCL Considerations
When you submit an EXPAND PAGE statement through the batch command facility, the JCL to execute the facility must include statements to define the files to be processed.
For more information about the generic JCL used to execute the batch command facility, see the section for your operating system in this section.
The following example directs the EXPAND PAGE utility to increase the size of the EMPDEMO.EMPDEMO file.
expand file empdemo.empdemo    into newfile      newsize 4820;
Sample Output
The EXPAND PAGE utility produces the following listing after successful completion of the statement in the previous example.
IDMSBCF                                              IDMS Batch Command Facility                            mm/dd/yy   PAGE 1  EXPAND FILE EMPDEMO.EMPDEMO INTO NEWFILE NEWSIZE 4820; 0UT000039 Starting Expansion of file EMPDEMO.EMPDEMO 0UT015007   SMI based on 4,276 characters for area EMPDEMO.EMP-DEMO-REGION  UT015008       Low page 75,001   High page 75,100   Page group 0  UT000040 Expansion complete  Status = 0  AutoCommit will COMMIT transaction  Command Facility ended with no errors or warnings
For more information about recompiling DMCL modules and for sectionlines on when to use the EXPAND PAGE utility, see the
CA IDMS Database Administration Section