Appendix C. 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 view analysis information buffers (pd_view_def_cache_size)
  4. Formulas for determining size of table definition information buffer (pd_table_def_cache_size)
  5. Formulas for determining total number of tables and RDAREAs per server locked with UNTIL DISCONNECT specified (pd_lck_until_disconnect_cnt)
  6. Formulas for determining size of routine definition information buffer (pd_routine_def_cache_size)
Organization of this section
C.1 Formulas for determining size of statistics log file (pd_stj_file_size)
C.2 Formulas for determining size of SQL object buffer (pd_sql_object_cache_size)
C.3 Formulas for determining size of view analysis information buffers (pd_view_def_cache_size)
C.4 Formulas for determining size of table definition information buffer (pd_table_def_cache_size)
C.5 Formula for determining total number of tables and RDAREAs per server locked with UNTIL DISCONNECT specified (pd_lck_until_disconnect_cnt)
C.6 Formulas for determining size of routine definition information buffer (pd_routine_def_cache_size)