Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    62

    Unanswered: Database storage considerations having 10 hdds ?

    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

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    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).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •