Category: Guest Blogs

log-file-saturation 7

Preventing Log Saturation

A few days ago, I was involved in a conversation on Twitter with Ember and Erwin Hattingh, a DB2 DBA from the Netherlands whom I met at IDUG in Dublin last November. Ember expressed her surprise at how well DB2 handled a nasty situation: It's not every day #DB2 blows your mind with the ability to stay up in a...

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

Abhik 2

DB2 Workload Manager (WLM) as a Monitoring Solution– Analyzing WLM Information (Part 3 of 3)

This is part three of a three part series. The full series includes: DB2 Workload Manager (WLM) as a Monitoring Solution – Understanding WLM (Part1 of 3) DB2 Workload Manager (WLM) as a Monitoring Solution– How to Set up WLM (Part 2 of 3) DB2 Workload Manager (WLM) as a Monitoring Solution– Analyzing WLM Information (Part 3 of 3) The...

IanB 2

Keeping EXPLAIN under control

Have you ever looked at a list of tables in your database, only to see the set of EXPLAIN tables present in two, five or even 10 different developers’ schemas? I don’t know about you, but this drives me crazy. Very few of the developers that I know pay attention to these tables, and many of them are not even...

5

Options to Encrypt Data at Rest in DB2

I thought it would be relatively easy to investigate encryption for our environment. I was wrong, was just plain confusing. This was not because encryption is complicated per se, but that a DBA really needs to have a good understanding of business needs. If you don’t have this understanding, you can get lost in an array of options. Are you...

13

Quick Hit Tips – CPUSPEED, RESTRICTIVE, and DB2_WORKLOAD

Today we are going to talk about some random DB2 features that can’t stand in a blog of their own, but are worth discussing nonetheless. These are tidbits I had discovered during “DB2’s Got Talent” presentations, IDUG conferences, or “Hey, look what I discovered” moments. CPUSPEED (Database Management Configuration) You blow past this setting every time you execute “db2 get...