16.26 Updated-row columnizing facility operations (when the multi-node function is being used)
For details about the operation of the updated-row columnizing facility, see 11.18 Using the updated-row columnizing facility (maintaining the retrieval performance for column store tables). This section provides notes specifically for when the multi-node function is used.
-
Execute the adbcolumnize command on the master node.
-
The status of the updated-row columnizing facility (whether the facility is enabled or disabled) is maintained after a master node switchover occurs.
-
The maintenance processing of the updated-row columnizing facility is performed on the master node.
-
The maintenance processing is not performed while a transaction or a command that connects to an HADB server is running on an HADB server in a multi-node configuration.
-
If a master node switchover occurs when the updated-row columnizing facility is enabled, the maintenance processing is performed after the switchover is completed.
-
If you leave the updated-row columnizing facility enabled without handling any errors related to that facility, the maintenance processing that is performed after the master node switchover is complete will result in an error, and an error message will be output.
-
If no maintenance processing is performed for 24 hours consecutively, the KFAA51277-I message is output. However, the monitoring timer is reset when a master node switchover occurs. Therefore, if no maintenance processing is performed for 24 hours consecutively again after a master node switchover occurs, the KFAA51277-I message is output again.
-
The processing that starts I/O control of files used by the updated-row columnizing facility is performed on each node. If such processing fails on the new master node, the maintenance processing that is performed after the master node switchover is complete will result in an error.