When definition SQL statements, utilities, and operation commands are used to process a shared table or shared index, HiRDB may internally issue the LOCK statement with IN EXCLUSIVE MODE specified and lock the target table and RDAREAs at all back-end servers. If any application accesses a table or index in a corresponding RDAREA, deadlock or server-to-server global deadlock may occur.
HiRDB internally issues the LOCK statement for the following definition SQL statements:
HiRDB internally issues the LOCK statement for the following utilities:
HiRDB internally issues the LOCK statement for the following operation command:
For details about the utilities and operation commands that cannot be executed on shared RDAREAs, see 15.6(8) Notes about using shared RDAREAs.