RDAREA space shortage

Executor: HiRDB administrator

If a table is subjected to many data additions and deletions, a shortage of space might occur in the table's storage RDAREA. HiRDB issues the following messages for a table whose data retrieval efficiency or storage efficiency has been reduced:

KFPA12300-I
KFPH00211-I
KFPH00212-I

Organization of this section: (1) When to increase the size of an RDAREA; (2) Using the pddbls command to obtain the number of unused segments in the RDAREA; (3) Space shortage in a list RDAREA; (4) Using the facility for RDAREA automatic extension

(1) When to increase the size of an RDAREA

The size of an existing RDAREA should be increased or a new RDAREA should be created in the following cases:

When any of these messages is output frequently for a table stored in a particular RDAREA
When any of these messages is output during or immediately after table reorganization
When any of these messages is output during or immediately after index reorganization

In such a case, the database structure modification utility (pdmod command) should be used to increase the size of the RDAREA or to create a new RDAREA.

(2) Using the pddbls command to obtain the number of unused segments in the RDAREA

The pddbls command can be used determine how much unused space remains in RDAREA (number of unused segments).

Example

Use the pddbls command to check the number of unused segments in the RDAREA named RDAREA1:

 
pddbls -r RDAREA1 -a
 
STATE OF RDAREA
    RDAREA        ID       STATUS                 TYPE
                           OPNMODE
    RDAREA1       4        OPEN                   USER
                           INITIAL
    SEGMENT   75 / 700

Explanation: SEGMENT displays the number of unused segments, followed by the total number of segments. The number of unused segments is the remaining available space in the RDAREA.; In this example, the number of unused segments is 75, and the total number of segments is 700. When the number of unused segments is low, the RDAREA should be expanded.

(3) Space shortage in a list RDAREA

If execution of an ASSIGN LIST statement results in the number of created lists exceeding the number of lists that can be created in the RDAREA (KFPA11812-E message is output), you must use the database structure modification utility to add a list RDAREA.

If execution of an ASSIGN LIST statement results in a shortage of RDAREA pages (KFPA11756-E message is output), you must use one of the following methods to increase the RDAREA size:

RDAREA addition
RDAREA expansion
RDAREA reinitialization

When the size of a list RDAREA is expanded by means of RDAREA reinitialization, the lists stored in that list RDAREA are deleted and must be re-created with the ASSIGN LIST statement.

(4) Using the facility for RDAREA automatic extension

When an RDAREA space shortage occurs, the RDAREA can be extended automatically if space is available in the HiRDB file system area; this is called RDAREA automatic extension (for details on RDAREA automatic extension, see 15.8 RDAREA automatic extension).

15.1 RDAREA space shortage

(1) When to increase the size of an RDAREA

(2) Using the pddbls command to obtain the number of unused segments in the RDAREA

(3) Space shortage in a list RDAREA

(4) Using the facility for RDAREA automatic extension