Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

15.8.4 Method that expands HiRDB files in the HiRDB file system area

This method automatically expands the HiRDB files up to the upper limit of the HiRDB file system area. If no free space is available in the HiRDB file system area during automatic extension, automatic extension cannot be executed. In this case, expand the RDAREA or reorganize the tables and indexes in the RDAREA. If the number of HiRDB file extents exceeds the maximum of 24, consider consolidating HiRDB file system area extents or expanding the RDAREA. If the number of extents in the HiRDB file system area exceeds the maximum (the number of extensions exceeds the maximum number specified in the -e option of the pdfmkfs or pdfchfs command), consider consolidating HiRDB file system area extents or increasing the maximum number of extensions by changing the value of the -e option in the pdfchfs command. Note that the maximum number of extents that can be changed by the pdfchfs command is the value of the -e option in the pdfmkfs command. If this maximum number might be exceeded, consider consolidating HiRDB file system area extents. For details about how to consolidate a HiRDB file system area, see (3)(a) Consolidate HiRDB file system area extents.

Organization of this subsection
(1) Setting automatic extension
(2) Actions to take when the size of the HiRDB file system area has become insufficient
(3) Action to take when the number of HiRDB file extensions reaches the maximum number
(4) Action to take when the number of HiRDB file system area extensions reaches the maximum number

(1) Setting automatic extension

The following is the procedure for setting automatic extension:

Procedure
  1. If necessary, modify the HiRDB system definition, and use the pd_rdarea_extension_timing operand to specify automatic extension triggers. For details about automatic extension triggers, see 15.8.1(2) Automatic extension triggers.
    For details about how to modify the HiRDB system definition, see 9.1 Modifying HiRDB system definitions or 9.2 Modifying HiRDB system definitions while HiRDB is running (system reconfiguration command).
  2. If you are using the pdfmkfs command to create a HiRDB file system area, specify the maximum extensions count (-e option). If a HiRDB file system area is a regular file, we recommend that you initialize the HiRDB file system area by specifying the -i option.#1
  3. When you create an RDAREA, specify an extended segment count in the utility's control statement#2.
#1
If the HiRDB file system area was not initialized by specifying the -i option, you might not be able to recover the RDAREA from the backup files acquired using the database copy utility (pdcopy command). This is because HiRDB file additions, automatic extension of other RDAREAs, or the like have increased the number of extents in the HiRDB file system area beyond the upper limit. In this case, consolidate the extents in the HiRDB file system area and reassess the value specified for the -e option of the pdfmkfs command. For details about extent consolidation, see (3)(a) Consolidate HiRDB file system area extents.
#2
This can be specified in the CREATE RDAREA, EXPAND RDAREA, INITIALIZE RDAREA, or ALTER RDAREA statement of the database initialization utility, database structure modification utility, or registry facility initialization utility.

(2) Actions to take when the size of the HiRDB file system area has become insufficient

This section explains the actions to take when automatic extension cannot be executed because of a capacity shortage in the HiRDB file system area.

Procedure
  1. Use the pdfmkfs command to create a HiRDB file system area. If a HiRDB file system area is a regular file, we recommend that you initialized the HiRDB file system area by specifying the -i option.
  2. Use the pdrorg command to unload the table data. This is a recommended step and is not required. However, executing this step will improve performance. For details about how to unload data, see the manual HiRDB Version 9 Command Reference.
  3. Use the pdmod command (expand rdarea statement) to expand the RDAREA. Add and assign the HiRDB file system area created in step 1. For details about how to expand an RDAREA, see 15.3 Increasing the size of an RDAREA (RDAREA expansion).
  4. Use the pdrorg command to reload the table data. If data was unloaded in step 2, reload it. For details about how to reload data, see the manual HiRDB Version 9 Command Reference.
  5. Use the pdlogswap -d sys -w command to swap the system log files.
  6. Use the pdcopy command to back up data. For details about how to back up data, see 6. Backup Procedures.

Notes on using the inner replica facility
If you are using the inner replica facility, the number of HiRDB files making up the expanded RDAREA will no longer match the number for the other RDAREAs in the replica group. To copy the contents of an RDAREA to another RDAREA, use one of the methods below. If the RDAREA being expanded is an original RDAREA, use either method 1 or method 2. If the RDAREA being expanded is a replica RDAREA, use method 2.
  1. Delete all replica RDAREA definitions, and then perform the procedure described above. After you finish this procedure, redefine the replica RDAREAs.
  2. Perform the procedure described above. Before copying the data object for use in another RDAREA, use the define copy rdarea statement of the database structure modification utility to copy the RDAREA configuration information from the data object source. For details, see Modifying and copying the configuration information of an RDAREA in an inner replica in the HiRDB Version 9 Staticizer Option Description and User's Guide.

(3) Action to take when the number of HiRDB file extensions reaches the maximum number

When the number of HiRDB file extents reaches the maximum number (24), automatic extensions can no longer be performed. If this happens, take one of the following actions:

  1. Consolidate HiRDB file system area extents.
  2. Initialize RDAREAs.
  3. Expand RDAREAs using the method described in (2) Actions to take when the size of the HiRDB file system area has become insufficient.

Take either the action described in 1. or the action described in 3. if multiple RDAREAs are assigned to a single HiRDB file system area.

(a) Consolidate HiRDB file system area extents

Use the following procedure to consolidate extents (merge all extents into one).

Procedure
  1. Use the pdstop command to terminate HiRDB normally.
  2. Use the pdfbkup command to back up the HiRDB file system area.
  3. Use the pdfmkfs command to reinitialize the HiRDB file system area.
  4. Use the pdfrstr command to recover the HiRDB file system area. Perform recovery using the backup made in step 1.
  5. Use the pdstart command to start HiRDB normally.
(b) Reinitialize the RDAREAs

Reinitialize the RDAREAs. For details about how to reinitialize RDAREAs, see 15.4 Modifying the size or attributes of an RDAREA (RDAREA reinitialization). If you specify the initialize rdarea statement of the pdmod command, however, take note of the following cautions:

If you do not specify these operands, the RDAREAs will be re-created at the same sizes as when they were defined originally.

(4) Action to take when the number of HiRDB file system area extensions reaches the maximum number

If the number of HiRDB file system area extents reaches the maximum number, automatic extensions can no longer be performed. In this case, take one of the following actions:

  1. Consolidate HiRDB file system area extents.
  2. Increase the maximum number of HiRDB file system area extensions (applicable when a small value is set in the pdfchfs command for the maximum number of extensions).
(a) Consolidate HiRDB file system area extents

For details about how to consolidate a HiRDB file system area, see (3)(a) Consolidate HiRDB file system area extents.

(b) Increase the maximum number of HiRDB file system area extensions

The procedure for increasing the maximum number of HiRDB file system area extensions while HiRDB is stopped is explained below. This procedure can also be performed while HiRDB is running. For details, see pdfchfs (Modify management information for a HiRDB file system area) in the manual HiRDB Version 9 Command Reference. Note that the maximum number of extensions that can be increased is the value of the -e option in the pdfmkfs command. If you need to increase the number of extensions beyond this maximum value, consolidate the HiRDB file system area extents.

Procedure
  1. Use the pdstop command to terminate HiRDB normally.
  2. Use the pdfchfs command to specify the maximum number of HiRDB file system area extensions.
  3. Use the pdstart command to start HiRDB normally.