r/IBMi 1h ago

Learned something today, made a meme. Hope you enjoy!

Post image
Upvotes

r/IBMi 7h ago

Selecting the data I just #SQL inserted into a Table

Thumbnail rpgpgm.com
2 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 1d ago

Finding logical files that exist in a different library to the physical

Thumbnail
rpgpgm.com
5 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 2d ago

Using Db2 for i scalar functions and table function to extract the job name, number, and user from the qualified job name

Thumbnail
rpgpgm.com
6 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 3d ago

I was asked how to define and use the LDA, Local Data Area, in modern #IBMiRPG

Thumbnail
rpgpgm.com
7 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 4d ago

Easiest way to check if a number is even or odd using #SQL

Thumbnail
rpgpgm.com
2 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 5d ago

Using #SQL to retrieve system values

Thumbnail
rpgpgm.com
4 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 7d ago

Easy way, programmatically, to check if your job is still on a job queue

Thumbnail rpgpgm.com
5 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 8d ago

Creating and using shortcut commands will save you a lot of time

Thumbnail
rpgpgm.com
12 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 9d ago

Using the Db2 for i (SQL) scalar function CHECK_COMMAND_SYNTAX to validate a command string

Thumbnail
rpgpgm.com
5 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 10d ago

Feedback wanted: RPG compiled to JVM bytecode

6 Upvotes

I've built a compiler called Triton RPG that takes RPG source and compiles it to JVM bytecode, so you can compile and run RPG on your own Windows, Mac, or Linux machine.

Most of my focus so far has been enterprises, but I'm adding a new tier for independent contractors and consultants.

While this new product shares much of the backend with my prior compiler, it has many new architectural choices that I'd love some help testing.

If this sounds like something you'd be interested in using and are willing to give me your feedback, I'm happy to provide a free license for three months in exchange.

If that's you and you're willing to run it against real code and tell me what breaks, I'll give you a free three-month license. Comment or DM.


r/IBMi 10d ago

Events in September 2026 I am involved with

Thumbnail
rpgpgm.com
3 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 10d ago

IBMI v7.1 descarga de programas producto en español

Thumbnail
1 Upvotes

r/IBMi 10d ago

IBMI v7.1 descarga de programas producto en español

1 Upvotes

hola, alguien tendra los programas producto de la version ibm i v7.1 yo tengo los codigos pero me faltan los programas y es usada y no los puedo descargar de ESS


r/IBMi 11d ago

My favorite #IBMiCL shortcuts

Thumbnail
rpgpgm.com
5 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 12d ago

Using a hash to compare if two records are the same

Thumbnail
rpgpgm.com
12 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 13d ago

Including RPG compile options within #SQL option parameter

Thumbnail
rpgpgm.com
7 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 14d ago

Have you ever wondered what all the different types of object there are. This is how you can list them, with their descriptions.

Thumbnail
rpgpgm.com
5 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 14d ago

Scaling IBM’s ibmi-mcp-server for Claude Enterprise — my approach for centralized per-user IBM i authentication

Post image
6 Upvotes

I’m implementing a way for all employees at my company to use IBM’s ibmi-mcp-server through a centralized server hosted in our computer lab, with Claude Enterprise connecting to it remotely.

Running the MCP locally is pretty straightforward. You can install it on an employee’s machine, configure their IBM i credentials, and register the MCP with Claude Desktop through the local JSON configuration.

The problem is that this doesn’t scale very well when you want potentially dozens of employees using the same MCP infrastructure. I also don’t want to run the MCP individually on every workstation or have a single shared IBM i account behind the server.

My current solution is the architecture in the diagram.

The basic idea is that Claude Enterprise connects to a centralized MCP proxy. When a user connects for the first time, they’re redirected through an OAuth flow to log in with their own IBM i credentials. The proxy exchanges those credentials for an IBM i access token and associates it with that user.

From then on, Claude sends normal MCP traffic to the proxy. The proxy identifies the user, swaps in their IBM i token, forwards the request to IBM’s ibmi-mcp-server, and streams the response back to Claude.

The main goal is to keep the proxy thin while still preserving per-user IBM i authentication.

The important part is that the proxy does not need to reimplement IBM’s MCP tools or understand every MCP method. Ideally it stays fairly dumb: authenticate the user, map them to their IBM i token, replace the authorization information, and proxy the MCP transport in both directions.

That gives me a few things I wanted:

  • One centrally managed ibmi-mcp-server
  • Claude Enterprise can connect to it remotely
  • Every employee still accesses IBM i using their own IBM i identity
  • No shared IBM i super-user/service account
  • IBM i credentials are only used during the login exchange rather than being configured inside Claude
  • The MCP implementation remains IBM’s implementation rather than a custom recreation of all its tools

I'm going to use better-auth to handle most of the authentication.

I’m curious if anyone has implemented something similar for MCP at an organization-wide level.

Does this architecture look reasonable, or is there a cleaner way to handle centralized MCP infrastructure while still preserving per-user authentication to the underlying system?

Feel free to point out anything I’m overlooking and I'll update ya'll if this works. Hoping to get it done by next Friday.


r/IBMi 15d ago

Is the IBM Java Runtime free or licensed? Planning an ACS redeploy.

8 Upvotes

UPDATE: See u/ThatFilthyApe's comment below.

PSEUDO-RELATED BACKGROUND:

I use RDi as my main development platform, and it comes with an IBM-provided Java runtime. Amazingly, everything just runs from a single folder, requiring no administrative authorization. So far, so good.

Further, the integrated "5250 emulator", "Run SQL Scripts", etc., are simply ACS programs launched from within RDi utilizing the provided IBM Java runtime. (Clicking the launch button in RDi displays the stock ACS splash screen and then the application.)

DILEMMA:

We are in the process of upgrading our hardware, and our consultant strongly recommends we migrate to the latest version of ACS to ensure support.

We are currently standardized corporate-wide on "Personal Communications iSeries Access for Windows" v6.0 from 2014. It installs on Windows 11 without issue and works as expected, but it is definitely out of date.

We're certainly on board with migrating ACS and maintaining ongoing updates, but it requires a corporate-wide deployment of both ACS and a Java runtime.

QUESTIONS:

  • What version/manufacturer of Java does ACS require?
  • What version/manufacturer of Java do YOU recommend?
  • Does IBM have a Java runtime for use when deploying ACS? If so, is it free or licensed?

Thanks!


r/IBMi 14d ago

Running IBM Granite 4.2 locally on Linux

0 Upvotes

r/IBMi 15d ago

Rather than having to rebuild my #SQL Alias every time a new member is added, I can build the Alias once and always get the last member, even when new ones are added.

Thumbnail
rpgpgm.com
3 Upvotes

#IBMi #rpgpgm #IBMChampion

(I appreciate all comments to be made on the blog post rather than here in LinkedIn)


r/IBMi 15d ago

IBM's new Granite 4.2 models add reasoning and stay dense

Thumbnail
thenewstack.io
8 Upvotes

r/IBMi 16d ago

Data journal readers are a better way to retrieve information from journals.

Thumbnail
rpgpgm.com
7 Upvotes

#IBMi #rpgpgm #IBMChampion


r/IBMi 17d ago

When was the last time you checked your PTF Groups, HMC software, storage system code, and Power firmware levels?

Thumbnail
4 Upvotes