This section explains tuning the buffer length for table definition information (pd_table_def_cache_size operand value).
- Information to be referenced
- See the following system activity statistical information provided by the statistics analysis utility:
- Table definition information buffer hits count (#OF TBL-CACHE HIT)
- Number of table definition information acquisition requests (#OF TBL-DEF GET REQ)
- Tuning procedure
- Obtain the table definition information buffer hits rate with the following formula, and make changes to the definitions so that the hits rate becomes greater than 80%:
- Table definition information buffer hits rate (%) =
- (table definition information buffer hits count
number of table definition information acquisition requests)
100
- Actions to be taken
- Increase the value of the pd_table_def_cache_size operand.