If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Storage considerations for database design

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-16-10, 10:55
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
Storage considerations for database design

Does the size of a Physical partition [PP size] of a Volume group[VG] matter for DB2 Database Design ?

PP sizes of all our database are not constant. Some of them are 16, 32, 64 and 128 MBs. I just wanted to check if this is something which DB2 recommends ? Or is it a consideration which AIX need team needs to look after.
Reply With Quote
  #2 (permalink)  
Old 04-16-10, 11:04
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
same size
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
  #3 (permalink)  
Old 04-16-10, 11:16
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
I didn't get you. When I say we have different sizes, they are not different for each database. For each database, db2 uses only one VG and the PP size is anyways same for all the LVs on that VG and so a single database use same PP sizes for all its tablespaces. But we have different dbs for different applications. One database for application 'x' use 16 MB as a pp size. Another database for application 'y' use 32 MB as pp size. Is there any proper recomendation of the size of the physical parition ?
Reply With Quote
  #4 (permalink)  
Old 04-16-10, 12:21
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
Does it matter if one room in your house bigger then another? No, as they have their own purpose. Same here.
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On