Hi,

I was wondering which database utilities would make use of INTRA_PARALLEL
YES.
Currently we have it set to NO (suggestion from vendor) and our DFT_DEGREE
is 1 and MAX_QUERYDEGREE is 1.
I'm thinking on setting INTRA_PARALLEL YES and MAX_QUERYDEGREE to # of cpu's
.. We will need to leave DFT_DEGREE to 1 and thus will only set it when we
know a query needs it.
However, I'm also wondering what else would then make use of multiple
agents.

A) Create Index: Uses multiple agents once INTRA_PARALLEL is set to YES, no
matter what the DFT_DEGREE is.

My question for the following is if it will use multiple agents if
INTRA_PARALLEL is set (or if it would use multiple agents no matter what
INTRA_PARALLEL is set to) and if ti will depend on DFT_DEGREE as well or
not.

B) Reorg?

C) Runstats?

D) Rollforward (after database restore)

E) Rollforward recovery after database crash (and thus in crash recovery)

F) Backward recovery after database crash (and thus in crash recovery)

For E and F, it states that parallel recovery will be used but that on
single CPU systems it will use multiple agents to read data but only 1 agent
to process while on multiple CPU systems it will use multiple agents to
process data as well. When we were going through crash recovery, using top
we only saw 1 agent really working (INTRA_PARALLEL=NO).

Thank you for answering my questions on this. I'm trying to build a case to
enable it against vendor recommendations but the vendor did state that as
long as DFT_DEGREE is left at 1 it should not be a problem.

Thanks.

"Erik Hendrix" <hendrix_erik@hotmail.com> wrote in message
news:6ecaf528dbf4b033ce75af264fb60499@news.teranew s.com...
> Hi,
>
> I was wondering which database utilities would make use of INTRA_PARALLEL
> YES.
> Currently we have it set to NO (suggestion from vendor) and our DFT_DEGREE
> is 1 and MAX_QUERYDEGREE is 1.
> I'm thinking on setting INTRA_PARALLEL YES and MAX_QUERYDEGREE to # of
cpu's
> . We will need to leave DFT_DEGREE to 1 and thus will only set it when we
> know a query needs it.
> However, I'm also wondering what else would then make use of multiple
> agents.
>
> A) Create Index: Uses multiple agents once INTRA_PARALLEL is set to YES,
no
> matter what the DFT_DEGREE is.
>
> My question for the following is if it will use multiple agents if
> INTRA_PARALLEL is set (or if it would use multiple agents no matter what
> INTRA_PARALLEL is set to) and if ti will depend on DFT_DEGREE as well or
> not.
>
> B) Reorg?
>
> C) Runstats?
>
> D) Rollforward (after database restore)
>
> E) Rollforward recovery after database crash (and thus in crash recovery)
>
> F) Backward recovery after database crash (and thus in crash recovery)
>
> For E and F, it states that parallel recovery will be used but that on
> single CPU systems it will use multiple agents to read data but only 1
agent
> to process while on multiple CPU systems it will use multiple agents to
> process data as well. When we were going through crash recovery, using top
> we only saw 1 agent really working (INTRA_PARALLEL=NO).
>
> Thank you for answering my questions on this. I'm trying to build a case
to
> enable it against vendor recommendations but the vendor did state that as
> long as DFT_DEGREE is left at 1 it should not be a problem.
>
> Thanks.
>
It may depend on the number of containers in each tablespace and whether the
containers are on different physical drives, as to whether it would help. If
you do have multiple containers on multiple drives per tablespace, I would
set it to yes.

INTRA_PARALLEL is for SELECTs and CREATE INDEX.

The utilities (BACKUP, LOAD) have their own parameters on the command
syntax to take advantage of parallel I/O and multiple CPU's.

Erik Hendrix wrote:

> Hi,
>
> I was wondering which database utilities would make use of INTRA_PARALLEL
> YES.
> Currently we have it set to NO (suggestion from vendor) and our DFT_DEGREE
> is 1 and MAX_QUERYDEGREE is 1.
> I'm thinking on setting INTRA_PARALLEL YES and MAX_QUERYDEGREE to # of cpu's
> . We will need to leave DFT_DEGREE to 1 and thus will only set it when we
> know a query needs it.
> However, I'm also wondering what else would then make use of multiple
> agents.
>
> A) Create Index: Uses multiple agents once INTRA_PARALLEL is set to YES, no
> matter what the DFT_DEGREE is.
>
> My question for the following is if it will use multiple agents if
> INTRA_PARALLEL is set (or if it would use multiple agents no matter what
> INTRA_PARALLEL is set to) and if ti will depend on DFT_DEGREE as well or
> not.
>
> B) Reorg?
>
> C) Runstats?
>
> D) Rollforward (after database restore)
>
> E) Rollforward recovery after database crash (and thus in crash recovery)
>
> F) Backward recovery after database crash (and thus in crash recovery)
>
> For E and F, it states that parallel recovery will be used but that on
> single CPU systems it will use multiple agents to read data but only 1 agent
> to process while on multiple CPU systems it will use multiple agents to
> process data as well. When we were going through crash recovery, using top
> we only saw 1 agent really working (INTRA_PARALLEL=NO).
>
> Thank you for answering my questions on this. I'm trying to build a case to
> enable it against vendor recommendations but the vendor did state that as
> long as DFT_DEGREE is left at 1 it should not be a problem.
>
> Thanks.
>
>