hi group
so i installed my second processor and have already seen dramatic
results. i was reading the db2 manual (imagine that) and in chapter
29, scaling your configuration through adding processors, mention is
made of the "enable intra-partition parallelism" (intra_parallel)
param. this sounds like a param i would like to set to system at the
very least... but when i do db2set -lr i don't see it. i looked around
in the control center and didn't see it either... i also didn't see
anything about max_querydegree. i set default degree (dft_degree) to
-1 (system decides), guessing that this was a good starting point. can
someone a) tell me how to set these params and b) confirm that letting
the system decide is a good idea? i am running UDB 7.1 fp5 on red hat
7.2.
TIA
steve
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
- Re: [DB2EUG] setting intra_parallel steve shapero
- Re: [DB2EUG] setting intra_parallel Ian D. Bjorhovde
- Re: [DB2EUG] setting intra_parallel Philip Nelson (DBA)
- Re: [DB2EUG] setting intra_parallel sobotka
- Re: [DB2EUG] setting intra_parallel Henry J. Cobb
