Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2011
    Posts
    11

    Unanswered: Clustering in DB2

    Hello,

    I have an issue, can some one clarify it?

    In my environment, i want to install Db2 in 2 servers and have a cluster (where if any server go down the other one go up), how to configure the cluster on them ?

    I need that cluster be done without SAN

    plz help me ....

    Thanks in advance

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I believe that you need to look at HADR. Look it up in the manuals.

    Andy

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if you don't have a cluster software, you can use hadr and tsa for ha and failover
    the database will be available twice
    have a look at doc for details
    Initializing high availability disaster recovery (HADR) - IBM DB2 9.7 for Linux, UNIX, and Windows
    if a cluster software is available the setup is different - look at cluster in the same doc
    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

  4. #4
    Join Date
    Sep 2011
    Posts
    11
    thanks for ur info and i appreciate ur help

    but i feel confused

    sorry could you tell me what is meant by cluster software ??

    and if i already have a cluster software which type of cluster i can implement without SAN ?

    else if i don't have a cluster software ,, did the HADR help me to install db2 on two server without using SAN (where the second one will be online if the first go down) ?

    hint:
    in my environment it doesn't matter working under Linux or Windows

    sorry for disturbance ..

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    cluster software is a special software that does all operations in case of failure
    start with hadr : this is part of db2 and in some edition included in other charged
    hadr has nothing todo with san - it does a logbuffer shipping
    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

  6. #6
    Join Date
    Sep 2011
    Posts
    11
    i'll read more about HADR to know if it is suitable, else i'll ask again for more help

    Thanks a lot for your help

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    HADR does not require a SAN since it does not use shared disk, since each server has its own copy of the database.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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