IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Definition of logical partition and physical partition.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Mon Aug 10, 2009 9:35 am
Reply with quote

I'm not quite clearly about the definition of logical partition and physical partition, can anybody provide me some tips?

Thanks.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Aug 10, 2009 10:01 am
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Mon Aug 10, 2009 2:21 pm
Reply with quote

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
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Mon Aug 10, 2009 4:39 pm
Reply with quote

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
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Mon Aug 10, 2009 4:44 pm
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Mon Aug 10, 2009 5:04 pm
Reply with quote

Did you check out this link

Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DROP & ALTER PARTITION-PBR DB2 0
No new posts Rotate partition-logical & physic... DB2 0
No new posts CONTROL-M SCHEDULING DEFINITION FACILITY Compuware & Other Tools 1
No new posts How to list BMS MAP screens in BMS Ph... CICS 2
No new posts DB2 - row_number function - Need 1st ... DB2 5
Search our Forums:

Back to Top