Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: database load balancing

    Is there ann trick/nice way to do this ?
    Here is the thngs:
    2 UDB database on different box running instance.

    Any connection from client may go to either one of the two.

    also need to consider what if one box go down , can the second continue ? ??
    transaction 'll b ein syn for first an second ?
    sorry guys , need ideas ...

    Thanks in advance!

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    Are talking about partitioning a database, That would create 1 instance and you can put it accross different servers?
    David Quigley

  3. #3
    Join Date
    Nov 2003
    Posts
    121

    load balancing

    David,
    thanks for quick response!
    If it is a solution applicable can you explain how ?
    we wanna consider all posible scenario..

  4. #4
    Join Date
    Nov 2004
    Posts
    374

    take over

    partitioning a database means part of the table are residing on each box.
    this to benefit of the power of both boxes or for really big databases.
    There are scenarios - where if a partition goes down, another box can take over. See db2 documentation : backup-recovery - high availability that documents some scenarios...
    Best Regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Data Partitioning (DPF) is technique that splits tables across multiple partitions (on the same DB server or on different DB servers). It was designed to induce query parallelism on SQL statements on data warehouse systems that read large portions of the table wach time. It does not work as well on OLTP systems where only a few rows are accessed via an index.

    Even though DB2 DPF can be made to provide some semblance of failover protection and high availability, there are other DB2 facilities such as HADR (which is new in version 8.2) which are more appropriate to OLTP systems and high availability.

    However, none of these DB2 features provide a good solution for high availability and scalability in an OLTP environment, such as might be better provided by Oracle RAC. This is because with DPF, the overhead for DB2 figuring out which partition has the data is too high for most OLTP systems, and the HADR solution requires that the backup server be a passive standby system.
    Last edited by Marcus_A; 12-28-04 at 09:33.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Mar 2004
    Posts
    448
    DB2 version 8.2 on LUW has introduced HADR just like Oracle standby/dataguard.
    The replication is anothe way of doing the same thing.
    Also DB2 ver 8.2 also introduce client redirect, if one server is down,
    It will redirect to another server.

    Regards & thanks

    Mujeeb

  7. #7
    Join Date
    Nov 2003
    Posts
    121

    load balancing

    Is partitioning anyway applies to these scenario ?

    Any other way than HADR can achieve load balancing ?

    anyone know or have done in past ? I couldn't find exact scenario where LB and FO is needed.

Posting Permissions

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