Appendix C.5 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. The estimation formulas for the server common definition are the same as for back-end servers.

Formula
Server typeFormula
Single server{a + b + c + d +o + p + q + (t[Figure] 3) + (w[Figure] 2) + u + v + x} [Figure] 2 + {2 [Figure] (f + g + i + 1) + (g + y + z)} [Figure] e
Dictionary server(a + b + c + d) [Figure] 2 + {2 [Figure] (f + g + i + 1) + (g + y + z)} [Figure] e
Back-end server{a + b + c + d + o + p + q + r + s + (t[Figure] 3) + (w[Figure] 2) + u + v + x} [Figure] 2 + {2 [Figure] (f + g + i + 1) + (g + y + z)} [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
c: 1
This is the number for inner replica configuration management. Add this value when using the inner replica facility.
d:
Number of RDAREAs that store the tables specified in LOCK TABLE statements with UNTIL DISCONNECT specified that are to be concurrently executed
This is the number for replica group configuration management. Add this value when using the inner replica facility.
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
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.
t:
Number of SQL session-specific temporary tables that exist concurrently
Add this number when using SQL session-specific temporary tables.
u:
Total number of temporary table RDAREAs for storing the SQL session-specific temporary tables that exist concurrently
Add this number when using SQL session-specific temporary tables.
v:
Total number of temporary table RDAREAs for storing the temporary table indexes defined in the SQL session-specific temporary table that exist concurrently
Add this number when using SQL session-specific temporary tables.
w:
Number of SQL session-specific temporary table indexes that exist concurrently
Add this number when using SQL session-specific temporary tables.
x:
Total number of segments used in the RDAREAs that store the SQL session-specific temporary tables and SQL session-specific temporary table indexes that exist concurrently
Add this number when using SQL session-specific temporary tables.
y:
Number of sequence generators that are used
Add this number when using the database load utility.
z:
Number of RDAREAs for storing the sequence generators that are used
Add this number when using the database load utility.
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)