Author: Ember Crooks

3

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 18

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

Screenshot_072215_080015_PM 6

Calculating PVUs for IBM DB2 on Linux

DBAs do not have to calculate PVUs(Processor Value Units) often. Many times there is a system administrator or someone else who might do this for us. Or if you’re buying everything from IBM, then they’re likely to calculate it. You may also easily be able to get the information you need from your hardware vendor and skip right to the...

1

Analyzing Package Cache Size

Note: updated 7/21 to reflect location of the package cache high water mark in the MON_GET* table functions I have long been a fan of a smaller package cache size, particularly for transaction processing databases. I have seen STMM choose a very large size for the package cache, and this presents several problems: Memory used for the package cache might...

6

Architecting High-Availability and Disaster Recovery Solutions with DB2

NOTE: Please do not attempt to architect a high-availability solution without a DB2 expert involved. There are many questions and answers needed beyond those here to make the best decision and ask all the tough questions. High Availability vs. Disaster Recovery High Availability and Disaster Recovery often have different goals and priorities. High Availability can be considered the ability to...