Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    Join Date
    Sep 2009
    Posts
    7

    Unanswered: Db2 synchronization between 2 servers

    Hi,

    in our environment, we have 2 Solaris servers with DB2 V 9.1 fp 7.
    There is a process which writes data into DB2, but the second server being just a backup server for all the applications of first server (including DB2) there is no data written into second DB2.
    The structure and tablespace of both machines are same except for the DB mount file system.
    Here I need to have all the data on the first machine to be replicated to second machine once in a day.
    Being a newbie to Db2 the concept is very difficult for me to implement with, can I set up HADR or need to write some db2 commands to get the data from first server and populate to second server???

    Could you please help me in achieving this?


    Thanks,
    Arun

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Looks like a case for HADR to me.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Sep 2009
    Posts
    7
    Hi Nick, thank you very much for the response, would you be able to help me in setting up this HADR. Being Solaris I believe there are not clients for DB2, but I have DB2 client setup on Windows machine on the same network where I have catalogued both of the Solaris servers db2 to see over the console client. now please guide me....

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by arun26081983
    now please guide me....
    Certainly. Where do I send the invoice?

    As an alternative, you can guide yourself for free: DB2 Database for Linux, UNIX, and Windows
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this is all you need to know :
    DB2 High Availability Disaster Recovery (HADR) commands
    the rest is self explanatory
    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
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this is all you need to know :
    DB2 High Availability Disaster Recovery (HADR) commands
    the rest is self explanatory
    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

  7. #7
    Join Date
    Sep 2009
    Posts
    7
    Looks like need to buy HADR license for this, which might take time for the process. So is it possible anyway using db2 commands/scripts though I know that it would not be efficient? objective is to synchronize once in a day not ncessarily immediately, so any ways?

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369

  9. #9
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by arun26081983
    Looks like need to buy HADR license for this, which might take time for the process. So is it possible anyway using db2 commands/scripts though I know that it would not be efficient? objective is to synchronize once in a day not ncessarily immediately, so any ways?
    HADR is included for free in ESE (Enterprise Server Edition), and starting with version 9.5 it is also included for free in WSE (Workgroup Server Edition).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  10. #10
    Join Date
    Sep 2009
    Posts
    7
    that sounds good but mine is DB2 V 9.1 fp 7, so I think HADR will not be included for free. I will look at the option of log shipping. meanwhile any other ways using any commands?

  11. #11
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

  12. #12
    Join Date
    Sep 2009
    Posts
    7
    I have attached the db2 configuration from both machines, could somebody help me in doing the log shipping for replication/synchronization of DB2 servers.
    Attached Files Attached Files

  13. #13
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by dr_te_z
    Doesn't quite work as advertised. IBM was on the verge of buying Xkoto, but found out at the last minute that there are a bunch of SQL statements not supported.

    IBM may announce other options shortly.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  14. #14
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Quote Originally Posted by Marcus_A
    IBM may announce other options shortly.
    Do you know if this will replace xkoto?

  15. #15
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by db2girl
    Do you know if this will replace xkoto?
    Not exactly. That is all I can say at the moment.
    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
  •