Re: intra_parallel throttling

LinkBack

Thread Tools

Display Modes

#1 (permalink)

02-29-2008, 01:56 AM

wane.gutterud@nashfinch.com

Posts: n/a

Re: intra_parallel throttling

On Feb 26, 12:46*am, Ian <ianb...@mobileaudio.com> wrote:
> wane.gutte...@nashfinch.com wrote:
> > We have a DB2 server using AIX 5.3 lpar with 10 logical cpus. There
> > are nine DB2 instances on the server with five at DB2 V9.1 FP3 and
> > four at DB2 V8.2 FP8. One of the DB2 V9.1 instances has INTRA_PARALLEL
> > set to ON and for all other instances it is set to OFF. The WebSphere
> > DataStage jobs that do some updates into this instance will consume
> > all 10 cpus and affects other instances. Wondering if there is a way
> > to throttle intra_parallel to only use maybe 8 of the 10 logical cpus?
> > Thanks.
>
> You don't really provide enough information to answer this question.
> Is this instance using DPF? *Are you sure that INTRA_PARALLEL is the
> culprit? *Because even with INTRA_PARALLEL set to NO, it's certainly
> possible for an instance to consume 10 CPUs. *(i.e. 10 separate
> connections to a database).
>
> Assuming you've determined that it is indeed INTRA_PARALLEL that is
> causing problems, see the DFT_DEGREE database config parameter and
> MAX_QUERYDEGREE database manager configuration parameters. *These
> allow you to define the limits you're looking for.
>
> Ian Bjorhovde

Thanks - I will check into those parameters.

No this is not DPF.

Just to verify that I understand correctly - I attributed the cpu
usage to intra_parallel based on a snapshot for applications and
relating the top cpu usage pids to a specific sql statement which
showed the following:
Agent process/thread ID = 4714640
Agent process/thread ID = 5062896
Agent process/thread ID = 3727382
Agent process/thread ID = 4030656
Agent process/thread ID = 5734566
Agent process/thread ID = 4247578
Agent process/thread ID = 3113092
Agent process/thread ID = 5628148
Agent process/thread ID = 5640230
Agent process/thread ID = 8073458
Agent process/thread ID = 5992498

« encryption & unicode | Problems with Import of UTF-8 files - Differences between LOAD andIMPORT »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 01:38 PM.

SEO

Re: intra_parallel throttling