I would like to understand the mechanism of "How data is written to the IRIS Database and in what sequence data is written to Journal, WIJ and IRIS database"

How to execute a stored procedure in a remote DB2 database?

Hi Everyone,

I want to access a stored procedure in a remote DB2 database. The stored procedure in question is linked and receives a numeric value, returning a cursor with N number of rows. Sometimes the number of rows reaches hundreds of thousands, so I need to apply pagination.

I've been reading about the %ScrollableResultSet library, but it doesn't allow me to call a stored procedure.

Here's part of the code:
Set pValor=12345678
Set callSql="CALL Paquete.ClaseSpRemoto(?)"
Set rs=##class(%ScrollableResultSet).

Hi Community,

We're super excited to share that we’ve just launched a new free, interactive tutorial designed especially for those who are new to InterSystems IRIS and looking for a clear, practical introduction to its core concepts.

🧑‍🏫 Data Models of InterSystems IRIS 🧑‍💻

Welcome to the monthly recap of updates and releases to VS Code and InterSystems-related extensions relevant to IRIS developers. 

If you're migrating from InterSystems Studio to VS Code, or want to deepen your knowledge check out the VS Code training courses from George James Software: georgejames.com/vscode-training.

VS Code version 1.110
Kitty graphics protocol in the Terminal - The integrated terminal now supports the Kitty graphics protocol, allowing for high-fidelity image rendering directly in the terminal pane.

Hey Community!

Have you attended one of the Global Summits or a previous READY 2025? We’d love your help to inspire others to join InterSystems READY 2026!

We’re inviting community members to record a short video (less than 1 minute) answering one or more of these questions:

• What did you find most valuable about attending?
• What surprised you?
• Why should others join READY 2026?
• Who would benefit most from attending?

Your authentic perspective helps future attendees understand the real impact of these events, beyond the agenda.

Hi,
I'm pretty sure I'm not the first one to encounter this, so please share your solution
I'm trying to load a package with 2 dependencies, one of them has 5 dependencies..
is there a better tool / script / wizard for that?
 

IPM version 0.10.6 was released on February 24th, 2026. This version is mostly bug fixes, but does add the -export-python-deps flag to the package and publish  commands to include Python dependencies with the IPM module itself. As usual, you can check it out on the GitHub page or through the Community Registry. 

Here's the complete changelog:

Added

• #1024: Added flag -export-python-deps to publish command

Fixed

• #996: Ensure COS commands execute in exec under a dedicated, isolated context
• #1002: When listing configured repositories, only show the TokenAuthMethod when a token is defined.

Hi, Community!

Working with large volumes of data? See how streams can help:

Storing Large Amounts of Data with Streams in ObjectScript 

Hi everyone,

I am trying to configure a FHIR Server to authenticate against an external OAuth server using the OAuth FHIR Client Quickstart, which is available in the newer versions of InterSystems IRIS for Health.

During the configuration process I am encountering an issuer validation error.

I have already verified the issuer URL, and it exactly matches the value returned by the OAuth server’s OpenID configuration endpoint (.well-known/openid-configuration).

Example:

Issuer configured in IRIS
https://login.microsoftonline.com/{tenant-id}/v2.0

Issuer returned by the OpenID configuration
https://login.

We have an HL7 feed that contains Lab Results. Each message contains a set of results, identified by a LabReportId. Some LabReportIds can get more than one message / set of results - these are updates, as new results become available, and must be processed in order. Results for different LabReportIds can be processed in any order.

As each message is used to build a PDF, which takes time, we want to run these through a production where the key business process has a Pool Size > 1, while still ensuring that messages for each LabReportId are processed in order.

I had configured the environment as follows:

OS: Redhat Linux 9.4

IRIS 2025.2 installed on local directory

IRIS Database: One LVM is created with 20 Storage luns and the LVM is mounted on a mount point. IRIS database is created on that

Primary and Alternate Journal: One LVM is created with 5 Storage luns and the LVM is mounted on a mount point. IRIS database is created on that.

WIJ: One LVM is created with 5 Storage luns and the LVM is mounted on a mount point. IRIS database is created on that.

So Data, WIJ and Journal is mounted on 3 separate mount point.

Anyone up for a round of golf?

Are you fed up of making a machine write code for you? Do you miss thinking through problems yourself? Then you are in luck, this round, I propose adding the rule of no AI use. obviously its a game of honor with no prize, so I shan't be enforcing this, but you'll know... 

Challenge:

Create a function which takes a string as a parameter, and returns the length of thelongest sequence of alternating consonants and vowels. The sequence is broken by having two vowels or two consonants in a

I am currently managing environments running InterSystems IRIS and Caché on Windows servers.

I’m reviewing storage optimization best practices and I have a question regarding a specific Windows drive setting: "Allow files on this drive to have contents indexed in addition to file properties."

Based on my research, everything indicates that it is better to disable this option, especially on drives used by databases. However, I couldn't find a specific "official" stance in the documentation explicitly mentioning this checkbox.

Why This Integration Matters

InterSystems continues to push AI capabilities forward natively in IRIS — vector search, MCP support, and Agentic AI capabilities. That roadmap is important, and there is no intention of stepping back from it.

But the AI landscape is also evolving in a way that makes ecosystem integration increasingly essential. Tools like Dify — an open-source, production-grade LLM orchestration platform — have become a serious part of enterprise AI stacks.

Hi, Community!

Are you attending InterSystems READY 2026? While you're there, show off your expertise in InterSystems technology:

🤩 Take a certification exam—for free!

Hear more about the experience from members of the InterSystems certified community:

Get Certified at InterSystems READY

I have installed IRIS community edition on a local directory in Redhat Linux 9.4.

Created a 10G database on a separate mount point directory  which comes out of a storage volume of 50G.

Also placed Journal and WIJ on 2 separate mount point directories  which comes out of two different storage volume of 50G each.

I want to take a snapshot and recover the snapshot on a secondary host and check the consistency of the database. 

As Storage snapshot will be taken, only Data, Journal and WIJ file placed on Storage volumes will be snapshotted.

Is there any Cache setting that needs to be checked while configuring IRIS Community Edition 2025.2 and does it impact WIJ recovery.

Also I have kept Database, WIJ and JOURNAL on the same snapshot group with Consistency . Is it the recommended settings? Am I getting the WIJ mismatch error due to this setting?

Hi Community,

Let's meet at the online meetup with the winners of the InterSystems Full Stack Contest! It's a great opportunity to chat with the InterSystems expert team and our contestants. Winners' demo included!

Date & Time: Thursday, March 5, 11:00 am EST | 5:00 pm CET

Join us to learn more about winners' applications and to speak with our experts.

➡️ REGISTER TODAY

See you all at our virtual meetup!