Regarding installation, I always use db2_install/db2icrt instead of db2setup : may be that is why I did not see the obscure Java message ?
db2prereqcheck complained about ksh not found so I installed mksh package prior to installation.
Original Message:
Sent: Wed July 09, 2025 03:57 PM
From: Jan Nelken
Subject: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.
Hi!
Standard support person disclaimer: Db2 V12.1+ does not support Ubuntu 25.04 :-)
Did you get during installation this obscure message:
JVMJ9VM011W Unable to load j9jit29: /root/db2.tmp.4253/db2/linuxamd64/java/jre/lib/default/libj9jit29.so: cannot enable executable stack as shared object requires: Invalid argument
Setup completes OK:
db2inst1@VMUbuntu2504:~$ db2level
DB21085I This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL12013" with level
identifier "02040110".
Informational tokens are "DB2 v12.1.3.0", "s2506201610", "DYN2506201610AMD64",
and Fix Pack "0".
Product is installed at "/opt/ibm/db2/V12.1".
Db2sampl executes correctly:
db2inst1@VMUbuntu2504:~$ db2sampl -dbpath /Db2DB
Starting the DB2 instance...
Creating database "SAMPLE" on path "/Db2DB"...
Connecting to database "SAMPLE"...
Creating tables and data in schema "DB2INST1"...
Creating tables with XML columns and XML data in schema "DB2INST1"...
Creating tables with VECTOR columns and VECTOR data in schema "DB2INST1"...
Stopping the DB2 instance...
'db2sampl' processing complete.
My Ubuntu is:
db2inst1@VMUbuntu2504:~$ cat /etc/os-release
PRETTY_NAME="Ubuntu 25.04"
NAME="Ubuntu"
VERSION_ID="25.04"
VERSION="25.04 (Plucky Puffin)"
VERSION_CODENAME=plucky
ID=ubuntu
ID_LIKE=debian
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
UBUNTU_CODENAME=plucky
LOGO=ubuntu-logo
------------------------------
Jan Nelken
Db2 (LUW) DBA
HCLTech
Katowice or Krakow
+48 783 109 863
Original Message:
Sent: Wed July 09, 2025 11:57 AM
From: Yves-Antoine Emmanuelli
Subject: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.
Hello,
I did not encounter this issue on a fresh install of Db2 12.1.2.0 on up to date Ubuntu 25.04.
Regards.
------------------------------
Yves-Antoine Emmanuelli
Original Message:
Sent: Tue July 08, 2025 07:32 PM
From: Vijay Kumar Mudduluru
Subject: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.
It worked on the third attempt. Thank you Jan.
------------------------------
Vijay Kumar Mudduluru
Original Message:
Sent: Tue July 08, 2025 12:30 PM
From: Jan Nelken
Subject: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.
Rerun the db2sampl command until it executes cleanly.
------------------------------
Jan Nelken
Db2 (LUW) DBA
HCLTech
Katowice or Krakow
+48 783 109 863
Original Message:
Sent: Mon July 07, 2025 09:14 PM
From: Vijay Kumar Mudduluru
Subject: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.
I installed db2 v12.1.2.0 community edition on Ubuntu 24.04.2 LTS
db2sampl command fails as follows:
db2sampl
Creating database "SAMPLE"...
Attempt to create the database "SAMPLE" failed.
SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name. LINE NUMBER=1.
SQLSTATE=42704
'db2sampl' processing complete.
How to resolve this error? Is this an issue db2sampl script?
------------------------------
Vijay Kumar Mudduluru
------------------------------