Appendix D.4 Formula for determining total number of tables and RDAREAs per server locked with UNTIL DISCONNECT specified (pd_lck_until_disconnect_cnt)

The following formula is used to determine the total number of tables and RDAREAs per server locked with UNTIL DISCONNECT specified (pd_lck_until_disconnect_cnt). Note that the formula differs depending on the server type.

Formula
Server typeFormula
Single server(a + b + o + p + q) [Figure] 2 + {2 [Figure] (f + g + i + 1) + (g[Figure] h)} [Figure] e
Dictionary server(a + b) [Figure] 2 + {2 [Figure] (f + g + i + 1) + (g[Figure] h)} [Figure] e
Back-end server(a + b + o + p + q + r + s) [Figure] 2 + {2 [Figure] (f + g + i + 1) + (g[Figure] h)} [Figure] e
a:
Number of tables specified in LOCK TABLE statements with UNTIL DISCONNECT specified that are to be concurrently executed
b:
Number of RDAREAs that store the tables specified in LOCK TABLE statements with UNTIL DISCONNECT specified that are to be concurrently executed
e:
Number of utilities that are concurrently executed
f:
Number of LOB RDAREAs that store the tables to be processed by the utilities that are concurrently executed
g:
Number of RDAREAs that store the indexes to be processed by the utilities that are concurrently executed
h:
Number of indexes to be processed by the utilities that are concurrently executed
i:
Number of RDAREAs that store the tables to be processed by the utilities that are concurrently executed.
o:
Number of RDAREAs that store the tables to which the local buffers for data that are to be used concurrently are allocated
Add this number when using local buffers for data.
p:
Number of RDAREAs that store the tables to which the local buffers for index that are to be used concurrently are allocated
Add this number when using local buffers for index.
q:
Total number of tables that are the target of the indexes to which the local buffers for index that are to be used concurrently are allocated
Add this number when using local buffers for index.
r:
Total number of shared table storage RDAREAs specified by LOCK statements with IN EXCLUSIVE MODE specified that are to be concurrently executed
Add this number when using shared RDAREAs.
s:
Total number of all shared RDAREAs for index defined in the shared tables that are specified by LOCK statements with IN EXCLUSIVE MODE specified that are to be concurrently executed
Add this number when using shared RDAREAs.
Note: Utilities in this case includes the following:
  • Database load utility
  • Database reorganization utility
  • Free page release utility
  • Global buffer residence utility
  • Rebalancing utility (exclusive mode)