Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Definition of logical partition and physical partition.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Definition of logical partition and physical partition.
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

Site Director


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

PostPosted: Mon Aug 10, 2009 10:01 am    Post subject:
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: 1013
Location: India

PostPosted: Mon Aug 10, 2009 2:21 pm    Post subject:
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    Post subject:
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    Post subject:
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: 1013
Location: India

PostPosted: Mon Aug 10, 2009 5:04 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to see VIEW definition from BMC c... rohanthengal DB2 1 Thu May 04, 2017 1:50 pm
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts creating a physical sequential file i... Shaheen Shaik JCL & VSAM 8 Wed Jun 29, 2016 3:46 pm
No new posts how to specifiy partition endings whe... Auryn DB2 5 Thu Apr 14, 2016 2:32 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us