Solved

DB2 DPF and High Availability - Are they compatible in word and concept? This is what I mean...

Posted on 2016-07-23
3
64 Views
Last Modified: 2016-07-30
Dear DB2 DPF/High Availability experts,

I was having a technical discussion with a colleague about DB2 DPF and in the course of our discussion I went into describing what I think of when DB2 DPF is mentioned. I think of high-availability, scalability, performance, etc. But my colleague seem to insist that one does not talk about DB2 DPF and high availability in the same breath/sentence. What he is saying to me is that with high availability, you are talking about DB2 failover (we use HACMP deployment). In other words, DB2 DPF is one thing and DB2 high availability is another.
Is this a correct way to look at this two DB2 deployment setup?

Please help clear up this point for me and my friend.

Thanks

AP
0
Comment
Question by:Tonto Okonita
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 57

Assisted Solution

by:giltjr
giltjr earned 250 total points
ID: 41726779
Well DPF is about partitioning a table, basically taking a table and breaking into smaller pieces.  What does that have to do with high-availability?

DPF can increase performance and allow for scaling, but has nothing to do with availability.

How do you thing partitioning a table increases availability?
1
 
LVL 35

Accepted Solution

by:
Gary Patterson earned 250 total points
ID: 41728406
DPF = Database Partitioning Feature, which lets you take a large database and deploy it across multiple servers in order to improve performance.  Since only a portion of the database resides on each server, partitioning does not provide increased availability.
2
 

Author Closing Comment

by:Tonto Okonita
ID: 41736203
Thank you gentlemen...
0

Featured Post

The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question