Tuesday, June 14, 2016

Migrating a DB2 LUW Database From Big Endian to Little Endian

This article from Roger Sanders describes the differences between "big endian" and "little endian", and how to migrate a DB2 LUW database to an environment with a different endianness.

Migrating a DB2 database from a Big Endian environment to a Little Endian environment

DB2 z/OS Buffer Pool Thresholds Overview

An overview of some buffer pool tuning threshold parameters that can be tuned for DB2 z/OS, from Craig Mullins:

Four Important Buffer Pool Tuning Knobs in DB2 for z/OS

Wednesday, June 1, 2016

Effectively Using the "LIKE" Predicate in SQL

Here's a good article by Craig Mullins on effectively using the "LIKE" predicate in your SQL statements.

Carefully Code Your DB2 LIKE Predicates