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)