Tablespace backups in a DB2 LUW DPF database

In this blog post, I will share about few gotchas to look out for when backing up tablespaces in a DB2 DPF database. What is DPF? I wrote a detailed blog post on db2commerce.com.

Why Tablespace backups?

Why should we look into backing up tablespaces instead of the entire database? Below are couple of instances when we want to backup tablespaces:

  • You just created a new tablespace; Before taking an incremental/delta backup, the newly created tablespace needs to be backed-up.
  • Tablespace is in BACKUP PENDING state. This can happen when we perform a load operation for a recoverable database and specify the COPY NO parameter. We can remove the tablespace from the BACKUP PENDING state by backing up the tablespace.
  • Is it practical to do database backups? A database backup for a multi-terabyte database (think Data Warehouse) is not practical all the time. It consumes too many resources (CPU, storage, lock contention etc.). If the recovery effort is well thought out, we can get away with performing tablespace level backups.

Continue reading

Advertisements

Cross node DB2 Database recovery from TSM

In this blog post, I am going to share how to get ready for what I call a cross node database recovery from TSM. Cross node database recovery from TSM involves executing a series of steps to be able to access from (say) DR database server the database backups and logs that are on TSM before recovery operation can begin. These backups and logs actually would have originated from a different (say Production) database server.

tsm cross node recovery

Continue reading

DB2 DPF Tablespace Recovery Scenarios — Part 3 — Recover Tablespace(s) on ALL database partitions

In this blog post, I will share how to recover tablespaces from ALL database partitions in a DPF database and is 3rd out of 3 parts.The topic is “DB2 DPF Tablespace Recovery Scenarios”.

Part 1 covered “Recovering tablespaces on the Catalog Partition“. Part 2 detailed recovering tablespaces on “Data” partitions (partitions other than catalog partition).

Continue reading

DB2 DPF Tablespace Recovery Scenarios — Part 2 — Recover Tablespace(s) on Data Partitions

In this blog post, I will share how to recover tablespaces that are on database partitions other than the catalog partition. This blog post is 2nd out of 3 parts. The topic is “DB2 DPF Tablespace Recovery Scenarios”. Part 1 covered recovering tablespaces on the Catalog Partition.

Continue reading

DB2 DPF Tablespace Recovery Scenarios — Part 1 — Recover Tablespace(s) on Coordinator Node

In this blog post I am going to share with you about something exciting that I recently worked on. You don’t get a chance to work on recovering database objects very often and that too in a DPF environment.. !! I will walk you through the scenario of recovering these tables in a series of blog posts. This is part 1 (out of 3 I assume) of such series.. This time we will only cover recovering tables that are on Coordinator Node.

Continue reading