Solved

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

Posted on 2016-07-23
3
52 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
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 34

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

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…
The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …

773 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