DB2 on SAN storage with high availability

singh_ajaykumar · #1 (**permalink**) 12-19-11, 01:38

I need to configure DB2 9.7 databases, need good documentation for installation and configuration as i am sort of new for DB2, the scenario is as below

1) 2 instances
2) Should be clustered with HADR
3) Should have capability of connecting to San Storage
4) In case of failover of storage shouldb e able to use local HDD
5) On revival of storage sync up between Storage and Local HDD should happen
6) Replication between local HDD on DB2 servers required

any suggestions??

Thanks in advance

amitrai4 · #2 (**permalink**) 12-19-11, 01:48

For HADR you can refer to;

IBM developerWorks : Best Practices: DB2 High Availability Disaster Recovery

Point 4 and 5, are storage subsystem and OS dependent.

singh_ajaykumar · #3 (**permalink**) 12-19-11, 01:59

What about SAN storage??

przytula_guy · #4 (**permalink**) 12-19-11, 02:02

yes, what is the question about san storage. it is storage as any other storage

amitrai4 · #5 (**permalink**) 12-19-11, 02:08

which SAN are you using? IBM,EMC, Veritas etc.... sync and replication(your point 4,5 ) , as I mentioned earlier, dependent on the specific SAN, your SAN admins should be able to help you out there.

as a general guide line for DB2 data you can use raid 5 for transaction logs raid 10 if you wish.