Finding the indexes the system suggests
Db2 for i records which indexes it would have wanted: you only have to ask.
Articles tagged #db2 — 5 results
Converting a CYYMMDD date in SQL
Turning the seven-digit format into a real date with a single expression.
Reading a spooled file with SQL
Querying the contents of a spooled file without copying it into a physical file first.
Understanding journals and how to use them
The journal records every change to your data, with the time and the name of who made it. It exists for recovery, but day to day it mostly answers one question: who changed this record?
Optimizing SQL Queries on DB2 for i
When a query slows down, the cause is almost always a missing index or a condition written in a way the database cannot use. Here is how to find out instead of guessing.