By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

inter-partition? intra-partition?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.