Author name: AS400 Decoded

DB2 for i

DB2 for i Triggers in 2026: SQL and External Triggers, BEFORE and AFTER Timing, Audit Logging, and Calling RPG from a Trigger

DB2 for i triggers fire automatically on INSERT, UPDATE, and DELETE, enforcing rules that application code cannot bypass. This post covers SQL and external trigger types, BEFORE and AFTER timing, transition variables, writing audit tables, calling RPG programs from external triggers using ADDPFTRG, and practical audit and validation patterns.

DB2 for i

Vector Search and Embeddings on IBM i in 2026: Storing Vectors in DB2 for i, Cosine Similarity in SQL, and Semantic Search over IBM i Data

Vector search and text embeddings bring semantic search to IBM i in 2026 — converting DB2 for i text fields into float arrays via OpenAI or watsonx.ai, storing vectors as VARBINARY or JSON in DB2, computing cosine similarity in SQL, and building RAG pipelines that ground LLM answers in real IBM i business data. This post covers the full embedding pipeline from generation to retrieval.

DB2 for i

DB2 for i Replication in 2026: Journal-Based CDC, Q-Replication, MIMIX, and Designing a Replication Strategy

DB2 for i replication in 2026 is built on IBM i journals — the same journal receivers that underpin HA tools and Kafka CDC also power Q-Replication and MIMIX. This post explains journal-based logical replication, the Q-Replication Capture and Apply architecture, what MIMIX adds for HA and DR, and how to design a replication strategy that matches your latency targets and data distribution needs.

Modern Integrations

IBM i and Apache Kafka in 2026: Journal-Based CDC to Kafka Topics, PASE Producers, and Event-Driven IBM i Integration

A hands-on guide to connecting IBM i with Apache Kafka in 2026 — running kafkajs and confluent-kafka-python producers in PASE, journal-based change data capture using QSYS2.DISPLAY_JOURNAL, Kafka Connect via IBM MQ bridge, consuming Kafka messages to write back into DB2 for i, and practical event-driven architecture patterns for IBM i integration.

Operations & Admin

IBM i PTF Management and OS Upgrades in 2026: Ordering Cumulative PTFs, Managing SF99xxx Groups, and Planning an OS Upgrade

IBM i PTF management in 2026 spans four distinct fix types — individual PTFs, cumulative PTF packages, SF99xxx group PTFs, and Technology Refreshes — each with its own ordering, application, and scheduling discipline. This post explains how to check what is currently installed with DSPPTF and WRKPTF, which SF99xxx groups matter most (DB2, Java, open source, security, HTTP, and TCP/IP), how to order fixes via SNDPTFORD and IBM Fix Central, and how to apply them safely using APYPTF and APYGRPPF with an understanding of IPL-required PTFs and hold/release mechanics. The post also covers using IMGCLG image catalogues to load cumulative packages without physical media, and walks through the order of operations for planning a full IBM i OS version upgrade — from CHKPRDOPT and licence checks through GO LICPGM and the upgrade IPL itself.

Scroll to Top