Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2010
    Posts
    3

    Unanswered: Smp machines are linked together for db2 database

    Hello,
    I red a thread about db2 clustering, and somebody suggested to link together smp machines .
    Please help me to find an article , redbook and something else to read the base of this technology.

    Thanks,
    Szilva

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Are you referring to DPF - Data Partitioning Feature.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Apr 2010
    Posts
    3
    I think, no. I want to build such application as similar to oracle cluster. I think , the HADR is similar to oracle standby. I red an letter on dbforum, and it was suggested to build frame with smp machines.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Are you referring to PureScale, may be?

    DB2 pureScale Feature solution overview

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    All computers, even laptops, are SMP these days as they have multiple processors (or cores).

    There are three main kinds of clustering in DB2:

    • Traditional shared disk cluster with virtual IP that switches between servers.
    • DB2 HADR
    • IBM PureScale


    The first two options can be controlled with IBM Tivoli System Automation, which is included in some DB2 editions of DB2 and automatically installed when you install DB2 (ESE, WSE, but not sure about others).

    PureScale is like Oracle RAC.

    DPF is a parallel shared nothing database architecture designed primarily for data warehouses, and now is part of InfoSphere Warehouse.
    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
    Apr 2010
    Posts
    3
    The first clustering method is intresting to me. I would like to ask what method use db2 to syncronize update and insert origaneted from different servers.
    Oracle uses cache coherency.

    Thanks.

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by tszilv View Post
    The first clustering method is intresting to me. I would like to ask what method use db2 to syncronize update and insert origaneted from different servers.
    Oracle uses cache coherency.

    Thanks.
    In the first method, shared disk means that there is only one set of disks that are shared by both servers. When you failover, you have to unmount the disk from one server, and remount on the other server (they could be simultaneously mounted on both servers if you make absolutely sure the DB2 instance is only started on one of the servers at a time).

    The method where mutiple servers are using the same disk is DB2 PureScale, which is functionaly like Oracle RAC. You can google PureScale to find out the details of how it works.
    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
  •