Solved

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

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL 5.6.30 - daily outages 46 85
How to transfer long file names 5 103
iCloud for Desktop 3 63
vmware 6.5 and shared storage 2 80
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…
Arrow Electronics was searching for a KVM  (Keyboard/Video/Mouse) switch that could display on one single monitor the current status of all units being tested on the rack.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

739 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