Screenshot_091415_065147_PM 3

Ongoing Support of DB2’s HADR

There are some things to be aware of with ongoing support of a HADR system. I thought I’d group them together to provide a primer of do’s and don’ts for support of HADR. Monitoring HADR HADR does occasionally stop all by itself. Also, system events can cause it to not be active. For these reasons, it is critical that you...

file9791234819983 1

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 3

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...

Pavan 2

Automatic Bufferpools in DB2 HADR

In this blog post, I will share what I learned about DB2 automatic bufferpools when using HADR. Problem: In a DB2 10.5 (fp3a) HADR environment, during heightened database activity on the primary database, there was delayed log replay on principal standby database. The HADR_SYNCMODE was set to SYNC. Primary and Standby database servers were in the same data center. HADR_SYNCMODE...

1

Issues with STMM

I thought I’d share some issues with STMM that I’ve seen on Linux lately. I’ve mostly been a fan of STMM, and I still am for small environments that are largely transaction processing and have only one instance on a server. Here are the details of this environment. The database is a small analytics environment. It used to be a...

file9791234819983 16

Using DB2’s New Native Encryption Feature

With fixpack 5 of DB2 10.5, IBM introduced Native Encryption for data at rest in DB2. This is a fairly significant new feature for introduction in a fixpack. It does require separate licensing – either the Advanced Edition of ESE or WSE or the separate purchase of the Native Encryption feature. DB2 Native Encryption is transparent data encryption for data...

2

Installing a Local Copy of the IBM DB2 10.5 Documentation

I have written about this before for version 9.7. The IBM DB2 Knowledge Center can be a bit unreliable – sometimes the search doesn’t return the obvious results. Sometimes it’s down entirely at the worst time. And for consultants, sometimes we work on networks that will not allow us to get out to the IBM Knowledge Center. To mitigate, this,...

shell1 5

PowerShell for DB2 DBAs – Part 1

Any DBAs faced with having to administer and maintain a large number of instances and databases will quickly find themselves swamped with work unless they learn to script most of their workload.  Of course, the benefits of scripting do not end there.  This post is intended to be the first of a planned series with a goal to show how PowerShell...