DB2 UDBL: Content Manager and intra-partition parallelism

Linda Billings

DB2 UDBL: Content Manager and intra-partition parallelism
We have Content Manager V8.2 fix pack 11 installed on Windows 2003 SP1
using DB2 V8 fix pack 14. (Yeah, I know. None of this is even supported.
Long story.) I've read in performance documentation for CM V8.3 that IBM
doesn't recommend that intra-partition parallelism be turned on. Why is that
and is this also true for CM V8.2?

Thanks much in advance!

Linda Billings

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Philip Gunning

Re: DB2 UDBL: Content Manager and intra-partition parallelism
(in response to Linda Billings)
The CM workload would generally not benefit from intra_partition parallelism being used. You didn't say you were non-dpf but I assume you aren't. Intra_partition parallelism generally benefits select queries and work that can be distributed. PG

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Linda Billings
Sent: Thursday, December 17, 2009 9:38 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 UDBL: Content Manager and intra-partition parallelism

We have Content Manager V8.2 fix pack 11 installed on Windows 2003 SP1
using DB2 V8 fix pack 14. (Yeah, I know. None of this is even supported.
Long story.) I've read in performance documentation for CM V8.3 that IBM
doesn't recommend that intra-partition parallelism be turned on. Why is that
and is this also true for CM V8.2?

Thanks much in advance!

Linda Billings

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Linda Billings

Re: DB2 UDBL: Content Manager and intra-partition parallelism
(in response to Philip Gunning)
We are not dpf.

Thanks, Phil. That's what I thought. Now I just have to convince our DBA that
this is so.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L