Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2011
    Posts
    4

    Unanswered: DB2 on SAN storage with high availability

    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

  2. #2
    Join Date
    Aug 2011
    Posts
    46
    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.

  3. #3
    Join Date
    Nov 2011
    Posts
    4
    What about SAN storage??

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    yes, what is the question about san storage. it is storage as any other storage
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Aug 2011
    Posts
    46
    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.

  6. #6
    Join Date
    Nov 2011
    Posts
    4
    The OS i will be using is RHEL

  7. #7
    Join Date
    Nov 2011
    Posts
    4
    IBM SAN storage raid R0+1

  8. #8
    Join Date
    Aug 2011
    Posts
    46
    follow this link:

    http://www.redbooks.ibm.com/redbooks/pdfs/sg246262.pdf

    quite old, but explains storage in detail

  9. #9
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by amitrai4 View Post
    Nice link. Fun to read such an old redbook where they still mention OS/2 or announce the new 64 bit environment

    <melancholic at the end of the year>
    Those were the days..
    </melancholic at the end of the year>

Posting Permissions

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