Appendix E. Determining the Number of Locked Resources

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:

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 8 UAP Development Guide.
  2. 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