DB2 tablespace management of DPF databases; best practices backup/recovery of very large (18 tb) databases

Hi all,

Can I get well reasoned advice on the best practices on tablespace management of DPF databases in terms of design for OLTP vs design for data warehouse (DW).

What are best practices for database backup and recovery of very large databases, typically multi terabytes (18 TB) in a DPF database environment?

What are the best practices for monitoring and tuning DPF multi-terabyte databases?

All comments, suggestion, links to relevant reading resources, real-life example or case study will be highly appreciated.

Thank in advance
Who is Participating?
mustaccioConnect With a Mentor Commented:
You do realize that most people don't work on weekends, don't you? :-)

Your questions are so generic that I can offer you very generic answers:


EnyinnayaAuthor Commented:
DB2 LUW gurus, Can I get a response to this post, please? Is everyone on vacation?
Gary PattersonConnect With a Mentor VP Technology / Senior Consultant Commented:
IBM publishes along list of publications, including several that document best practices for database administration, backup/recovery/replication, and performance management.  You didn't provide your version, so here are the links to the 8.1 and 8.2. docs:


- Gary Patterson
EnyinnayaAuthor Commented:
Hi Gary,
I am looking for specific information about Db2 With DPF flavor. Specifically, How does shops with very large Db2 DPF based database mange with their backup, regular recovery, reotg /runstats if any, and high level monitoring and tuning strategy.

Any one know of where I can find this information? Maybe something of a best practices or case study.

EnyinnayaAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 250 points for mustaccio's comment #a38288847
Assisted answer: 250 points for Gary_The_IT_Pro's comment #a38290005
Assisted answer: 0 points for Enyinnaya's comment #a38298899

for the following reason:

Guys provided good reading links but I don't think they understood the question which was basically how do you manage Very Large Database - VLDB viz: Backup, restore, tuning strategies, etc
All Courses

From novice to tech pro — start learning today.