inter-partition? intra-partition?

[Laurence]

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

[Knut Stolze]

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