16.11.2 Base table operations (when the multi-node function is being used)

(1) Storing data in a base table (when the multi-node function is being used)

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

For details about the adbimport command, see adbimport (Import Data) in the manual HADB Command Reference.

To check whether it is possible to execute the adbimport command and a transaction simultaneously, see (4) Restrictions on simultaneously executing commands with transactions in 2.19.2 Nodes on which transactions and commands are executed.

To Page Top

(2) Releasing a base table from non-updatable status (when the multi-node function is being used)

• When the adbimport or adbidxrebuild command terminates abnormally

  If the adbimport or adbidxrebuild command terminates abnormally and makes the target base table of the processing non-updatable, re-execute the command that terminated abnormally, and release the base table from its non-updatable status.

  If the master node's HADB server terminates abnormally and the master node is switched over, execute the adbidxrebuild command on the new master node, and release the base table from its non-updatable status. At this time, execute the adbidxrebuild command with the --create-temp-file option specified.

  For details about the --create-temp-file option, see Specification format for the adbidxrebuild command under adbidxrebuild (Rebuild Indexes) in the manual HADB Command Reference.

• When the adbunarchivechunk command terminates abnormally

  If the adbunarchivechunk command terminates abnormally and makes the target base table of the processing non-updatable, re-execute the adbunarchivechunk command, and release the base table from its non-updatable status.

Note

For details about the non-updatable status of base tables, see 15.8.1 Steps to take when a base table becomes non-updatable.

To Page Top