Hitachi

Hitachi Advanced Database Setup and Operation Guide


16.10.4 Changing the storage location of DB areas

This subsection explains how to change the storage location of DB area files that comprise the data DB area and work table DB area when the multi-node function is being used.

Organization of this subsection

(1) Changing the storage location of the data DB area

The following shows the procedure for changing the storage location of the data DB area files (block special files) that comprise the data DB area when the multi-node function is being used.

Procedure:

  1. Terminate the HADB servers in the multi-node configuration normally.

    For details about how to terminate the HADB server, see 16.4.2 Terminating HADB servers in the multi-node configuration.

  2. Copy the data DB area file whose storage location you want to change.

    Copy to another area the data DB area file (symbolic link destination) whose storage location you want to change. When doing so, make sure that the copying destination can be accessed from the HADB servers on all nodes.

  3. On all nodes, change the symbolic link destination to the copying-destination area.

  4. Start the HADB servers in the multi-node configuration.

    For details about how to start the HADB servers, see 16.4.1 Starting the HADB servers in the multi-node configuration.

For a detailed description of the procedures for steps 2 and 3, see 11.10.5 Changing the storage location of data DB area files.

Important

When copying from the pre-change block special file to the post-change block special file by using the dd command, only execute the command on one node. In addition, changing of symbolic links must be performed on all nodes.

■ When using SCSI reservation for shared disk

When changing the storage location of a data DB area that is subject to SCSI reservation, you need to change the specification of the operands in the servers file of HA Monitor. Therefore, perform the following tasks before starting the HADB servers in the multi-node configuration in step 4 of the preceding procedure:

  • Revise the values specified for the scsi_device operand or dmmp_device operand in the servers file. Delete the device name of the original disk, and add the device name of the new disk.

Change the specification in the HA Monitor servers file on all nodes.

(2) Changing the storage location of the work table DB area

The following shows the procedure for changing the storage location of the work table DB area files that comprise the work table DB area when the multi-node function is being used.

Procedure:

  1. Terminate the HADB servers in the multi-node configuration normally.

  2. In the adb_blk_path_wrk operand in the server definition, specify the new area to use for the work table DB area file.

  3. Start the HADB servers in the multi-node configuration.