Author name: AS400 Decoded

Operations & Admin

IBM i Journal Management: STRJRNOBJ, Journal Receivers, DSPJRN, Remote Journaling, and the QAUDJRN Security Audit Journal on IBM i in 2026

/

Master IBM i journal management in 2026: create journals and journal receivers with CRTJRN, start and end object journaling with STRJRNOBJ and ENDJRNOBJ, manage the receiver chain with CHGJRN, read journal entries with DSPJRN and the DISPLAY_JOURNAL table function, configure remote journaling for high availability, and use the QAUDJRN security audit journal for compliance auditing.

Modernization

AI-Assisted RPG Modernization on IBM i in 2026: CVTRPGSRC, IBM Merlin Converter, LLM Code Explanation, Automated Refactoring, and AI-Generated RPG Tests

/

Modernize fixed-format RPG on IBM i using AI tools in 2026: convert with CVTRPGSRC and IBM Merlin, use LLMs like watsonx Code Assistant and GitHub Copilot to explain and refactor legacy RPG, generate unit tests with AI assistance, and follow the practical workflow from fixed-format to free-format service programs.

Modern Integrations

OAuth 2.0 and JWT Authentication from IBM i: Client Credentials Flow, Bearer Token Management, and Calling OAuth-Protected REST APIs from ILE RPG in 2026

/

Implement OAuth 2.0 authentication from IBM i in 2026: the client credentials flow using HTTPAPI and DB2 HTTP functions, storing and refreshing Bearer tokens, JWT structure and validation, certificate management in the IBM i digital certificate store, and a complete example calling the Salesforce REST API from ILE RPG.

DB2 for i

DB2 for i Query Optimization: Visual Explain in ACS, SQE vs CQE, Index Design, Encoded Vector Indexes, STRDBMON, and Reading the SQL Plan Cache on IBM i in 2026

/

Optimize DB2 for i query performance in 2026: understand SQE vs CQE query engines, use Visual Explain in ACS to analyze query plans, design effective indexes including encoded vector indexes, collect statistics with STRDBMON, and read the SQL plan cache using QSYS2 catalog views to identify and resolve slow queries.

CL Commands

CL Error Handling and Exception Management on IBM i: MONMSG, Escape Messages, Condition Handlers, SNDPGMMSG, and Robust CL Procedure Design in 2026

/

Build robust IBM i CL programs with proper exception handling: IBM i message types, MONMSG command patterns, program message queue management, SNDPGMMSG for custom errors, RCVMSG for capturing messages, condition handlers in CL procedures, DMPJOB for diagnostic dumps, and complete error-handling templates for production CL.

Scroll to Top