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

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

The Most Misunderstood Features of DB2

From Craig Mullins: The Most Misunderstood Features of DB2:

Part 1: Locking
Part 2: Optimize vs. Limited Fetch
Part 3: Nulls
Part 4: Base Table Views
Part 5: Choosing the Clustering Key
Part 6: Not Indexing
Part 7: It Depends!
Part 8: Do I Have to Pick Just One?

Understanding the Complexity of Time Travel

Another article about temporal tables and DB2, from Dan Luksetich.

Understanding the Complexity of Time Travel

System-Time Temporal versus Archive Tables

Two related blog articles from Robert Catterall on DB2 System-Time Temporal and Archive tables on DB2 z/OS:

Part 1: DB2 for z/OS-Managed Archiving, or System-Time Temporal?
Part 2: Thoughts on History and Archive Tables

Understanding DB2 LUW Error Messages

A nice article about DB2 LUW error messages.

Understanding DB2 LUW Error Messages