130 Data Sharing in a Nutshell
coerced into incorporating a reasonable commit scope. This is hard to do and is
usually done as part of a long term project that must have full management
support from both the operations and application perspectives.
One approach is to set the URCHKTH and URLGWTH higher in the beginning,
gather the messages issued and request the offenders to write commit logic in
their programs. What would be high values in a fast processor? If CHKFREQ is 3
minutes, then set URCHKTH to 15, which would mean that a UR had gone 45
minutes without a commit, an extremely long time. The goal would be to reduce it
over time to 3 times the CHKFREQ. Similarly, set URLGWTH to 100 (100,000
updates) and reduce it over time to a goal that ...