Skip to Content
0
Former Member
Dec 21, 2006 at 09:37 AM

Enable intra-partition parallelism, BW 3.5

52 Views

Hi,

We are running the following set-up :

BW 3.5, DB2 v8.2, AIX 5.2, 12 cpu, 75 gb ram, 7 partitions.

The Database Manager Configuration parameter INTRA_PARALLEL is set to "NO".

What's the performance gain (if any !) if we set the value to "YES" ? (with the current configuration : 12 cpu's/7 partitions).

If we add 2 more cpu's is it then a "must" to set INTRA_PARALLEL to "YES" ?

MAX_QUERYDEGREE should also be set.

Thanks in advance for help, hints and opinions.

Rgds,

Christian