what kind of storage are common for Database files (physical storage i mean_

[l***@gmail.com]

Hi
Thank you for reading my post
Can some one please list waht kind of storage are common for Database files and in what situation we choose them?
for example, following are some storage devices that i know, but i can not figure out when we use them and what brands and model are supported by DB2

IDE hard disks
SATA hard disks
NAS
SAN
..

Thanks.

[Mark A]

Post by l***@gmail.com
Hi
Thank you for reading my post
Can some one please list waht kind of storage are common for Database
files and in what situation we choose them?
for example, following are some storage devices that i know, but i can not
figure out when we use them and what brands and model are supported by DB2
IDE hard disks
SATA hard disks
NAS
SAN
..
Thanks.

All of the above are supported.

Preferably, disks used for DB2 should be placed on some sort of redundant
disk array (such as RAID-5 or disk mirroring).

Internal disks are faster than SAN, which is faster than NAS. If you have an
OLTP database with a 98+% bufferpool hit ratio, disk speed is not as
important as if you had a large data warehouse with a lot of queries that
did table scans (as opposed to index access).

The one place that disk speed for OLTP does matter is the transaction log,
so putting the logs on your fastest device might be a good idea. But again,
it should a redundant array or use dual logging.