This appendix provides and explains formulas for determining specification values for various system definition operands. This appendix contains the following sections:

1. Formulas for determining size of statistics log file (pd_stj_file_size)
2. Formulas for determining size of SQL object buffer (pd_sql_object_cache_size)
3. Formulas for determining size of table definition information buffer (pd_table_def_cache_size)
4. Formulas for determining total number of tables and RDAREAs per server locked with UNTIL DISCONNECT specified (pd_lck_until_disconnect_cnt)
5. Formulas for determining size of routine definition information buffer (pd_routine_def_cache_size)

Organization of this section

D.1 Formulas for determining size of statistics log file (pd_stj_file_size)

D.2 Formulas for determining size of SQL object buffer (pd_sql_object_cache_size)

D.3 Formulas for determining size of table definition information buffer (pd_table_def_cache_size)

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

D.5 Formulas for determining size of routine definition information buffer (pd_routine_def_cache_size)