Prev: Drawbacks of automatic storage?
Next: Table partitioning i DB2 9.7 LUW
From: Hardy on 31 Jan 2010 21:36

"Troels Arvin" <troels(a)arvin.dk> 写入消息
news:hjve18$3hh$1(a)news.net.uni-c.dk...
> Hardy wrote:
>>> > How many data partitions in your plan?
>>>
>>> You mean storage paths? It will probably have four LUNs for data
>>> storage (one for each HBA), and a special storage system for
>>> transaction logs.
>> 4 LUNs? each for important tablespace? the size of your database? the
>> size of active data?
>
> The LUNs will reside on a storage system which takes care of spreading
> the data over a very large number of disks. The four paths to the storage
> system accept I/Os concurrently. So, given four paths to the storage
> system, it seems to me that I should provide DB2 with four file systems
> (using automatic storage). Transaction logs will sit on a rather fast
> local RAID10.
>
> Does this make sense?
>
> --
> Troels

Nice. Transaction log on RAID10 is good.

You're not forced to use 4 LUNs but it's OK since you are using automatic
storage. btw, since you are using automatic storage, I'm curious about your
database size. I don't have experience and test data for automatic storage
on very large scale database, say, more than 1T.

btw, how much I/O capacity 4 HBAs can deliver is closely related to your
storage product, in case your configuration on HBA load balance and high
availability, consult your system administrator for that.


First  |  Prev  | 
Pages: 1 2
Prev: Drawbacks of automatic storage?
Next: Table partitioning i DB2 9.7 LUW