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
Back to discussions
Expand all | Collapse all

db2sampl fails with SQL0204N "SYSIBMADM.DBMS_SQL" is an undefined name.

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

    Posted 2 hours 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
    ------------------------------