Author: Ember Crooks

2018-01-19 08.53.17 2

Db2 Basics: Investigating Permissions in an Existing Database

Edit: 01/23/2018 – corrected one word not in an SQL statement. I have written several other articles on security and permissions, but I thought I would write one from a purely practical perspective. If you don’t understand the basics of how DB2 handles users, authentication, authorization, and privileges, please read Db2 Basics: Users, Authentication, and Authorization. The Easiest Method Back...

HADR 11

High Availability Options for Db2 LUW

Why Should a Database be Highly Available? It is significantly easier to implement high availability at other levels than it is at the database level. Often the database server is one of the more powerful servers in an environment, and without some fancy footwork there can be only one live copy of data. Ignoring high availability at the database level...

SQL1643C 1

SQL1643C on Rollforward

I ran into this error message recently and thought I’d describe what the issue was. The Scenario I was building a new consolidated development database server for a client – moving away from 10 separate database servers to one (big) VM to run their development workloads. This was a Linux server, so I was setting INSTANCE_MEMORY to prevent any one...

DatabaseMemory 0

The Self-Tuning Memory Manager (STMM)

Edited 12/13/2017 to correct image and details about the database heap. Db2 memory management is a complex topic that I’ve already written about from several perspectives, and have a few blog entries in mind to explore further. A presentation that Melanie Stopfer gave a while back really helped me understand STMM better. I thought I would share what I learned....

804b26eba5cc743127edb24221f259aa 9

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

open-badge-logo 0

IBM Badges

You may have seen some people posting IBM badges (through Acclaim) that they’ve earned. These are now conferred along with some IBM Certifications, but there are more that you can earn. Unofficial Badge Types You can access and search a list of all possible badges through the IBM Skills Gateway. There are a number of different types of badges. Several...

file000956896813 3

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