View previous topic :: View next topic
|
Author |
Message |
dejunzhu
Active User
Joined: 08 May 2008 Posts: 390 Location: China
|
|
|
|
I'm not quite clearly about the definition of logical partition and physical partition, can anybody provide me some tips?
Thanks. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
can anybody provide me some tips |
Possibly - if you explain what kind of tips you are looking for. . .
Post your definitions for these terms and what is not clear to you. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Dejunzhu,
Physical partitions are defined & numbered when creating the tables(table-controlled partitioning).
Logical partitions are just logical partition numbers not real partition numbers. This logical partition comes into picture, when you implement rotating partition. [Same old dataset, but right now it contains new data]
Google on "Rotating Partitions".
Sushanth |
|
Back to top |
|
|
dejunzhu
Active User
Joined: 08 May 2008 Posts: 390 Location: China
|
|
|
|
dick scherrer wrote: |
Hello,
Quote: |
can anybody provide me some tips |
Possibly - if you explain what kind of tips you are looking for. . .
Post your definitions for these terms and what is not clear to you. |
I'm sorry, but I just cannot find the specific definition to both physical partition and logical partition. |
|
Back to top |
|
|
dejunzhu
Active User
Joined: 08 May 2008 Posts: 390 Location: China
|
|
|
|
sushanth bobby wrote: |
Dejunzhu,
Physical partitions are defined & numbered when creating the tables(table-controlled partitioning).
Logical partitions are just logical partition numbers not real partition numbers. This logical partition comes into picture, when you implement rotating partition. [Same old dataset, but right now it contains new data]
Google on "Rotating Partitions".
Sushanth |
Thanks for your kind reply.
But in the following link:
Differences between partitioning methods
I quite do not understand why 'A table space partition is identified by a physical partition number.' for 'Index-controlled partitioning'.
Is there a graphic solution to this? |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Did you check out this link
Sushanth |
|
Back to top |
|
|
|