create rdarea statement

This section explains the operands of the create rdarea statement. In the following table, each number corresponds to the number assigned to each operand.

No.	Operand
1	create rdarea RDAREA-name
2	[globalbuffer global-buffer-name]
3	for {registry\|LOB used by HiRDB (SQL REGISTRY)}
4	[page page-length characters]
5	[storage control segment segment-size pages]
6	[extension {use extension-segments-count segments\|nouse}]
7	file name "HiRDB file-system-area-name/HiRDB-file-name"
8	initial HiRDB-file-segments-count segments
--	[file name "HiRDB file-system-area-name/HiRDB-file-name"
--	initial HiRDB-file-segments-count segments]...
--	;

Organization of this subsection: (1) RDAREA-name; (2) globalbuffer global-buffer-name; (3) for {registry |LOB used by HiRDB (SQL_REGISTRY)}; (4) page page-length characters; (5) storage control segment segment-size pages; (6) extension {use extension-segments-count segments|nouse}; (7) file name "HiRDB-file-system-area-name/HiRDB-file-name"; (8) initial HiRDB-file-segments-count segments

(1) RDAREA-name

~<identifier> ((1-30))

Specify the name of the RDAREA to be used in the HiRDB system. ALL cannot be specified in an RDAREA name. When enclosed in double quotation marks ("), an RDAREA name is case sensitive; otherwise, it is not treated as being all in uppercase.

Examples

create rdarea "pdbuser01" for ...
In this case, the RDAREA name is treated as pdbuser01.
create rdarea pdbuser01 for ...
In this case, the RDAREA name is treated as PDBUSER01.

(2) globalbuffer global-buffer-name

~<identifier> ((1-16))

Specifies the name of a global buffer in the HiRDB system (or in the dictionary server for a HiRDB parallel server configuration) to temporarily allocate it to the RDAREA to be added. You cannot specify an index global buffer. To check the global buffer, use the pdbufls command.

Rules

This operand is required for the addition of a registry RDAREA.
The specified global buffer must have a buffer length greater than or equal to the page length of the RDAREA to be added. To check the size of global buffer, use the pdbufls command.
The global buffer length is the value specified in the -l operand of the pdbuffer statement in the system common definitions, or the maximum page length for the RDAREA to which the global buffer is assigned at the time of HiRDB startup, whichever is greater.
The specification of this operand loses effect once the HiRDB system starts normally. Therefore, you need to change the global buffer specification in the system common definitions at the next normal startup.
If you specify this operand, but the utility cannot allocate a global buffer, then an RDAREA cannot be added.

(3) for {registry |LOB used by HiRDB (SQL_REGISTRY)}

(4) page page-length characters

~<unsigned integer> ((4096-30720)) <<4096 or 8192>>

Specifies the page length of the HiRDB file comprising the RDAREA in bytes, in an integral multiple of 2,048.

Registry LOB RDAREA: A value of 8192 must be specified. Even if other values are specified, 8192 is assumed.

The page length specified in this operand is used as the smallest unit of data that is input/output by the HiRDB system to or from the RDAREA.

(5) storage control segment segment-size pages

(6) extension {use extension-segments-count segments|nouse}

Specifies whether or not to apply automatic extension of RDAREA.

For details about RDAREA automatic extension, see the HiRDB Version 9 System Operation Guide.

Prerequisites: You must have specified the -e or -a option for the HiRDB file system area that contains the RDAREA.

use extension-segments-count segments

Specifies that automatic extension of RDAREA is to be applied.

RDAREA automatic extension is applicable to registry RDAREAs and registry LOB RDAREAs only. The utility assumes nouse for any other type of RDAREA, even if use is specified.

Automatic extension occurs when the number of free segments in the RDAREA reaches the value set for the automatic extension timing, which you specify in the pd_rdarea_extension_timing operand.

extension-segments-count ~<unsigned integer> ((1-64000))

Specifies the number of extension segments.

For a HiRDB file system area for which pdfmkfs -e is specified.
The maximum number of HiRDB file extensions is 24. If this value is exceeded, an error occurs. An error also occurs if a space shortage occurs in the HiRDB file system area or the amount of space that is required exceeds the maximum size for a HiRDB file.
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.
For a HiRDB file system area for which pdfmkfs -a is specified.
An error occurs if there is not enough space to allocate the required HiRDB file system area on the disk that contains the HiRDB file or the amount of space that is required exceeds the maximum size for a HiRDB file.

nouse: Specifies that automatic extension of RDAREA is not to be applied.

Notes

New unused segments are added to the last HiRDB file constituting the RDAREA.
If allocation of unused segments fails due to a shortage of space in the HiRDB file system area, either you must extend or re-initialize the RDAREA or you must use the database reorganization utility to reorganize the data dictionary table.
If the number of extents exceeds the maximum value, integrate the extents in the HiRDB file system area containing the RDAREA or add HiRDB file in another HiRDB file system area to the RDAREA.
To integrate extents, 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.

(7) file name "HiRDB-file-system-area-name/HiRDB-file-name"

~((up to 167 characters))

Specifies the name of the HiRDB file system area and the name of the HiRDB file to be allocated to the RDAREA.