Tuning the buffer length for routine definition information

Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents]

[Index]

[Back]

[Next]

23.5.6 Tuning the buffer length for routine definition information

This section explains tuning of the buffer length for routine definition information (pd_routine_def_cache_size operand value).

Organization of this subsection: (1) Tuning method (1); (2) Tuning method (2); (3) Tuning method (3)

(1) Tuning method (1)

Information to be referenced

See the following system activity statistical information provided by the statistics analysis utility:

Routine definition cache hits count (# OF RTN-DEF CACHE HIT)
Number of routine definition information acquisition requests (# OF RTN-DEF GET REQ)

Tuning procedure: Obtain the routine definition cache hit rate with the following formula, and tune it so that the hit rate becomes 100%:; Routine definition cache hit rate (%) =; (routine definition cache hits count number of routine definition information acquisition requests) 100

Actions to be taken: Increase the value of the pd_routine_def_cache_size operand.

(2) Tuning method (2)

Information to be referenced

See the following system activity statistical information provided by the statistics analysis utility:

Total routine definitions cache size (RTN-DEF CACHE TOTAL SIZE)
Allocated routine definition cache size (RTN-DEF CACHE ALLOC SIZE)

Tuning procedure: Obtain the routine definition cache utilization factor with the following formula, and tune it so that the utilization factor becomes 90% or higher:; Routine definition cache utilization factor (%) =; (maximum value of total routine definitions cache size allocated routine definition cache size) 100

Actions to be taken: Reduce the value of the pd_routine_def_cache_size operand.

(3) Tuning method (3)

Information to be referenced

See the following system activity statistical information provided by the statistics analysis utility:

Plug-in routine definition cache hits count (# OF PLG-RTN CACHE HIT)
Number of plug-in routine definition acquisition requests (# OF PLG-RTN GET REQ)

Tuning procedure: Obtain the plug-in routine definition cache hit rate with the following formula, and tune it so that the hit rate becomes 100%:; Plug-in routine definition cache hit rate (%) =; (plug-in routine definition cache hits count number of plug-in routine definition acquisition requests) 100

Actions to be taken: Increase the value of the pd_routine_def_cache_size operand.

All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.