Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: DPF and PureScale

    what is the difference between DPF and PureScale?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    In short: many instances each accessing its own fraction of data versus many instances accessing the same data.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    As mentioned by n_i, DPF is based on a share nothing architecture, which is more appropriate for data warehouses (which is why it is now called InfoSphere Warehouse). Share nothing architectures like DPF are used in parallel database applications, where each query runs in parallel on each node (accessing the data for a particular table that each node contains) and the coordinator node "glues" the answers from each node back into a single answer to be return to the SQL statement requesting the query.

    PureScale is based on a shared disk architecture, more appropriate for OLTP.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    so if we have mixed environment (datawarehouse/OLTP) which one would be preffered?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  5. #5
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    MarkhamDBA, Not sure if this will help or not but here is a linke from V9.8 infocenter:

    Comparison of a DB2 pureScale environment with a multi-partition database environment

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by MarkhamDBA View Post
    which one would be preffered?
    For what purpose?

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you have OLTP and data warehouse queries hitting the same tables, DPF is not appropriate (too much overhead for OLTP). If they were different tables, you could partition the warehouse tables with DPF and not partition the OLTP tables in the same database.

    PureScale provides hardware scalability and flexibility (ability to grow your server(s) as needed beyond just one server for a given OLTP database) and some degree of fault tolerance (since you can loose one server and still keep going), but does not provide fault tolerance for storage since it uses shared disk (unlike HADR). PureScale does not provide any serious performance advantages (other than the ability to scale the hardware as needed) if your computing needs are fairly constant or the hardware can be scaled up without adding a whole new server.
    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
  •