Appendix D. Formulas for Determining Operand Specification Values

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)