On 18/02, Michael Green wrote:
> You are given 4 spindles to place TSM DB on them.
> How would you set them up to squeeze maximum performance for DB?
>
> 1. Dedicate each spindle for a DBC (result: 3 DBCs, one spindle left
> out, nevermind)
> 2. Create RAID 0 out of each pair of disks. Place a DBC on each RAID
> (result: 2 DBCs on two separate RAID 0)
> 3. Create RAID 1 out of each pair of disks. Place a DBC on each RAID
> (result: 2 DBCs on two separate RAID 1)
> 4. Create RAID 5 out of all spindles. Place one DBC on the RAID
> (result: 1 DBC on RAID5)
>
> Notes:
> a. There is no RAID 0+1
> c. Wasted space is not a concern
> --
> Warm regards,
> Michael Green

4.

RAID5 will give you the maximum amount of IOPS for the DB with disk
redundancy, though 4 disks is on the low side.

TSM mirroring doesnt help performance when doing expiration or reclamation
anyway which is what you want to optimize the DB for.

-km