Category: Recovery

804b26eba5cc743127edb24221f259aa 1

Avoiding Inoperative Tables on the HADR Standby

HADR does an awesome job of replicating all logged operations to 1-3 standby databases. It is remarkably simple to use and pretty resilient. More than once I’ve started talking to a client about PureScale only to discover their actual high availability and/or disaster recovery needs can easily be met by a 4-server HADR implementation. Sometimes even by a two-server implementation....

file000956896813 2

Backup Performance Investigation

While I have tuned backup performance before, it has often been through physical database changes (spreading tables across more table spaces) that I achieve my greatest results. This post is not about backup performance tuning, but about solving a specific backup duration mystery. The Problem A database that is about 330 GB backs up to Data Domain using a vendor...

804b26eba5cc743127edb24221f259aa 2

SQL0752N on Rollforward After Redirected Restore

I’d like to think that I’m pretty decent at backup and recovery. I’ve done hundreds of restores in my career in a vast array of scenarios for real-world recovery, data movement, and fixing developers’ mistakes. Today I saw an error I’ve never seen before, so I thought I’d share. The Scenario This restore was grabbing an older backup image from...

file000956896813 2

Using Vendor Backup Solutions with DB2 for LUW

There are an astonishing number of vendor solutions available with specific interfaces for DB2. Working with a variety of clients, I see and help to evaluate and implement a variety of backup solutions. I thought I’d share some of the things I look for and work on as part of an implementation. Sometimes the DBA has input on a solution...

1

Going Beyond 2 Servers – HADR as a High Availability/Disaster Recovery option.

When the client considers high availability and disaster recovery, they often do not know what they are talking about. Many times the client may be dropping buzzwords like “five nines”. To them this is the definition of disaster recovery. In other cases, they are thinking of a worst-case scenario where a whole data center falls off the face of the...

file000956896813 3

Archiving Transaction Logs to a Vendor Solution

I have worked with three different vendors for backup solutions for various clients in the last few months, and several others over the course of my career. When either making archive log decisions or evaluating vendors, it is important to know the DB2 details behind what is going on Why Archive Transaction Logs at All? First and foremost, archive logging...

file9791234819983 4

DB2 Backups When Using Native Encryption

I’ve recently implemented native encryption for a small database on a server that is somewhat oversized on CPU and memory. One of the things I noticed after encrypting my database was both increased backup duration and increased backup size. Backup Size On this particular system, I take compressed DB2 backups to disk, which is later externalized. Immediately after enabling Native...

file000956896813 5

Speeding up DB2 Backups

It’s a question I hear frequently – How can I speed up backups? I thought I’d share some details on doing so. Database Layout Any backup cannot be faster than it takes to back up the largest tablespace. Parallelism is essentially done on the tablespace level – meaning one thread per tablespace. That means that if you have the majority...