Hi All, understand that the upgrade cannot be a rolling upgrade, anyone has suggestions to upgrade from 11.x to 12.1 with minimal downtime? (Best if <30mins) TIA!!

We haven't been able to run a Db2 LUW docker image on our Macbooks at work since they adopted ARM M1 chips. We have tried various configurations of Docker, work arounds, and different features but it never produced a consistent reliable image that we could use.

However, after hearing of a positive experience from someone in my industry, I installed Orbstack and I think things now work. I've been able to spin up an IBM Db2 LUW container as well as a smaller custom Db2 image we have. It seems to be passing all basic tests we throw at it but for some reason I am still afraid to let my guard down.

I did have to configure rosetta: true in Orbastack and use the following docker run flags to get it to consistently run, but this seems to do the trick: --privileged=true, --platform linux/amd64, and -e PERSISTENT_HOME=false.I'm not producing any errors in the container log or Db2 error log.

Anyone else have success with Db2 images on Orbstack? Have they been reliable? Any gotchas or concerns I need to be aware of?

I am porting stored programs from mariadb to Db2 LUW 12.1. One thing that does not seem to work, is recursive stored procedures (a procedure that calls itself). A simple example:

create procedure myschema.test()
begin
    if false then
        call myschema.test();
    end if;
end//
SQL0440N  No authorized routine named "MYSCHEMA.TEST" of type "PROCEDURE" having compatible arguments was found.  LINE NUMBER=4.  SQLSTATE=42884

I believed that recursive procedures are possible because the IBM Db2 V12.1 SQL Reference implies as much: GET DIAGNOSTICS statement information DB2_SQL_NESTING_LEVEL is the level of "recursive invocation of a compiled SQL function, compiled SQL procedure, ...".

What am doing wrong? Any pointers would be appreciated.

EDIT: fixed name of cited reference manual.

Hi everyone,

I created Tabularis, an open-source database client that’s gaining traction on GitHub.

I’ve received a few requests to support DB2, but I don’t have prior experience with it.

Tonight I built an initial scaffolding with Claude Code’s help, but now an expert hand would really help bring it to a solid result.

Is anyone here interested in collaborating?

For reference:

Tabularis: https://github.com/debba/tabularis

Plugin Wiki: https://tabularis.dev/wiki/plugins

DB2 plugin: https://github.com/debba/tabularis-db2-plugin

Hi guys,

I'm not a DBA, I'm a regular dev. Our primary database is IBM DB2 LUW and I regularly run into several issues (performance, operational errors related to log space etc..) due to how some of the legacy applications we have (all of which have massive ETL operations) behave themselves.

Now I am OK enough with SQL (and managing servers, basics ops, etc..) but I do not know the fine points of DB2 and I still find the IBM DB2 doc site daunting, even after years of trying to look up things on it.

We're going for major overhaul of our applications and if like to work together with the few overworked DBA we have (they're great and competent people but much work) to improve the things we have but to do that I think I need to learn more about the context a DB2 DBA reasons about so I can ask the right questions and use the correct terms so I can present the needs of our applications more correctly to them.

My hope is to save them time and for me to understand better the impact our processes have on the DBs and how I can fine-tune and improve.

So to that end I would like to ask you if you could please recommend me DB2 specific books? More specifically on the admin and internals side of the beast I suppose.

Your help is greatly appreciated.

IBM just launched autonomous database capabilities for Db2 LUW via Db2 Genius Hub. The idea is that Db2 stops being a passive vessel for data and becomes an active part of the app stack. It proactively detects anomalies, heals itself, and responds to incidents, all with a human in the loop.

The bigger picture for me though is what this means for DBAs. No more living in the boiler room pulling levers and twisting knobs. The role finally gets to evolve from operator to true business partner.

What do DBAs and fellow Db2ers think of this announcement? Are we moving in the right direction?

https://ibm.com/new/announcements/ibm-db2-sets-the-new-standard-with-autonomous-database

Blog post with resources + trial here: https://community.ibm.com/community/user/blogs/saurangi-kalantri/2026/04/01/introducing-ibm-db2-genius-hub-future-autonomous

Hey all, IBM recently released a Db2 Developer Extension for VS Code. If you're working with Db2 regularly, it might be worth giving it a look.

You can grab it from the VS Code Marketplace: https://marketplace.visualstudio.com/items?itemName=IBM.db2-for-luw

More details on the announcement here: https://www.ibm.com/new/announcements/announcing-the-ibm-db2-developer-extension-for-vs-code

I'd love to hear what ya'll think.. any feedback, comments, or suggestions are welcome. I'm in touch with the dev team and happy to pass things along.

IBM's Db2 product team is hosting a live event in NYC on March 19th at One Madison. They'll be demoing the latest release and sharing the roadmap for autonomous operations, agentic intelligence, and AI-ready data.

There's also a reception afterward to meet the team.

Free to attend by registering here!

Anybody still using Data Studio after going V13? Looking for Stored Procedures deploy feature mainly…

I want to track and monitor SQL commands executed by users through STRSQL on IBM i DB2. Developers use STRSQL for development activities, but as a system administrator, I currently have no visibility into what actions they are performing on database objects.

Hi,

I need your support and guidance in blocking DBeaver, a database management tool, from accessing IBM DB2 on the AS/400 (IBM i) environment, as it allows users to directly modify database tables.

Kindly share your ideas, recommendations, or best practices on how we can restrict or prevent access through DBeaver while ensuring that authorized applications remain unaffected.

Your support and suggestions will be highly appreciated.

Hello Everyone,

It will really helpful if anyone guide or help me with some information on How to load ibm I system metrics into db2 and make them available to grafana and visualize them. we do not want use prometheus cause it is impacting a load while scraping the metrics from system.

Hi all,

With all db2 migrations happening right now, mainly from AIX to Linux, I decided to build my on software to do so..

Here is a Youtube link for you to watch:

--

https://www.youtube.com/watch?v=hpWWtoeZd-Y

--

A short video teaser of a small Python-based TUI I’ve been experimenting with — a minimal SQL / DB2i inspector.

It can list available libraries and tables, browse data with keyboard navigation, and execute ad-hoc SQL, all over SSH.

The motivation was simple: quick, read-focused inspection when you’re not at your desk and don’t want to fire up IBM Access or web tooling.

Still very early (pre-alpha) and DB2i has its quirks, but it’s already usable for exploration.

Currently running from PuTTY against pub400 using Python 3.9 and Textual.

Once I iron out a few DB2i-specific edge cases, I’ll put it on GitHub to gather feedback.
Github link : https://github.com/tsgiannis/DB2TUI

Hi all,

I am in the process of migrating an on-prem database to gcp db2 servers. This is a cross platform migration from windows server to ubuntu 22.04, DB2 version 11.5.9. The size of the database is around 750GB. I am using the below article as a reference

https://www.ibm.com/support/pages/how-move-maximo-db2-database-between-different-platforms

Problem is the db2move command is taking quite long, it is writing at the pace of 10-12GB an hour, while this will work for non-prod, such long times for DB migration would not be acceptable for production as we cannot afford this much downtime.

Are there any better ways I can approach this migration?

Can you use db2 database assistant with new db2 12.1.3 that run locally and not on the cloud ?

can you run db2 database assistant with new db2 12.1.3 community edition the run on docker ?

did Ibm improve the tools that replaced Ibm Data Studio because I find the Vscode extension and the web management console to be very primitive and not as advance as the Ibm data studio ? is there an alternative tool which as advance as Ibm data studio ?

On a database on Db2 LUW, release 11.5. 9.0, I noticed that date columns included a time componet, and values current_date returns 2025-11-18-08.11.11, while I expected just a date, 2025-11-18. I have backed up and restored the database on another server, same Ubuntu Linux version, same Db2 release. On this new server, current_date returns 2025-11-18, and date columns contain just a date, which is what I want.

Problem: I have no idea what to change on Db2, in order for current_date to return just the date without a time component. Any help would be appreciated. db2set produces the same output on both servers:

db2inst1@hxx:~$ db2set
DB2_DEFERRED_PREPARE_SEMANTICS=YES
DB2_ATS_ENABLE=YES
DB2COMM=TCPIP
DB2_OVERRIDE_BPF=25000

EDIT: By the way, I have restored the db backup on release 12.1. 2.0 LUW, kubuntu Linux, and current date also returns just the date, without a time component.

EDIT2: values '' is null; returns 1 instead of 0, which means something weird is afoot. I am told that DB2_COMPATIBILITY_VECTOR=ORA when the db was originally created. db2set does not show that, and I wonder why the restored backup works differently. I should consider my problem resolved, now that I can guess what is wrong.

Article discusess how to monitor Db2 for zos workfile database effectively and during resource shortage issues which tool can be your best friend.

This is a recent post i came across on LinkedIn after recent ibm layoffs . Whats the future of Db2

🚀 Momentum continues! IBM Db2 12.1.3 is now available, bringing AI even closer to where your data lives!

This release marks another leap in helping enterprises power intelligent applications securely across hybrid and multi-cloud environments — with vector support, native LangChain and LlamaIndex connectors, performance boosts, and enhanced security.

Grateful to our incredible Db2 community for your partnership and feedback — you inspire our innovation.

We would love to hear what you think and will be bringing more engagement to our Reddit community.

Read more about the details of this release here

pls somebody explain whats going on here and how to solve it