7.4.3 Control statement (expand rdarea statement)
(1) RDAREA-name
<identifier> ((1-30))
Specifies the name of the RDAREA to be expanded. ALL cannot be specified as an RDAREA name. If the RDAREA name is enclosed in double quotation marks ("), it is treated as being case sensitive; otherwise, it is treated as all uppercase letters. The RDAREA name must be enclosed in double quotation marks if it includes a blank.
(2) extension {use extension-segments-count segments|nouse}]
Specifies whether or not to apply automatic extension to the RDAREA that is being expanded. When this operand is omitted, the system assumes the specification existing before the RDAREA is expanded.
Automatic extension of RDAREA is a facility that extends an RDAREA automatically in the event of a shortage of RDAREA space if there is enough space in the HiRDB file system area. If you use this facility for an RDAREA and a shortage of unused segments occurs, the system allocates new unused segments to the RDAREA. These new unused segments are added at the end of the HiRDB file constituting the RDAREA.
- Prerequisites
- You need to specify the -e option (specifying the number of extensions) for the HiRDB file system area containing the RDAREA.
- There must be enough space in the HiRDB file system area that contains the last HiRDB file constituting the RDAREA.
- use extension-segments-count segments
- Specifies that automatic extension of RDAREA is to be applied.
- The automatic extension of an RDAREA is applicable to data dictionary RDAREAs, data dictionary LOB RDAREAs, user RDAREAs, and user LOB RDAREAs, registry RDAREAs, and registry LOB RDAREAs. For any other type of RDAREA, the system assumes nouse, even if use is specified.
- For an RDAREA other than a LOB RDAREA, automatic extension occurs when there are no more used free segments or used segments. For a LOB RDAREA, automatic extension occurs when there are no more unused segments.
- extension-segments-count
<unsigned integer> ((1-64000)) - Specifies the number of extension segments.
- The maximum number of HiRDB file extensions is 24. If this value is exceeded, an error occurs. The maximum number of extensions per HiRDB file system area is determined by the value specified when the HiRDB file system area is created. Therefore, you need to define the maximum number of extensions, taking into account the number of files in the HiRDB file system area and the frequency of extension.
- nouse
- Specifies that automatic extension of RDAREA is not to be applied.
- Notes
- If allocation of unused segments fails due to a shortage of space in the HiRDB file system area, either extend or re-initialize the RDAREA or use the database reorganization utility to reorganize the table.
- If the number of extensions exceeds the maximum value, integrate the extensions in the HiRDB file system area containing the RDAREA or add HiRDB file in another HiRDB file system area to the RDAREA.
To integrate extensions, make a backup copy with pdfbkup, initialize the HiRDB file system area with pdfmkfs, then restore the HiRDB file system area from its backup copy using pdfrstr.
- The last file is locked from the beginning to the end of the automatic extension process.
(3) file name "HiRDB-file-system-area-name/HiRDB-filename"
((up to 167 characters))
Specifies a file to be added to the RDAREA, in terms of a HiRDB file system area name and a HiRDB file name.
- Rules
- Enclose HiRDB-file-system-area-name/HiRDB-filename in double quotation marks (").
- Do not include a linefeed character inside the double quotation marks.
- You can allocate a maximum of 16 HiRDB files per RDAREA.
- The database structure modification utility (pdmod) creates the HiRDB file in the specified HiRDB file system area.
- HiRDB-file-system-area-name/HiRDB-filename must be unique in the HiRDB system.
- For a list RDAREA, use a HiRDB file system area with a purpose of WORK.
- If you are extending the RDAREA to a HiRDB file system area with a sector length specified, the page length of the RDAREA must be a multiple of the sector length.
- HiRDB-file-system-area-name
<pathname> - Specifies the name of the HiRDB file system area.
- HiRDB-filename
<HiRDB filename> ((1-30 characters)) - Specifies the name of the HiRDB file (which cannot begin with pl).
(4) initial HiRDB-file-segments-count segments
<unsigned integer>
Specifies the number of segments in this file in the RDAREA file. The number of segments is the total number of pages/segment size. For details about how to estimate the total number of pages, see the HiRDB Version 8 Installation and Design Guide. The size of a HiRDB file cannot exceed 2 GB, regardless of the number of segments.