Prior to v8, FP2, Utilities (BACKUP, LOAD etc) had the ability to soak up close
to 100% of CPU time. With BACKUP, LOAD and REORG all supporting online access,
this had the ability to make the online access very limited with respect to
timeslices. So, we've implemented "utilities throttling" - this config parameter
is the first step toward you allowing utilities to run online, but specify how
much they can affect standard workloads, whether they are transactional or
decision support.
Further enhancements (and better documentation and Control Center support) will
follow in future fixpaks, releases (perhaps 8.2) and versions.
This
> Hi Paul,
> I have installed the fp2 documentation, and looked for UTIL_IMPACT_LIM.
> Nothing came back from the search. The value set is 100 in the DBM CFG.
> To what things is it applied: backup only for now ?
> Which range of values can be set and what is the exact meaning ? Let say I
> set this value to 50 ?
> I would expect at least a definition of this new parameter, exactly like
> others I kind find in the administration Performance PDF guide. I looked and
> did not see anything.
> Regards,
> Jean-Marc
> > Jean-Marc,
> > You need to install the documentation fp2 for more details. But in
> > simple terms this is used to allocate resources to Utilities. You may
> > remember in the V8.1 Transition class there was a foil about being able to
> > throttle back utilities. This is the parameter that provides that
> facility.
> > > Hi, I've seen in the DBM CFG a new UTIL_IMPACT_LIM set to 100. There is
> a
> > > (very) short reference of this parameter in the FP2 Release Notes.
> > > I searched the online Information Center with "UTIL_IMPACT_LIM" but
> > nothing
> > > appeared.
> > > Can someone provide more info, like a complete description we should
> find
> > in
> > > the "configuring DB2 parameters" paragraphs.
> > > Regards,
> > > Jean-Marc