Hi,

I must replace poor performing disks for my db2 sap database. Storage admin asigned 10 hdds from our corporate SAN (I mean I must decide in what RAID level disks will be configured(using SAN) ).
Config :
AIX 5.3
db2 8.1
SAP R/3
8 cpus
32 Gb RAM

I really must make the best out of these disks. So my thoughts are:
variant1
8 hdd's in RAID 5 for data
2 hdd's in RAID 1 for database logs.
variant2
10 hdd's in RAID 10 for data+logs

How does variant1 compares to variant2 ? Could I do better out of these 10 hdds ? Any suggestions ?

thank you in advance
Vilius

Ideally,
You should go for separate disks for the Logs if possible. That way it should be Var#1.

RAID-5 with SAN storage works great (DUAL-CORE). You should see significant performance Jump at your end. Do remember to Turn-on some key-performance variables in your database to get the best out of it. You can refer the "Best Practice guideline for Initial Cfg" from IBMDeveloperworks for that.

Thanks,
Jayanta (New Delhi, India).