470,831 Members | 1,668 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,831 developers. It's quick & easy.

inter-partition? intra-partition?

Hi folks,

As I konw: database partition (aka data partition?), the database can
span multiple machines; table partition, the data within a table can
seperate by certain condition.

How about inter-partition and intra-partition? Is inter-partition
database partition...?
Laurence

Mar 19 '07 #1
1 4590
Laurence wrote:
Hi folks,

As I konw: database partition (aka data partition?),
I wouldn't call that "data partitioning". It just adds confusion.
the database can
span multiple machines; table partition, the data within a table can
seperate by certain condition.

How about inter-partition and intra-partition? Is inter-partition
database partition...?
Inter-/intra-partition is usually referred to in the context of parallelism,
i.e. inter-partition parallelism and intra-partition-parallelism. It
refers to how a SQL statement is executed. If a a statement is executed in
parallel across multiple database partitions, then we talk
about "inter-partition parallelism". If you have multiple
processes/threads participating in the statement execution on the _same_
database partition, then you have intra-partition parallelism. Both can be
combined, of course.

--
Knut Stolze
DB2 z/OS Admin Enablement
IBM Germany
Mar 19 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Frank Meng | last post: by
4 posts views Thread by Viper Venom | last post: by
7 posts views Thread by A.M | last post: by
6 posts views Thread by les | last post: by
reply views Thread by Hugo Ferreira | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.