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.… Read the rest

Continue reading »

Reducing Contention: Changing Default Isolation Level for Websphere Commerce (WCS)

Krafick

The Problem

I often lean on analogies when I speak to non-technical people about technical topics. For example, I would explain database locking as “two kids fighting for the same candy bar”.  If you introduce isolation levels into the conversation, I would expand the analogy to include “one sibling holding on to a candy bar they care nothing about just because they don’t want the other sibling getting to it”.… Read the rest

Continue reading »

Establishing a DB2 JDBC Connection

KrafickRecently I was forced outside my comfort zone and asked to vet various open source BI tools. I was a report developer in a past life, a database administrator supporting datamarts at various employers, and even supported Cognos backend databases. I thought my past experience gave me an edge when it came to evaluating BI tools.… Read the rest

Continue reading »

Query Performance Analysis

Some of the more complicated work a DBA does is often analyzing a query. Whether it is proactive or in response to a performance problem, there are so many factors that go into query performance. Even when looking at a query that has a performance problem, there is only occasionally a single, obvious cause for all of the problems.… Read the rest

Continue reading »