Hitachi

Hitachi Advanced Database Setup and Operation Guide


16.11.5 Working with multi-chunk tables (when the multi-node function is being used)

This subsection explains operations on multi-chunk tables when the multi-node function is being used.

When the multi-node function is being used, the following operations on multi-chunk tables must be unique to the multi-node function:

For details about operations in relation to base tables when using the multi-node function, see 16.11.2 Base table operations (when the multi-node function is being used).

All other operations are the same as when the multi-node function is not used. For details, see 11.4 Performing operations on multi-chunk tables.

Organization of this subsection

(1) Merging chunks (when the multi-node function is being used)

To merge multiple chunks into a single chunk, execute the adbmergechunk command. For details, see 11.4.9 Merging chunks (to reduce the number of chunks).

When the multi-node function is being used, you can execute the adbmergechunk command on the master node only. You cannot execute this command on a slave node.

(2) Changing a chunk comment (when the multi-node function is being used)

To set a chunk comment, or to change or delete a comment that was set, execute the adbchgchunkcomment command. For details, see 11.4.11 Changing the comment for a chunk.

When the multi-node function is being used, you can execute the adbchgchunkcomment command on the master node only. You cannot execute this command on a slave node.

(3) Changing chunk status (when the multi-node function is being used)

To change the status of a chunk, execute the adbchgchunkstatus command. For details, see 11.4.12 Changing the chunk status.

When the multi-node function is being used, you can execute the adbchgchunkstatus command on the master node only. You cannot execute this command on a slave node.