Db2 Checklist – SQLCODEs as never seen before

From the December 2018 Segus Db2 newsletter:

Db2 Checklist: SQLCODEs as never seen before

Db2 Timestamps, Java, and Daylight Savings Time

The June 2018 Segus Db2 newsletter discusses an issue with Db2 timestamps, Java drivers, and daylight savings time:

DST Db2 timestamp problems: I really hate Daylight Saving Time

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