Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.

    Posted 22 days ago

    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
    ------------------------------


  • 2.  RE: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.

    Posted 22 days ago

    Rerun the db2sampl command until it executes cleanly.



    ------------------------------
    Jan Nelken
    Db2 (LUW) DBA
    HCLTech
    Katowice or Krakow
    +48 783 109 863
    ------------------------------



  • 3.  RE: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.

    Posted 22 days ago

    It worked on the third attempt. Thank you Jan.



    ------------------------------
    Vijay Kumar Mudduluru
    ------------------------------



  • 4.  RE: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.

    Posted 21 days ago

    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
    ------------------------------



  • 5.  RE: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.

    Posted 21 days ago
    Edited by Jan Nelken 21 days ago

    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
    ------------------------------



  • 6.  RE: db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.

    Posted 21 days ago

    Hello Jan,

    The standard support disclaimer also applies to Ubuntu 24.04 LTS :-)

    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.

    $ db2level
    DB21085I  This instance or install (instance name, where applicable: 
    "db2inst1") uses "64" bits and DB2 code release "SQL12012" with level 
    identifier "02030110".
    Informational tokens are "DB2 v12.1.2.0", "s2505201240", "DYN2505201240AMD64", 
    and Fix Pack "0".
    Product is installed at "/opt/ibm/db2/V12.1".

    $ 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

    Regards



    ------------------------------
    Yves-Antoine Emmanuelli
    ------------------------------