glog.processcontrol Property

glog.processcontrol.forceDBAForProcessPolling

21C

If set to true, this property ensures all Process Control polling explicitly sets the dedicated connection pool user to DBA.ADMIN. This ensures that PROCESS_CONTROL_REQUEST deletions and PROCESS_CONTROL_HISTORY work. If the DEDICATED_DBA connection had another VPD user assigned (i.e. corruption), the connection will be correct for all further uses.

Default: true

glog.processcontrol.pollingFrequency

glog.processcontrol.pollingStagger

6.4.3

These properties control PROCESS_CONTROL_REQUEST polling.

The stagger factor is a number between 0 and 1 that allows for staggering of PROCESS_CONTROL_REQUEST polling in a scalable environment. This removes the bias of one server for process scheduled for regular time intervals. E.g.,assume a bulk plan runs every hour. Without a stagger, the server whose minute polling is closest to the clock minute will always pick up the bulk plan. The stagged delta, d, allows us to poll somewhere between

   now + frequency*(1-d) < poll < now + frequency*(1+d)

effectively randomizing the polling around a 2-delta range from the true frequency.

These properties default to polling each minute, with a stagger of 15 seconds. i.e., each poll will occur at a minute +- 15 seconds.

glog.processcontrol.sortSavedQueries

Set to false to have saved query drop-downs on Process Control actions not be alphabetized.

Default: true.