This appendix provides and explains formulas for determining the number of locked resources needed in order to execute the various SQL statements. 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
- pd_until_disconnect_cnt operand in the server definition of each server
- 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 8 UAP Development Guide.
- For a HiRDB/Parallel Server, 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.
- Organization of this section
- E.1 Definition SQLs
- E.2 Data manipulation SQLs
- E.3 Control SQL
- E.4 Utilities and commands