Db2 LUW technical articles
A practical set of articles for Db2 LUW administrators and developers.
Browse the category cards below to open the current Db2 LUW reads and any future additions in this area.
Back to training articles
Articles in this category
AI-assisted recovery of a dropped Db2 table
A scenario showing how an AI agent backed by Db2 MCP servers investigated a dropped table incident, switched first to business-logic reconstruction, and later recovered the original rows after the MCP tooling improved.
Fundamental Db2 HADR concepts
A hands-on lab that builds a Db2 12.1.4 HADR pair with primary and standby containers, explains the central HADR concepts, and validates the basic behavior without failover automation.
Db2 LUW VECTOR datatype in practice
A hands-on lab that creates VECTOR columns, loads sample embeddings, and runs similarity search with SQL in Db2 LUW.
Granular schema-level authorities in Db2 11.5.5
How the new schema authorities in Db2 11.5.5 let you implement the Principle of Least Privilege without resorting to DBADM or SECADM.
Db2 11.5 token-based authentication in practice
A hands-on Db2 LUW lab that configures token authentication with a local issuer, db2token.cfg, CLP, and JDBC examples.
Db2 TLS in practice with ADMIN_GET_TLS_CERT
A practical guide to Db2 TLS that explains the key settings, shows what ADMIN_GET_TLS_CERT reveals, and finishes with a reproducible Docker-based lab.
Using JSON output in db2diag
A hands-on Db2 LUW lab that uses `db2diag -json` and `jq` to inspect lock timeout and deadlock diagnostics in a structured way.
Creating a simple MCP server to interact with a Db2 database
A hands-on tutorial for building a simple MCP server that connects Claude Code to Db2 LUW for schema discovery, SQL generation, and EXPLAIN.
Hands-on lab for table and index compression in Db2
A hands-on lab on how to estimate, enable, and validate data compression for row-organized tables and their indexes in Db2.