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:
- pd_lck_pool_size operand in each server's server definition
- pd_fes_lck_pool_size operand in the front-end server definition
- Notes
- 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.
- 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.
- 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