Appendix D. Determining the Number of Locked Resources

This appendix provides and explains formulas for determining the number of locked resources needed to execute various SQL statements, utilities, and commands. The maximum number of locked resources is determined, some buffer space is added, and a pool size is set in the following operands:

Notes
  1. The number of locked resources count determined here is valid within a transaction. When multiple SQLs are executed in a single transaction, the total of their locked resources is needed. However, it is not needed if locking has already been applied. For details about locking, see the HiRDB Version 9 UAP Development Guide.
  2. For a HiRDB parallel server configuration, the number of resources for each back-end server must be computed in terms of the number of resources (RDAREAs, indexes, lines) managed by the applicable back-end server.
  3. The number of locked resources that is added when the pd_inner_replica_control operand is specified is requested only once during transaction execution.
Organization of this section
D.1 Definition SQLs
D.2 Data manipulation SQLs
D.3 Control SQL
D.4 Utilities and commands