Author name: AS400 Decoded

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.

Operations & Admin

IBM i High Availability and Disaster Recovery in 2026: Geographic Mirroring, Switchable ASPs, and HA Tools Compared

IBM i high availability and disaster recovery in 2026 requires understanding the full stack: geographic mirroring at the storage layer, switchable Independent Auxiliary Storage Pools for role swaps, and journal-based logical replication for granular data protection. This post compares the major IBM i HA architectures and leading third-party tools — MIMIX, iTera, and PowerHA SystemMirror for i — explaining how to align your RTO and RPO targets with the right replication strategy. You will learn how IASPs enable a production disk pool to be varied off one system and varied on another, how geographic mirroring keeps a remote copy synchronised at the hardware level, and how journals underpin every logical replication product on the platform. Practical CL command examples cover VRYCFG, STRGEOMRR, DSPGEOMRR, CHGJRN, and the steps needed to execute and test a planned switchover.

Modern Integrations

Python on IBM i in 2026: Running Python in PASE, Accessing DB2 for i, Calling IBM i Programs with itoolkit, and AI Integration

Python runs natively on IBM i in PASE with direct DB2 access via ibm_db and pyodbc, IBM i program calls via itoolkit-for-i, and access to the full Python AI ecosystem. This post covers installing Python via yum, querying DB2 for i with ibm_db_dbi, loading IBM i data into pandas DataFrames, calling CL commands and RPG programs with itoolkit, extracting IBM i data to AWS S3 with boto3, batch AI classification with the OpenAI Python library, watsonx.ai integration, running Python from CL, and when to use Python versus Node.js versus RPG.

Operations & Admin

Advanced ILE RPG in 2026: System Pointers, IBM i OS APIs, Dynamic Program Calls, and User Spaces

The IBM i OS API layer accessible from ILE RPG: QCMDEXC for running CL commands at runtime, the list API pattern using user spaces (QUSCRTUS, QUSLOBJ, QUSRTVUS), listing objects in a library at runtime, dynamic program calls using variable names and procedure pointers, system pointers and the capability-based OS model, and QUSROBJD for checking object existence without triggering an error message.

IFS & File Systems

IBM i IFS Advanced in 2026: Journalling Stream Files, NetServer SMB Shares, IFS Backup, Large Files, and CCSID Encoding

Advanced IBM i IFS topics for production environments: enabling journalling on IFS directories for recovery and replication, sharing IFS directories as Windows network drives through NetServer, NFS exports for Linux clients, saving and restoring IFS data with SAV/RST, large file support for files over 1GB, and CCSID encoding management — why CCSID 1208 (UTF-8) matters, how to set it, and the CCSID 65535 trap that breaks modern tooling.

Scroll to Top