Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2014
    Location
    India
    Posts
    18

    Unanswered: Error SQL0204N during create database

    Hi,

    While executing create database <dbname> following error was encountered:

    SQL0204N "SYSIBMADM.DBMS_LOB" is an undefined name. LINE NUMBER=1 SQLSTATE=42704

    DB2 version: V10.1 Fix Pack: 0 on Linux

    Any clues?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Install FixPack 3. If that does not work, please copy and paste the exact command you issued, and the exact error message, into your follow-up response.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2014
    Location
    India
    Posts
    18
    Marcus, Thanks for the suggestion. Will install FP3.

    More information about above error,

    Command issued was:

    db2 "create database <dbname>"

    Error thrown was:
    SQL0204N "SYSIBMADM.DBMS_LOB" is an undefined name. LINE NUMBER=1 SQLSTATE=42704

    db2diag contains following errors:

    2014-02-10-10.41.00.781000+000 I21456E645 LEVEL: Severe
    PID : 5000 TID : 889999999928389 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : TEST
    APPHDL : 0-34 APPID: *LOCAL.db2inst1.889898112405
    AUTHID : DB2INST1 HOSTNAME: testhost
    EDUID : 50 EDUNAME: db2agent (TEST) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
    MESSAGE : DB2SPCAT_SYSMODULES: sqlerrmc
    DATA #1 : Hexdump, 18 bytes
    0x00007F46717F94E2 : 5359 5349 424D 4144 4D2E 4442 4D53 5F4C SYSIBMADM.DBMS_L
    0x00007F46717F94F2 : 4F42 OB

    2014-02-10-10.41.00.781718+000 I40956E9350 LEVEL: Severe
    PID : 5000 TID : 889999999928389 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : TEST
    APPHDL : 0-34 APPID: *LOCAL.db2inst1.889898112405
    AUTHID : DB2INST1 HOSTNAME: testhost
    EDUID : 50 EDUNAME: db2agent (TEST) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
    MESSAGE : DB2SPCAT_SYSROUTINES:
    DATA #1 : Hexdump, 66 bytes
    0x00007F4664211DA0 : 414C 5445 5220 4D4F 4455 4C45 2053 5953 ALTER MODULE SYS
    0x00007F4664211DB0 : 4942 4D41 444D 2E44 424D 535F 4C4F 4220 IBMADM.DBMS_LOB
    0x00007F4664211DC0 : 5055 424C 4953 4820 434F 4E44 4954 494F PUBLISH CONDITIO
    0x00007F4664211DD0 : 4E20 4E4F 5052 4956 5F44 4952 4543 544F N NOPRIV_DIRECTO
    0x00007F4664211DE0 : 5259 RY

    2014-02-10-10.00.00.781740+000 I28689E897 LEVEL: Severe
    PID : 10223 TID : 140391369135904 PROC : db2bp
    INSTANCE: db2inst1 NODE : 000
    APPID : *LOCAL.db2inst1.889898112405
    HOSTNAME: testhost
    FUNCTION: DB2 UDB, base sys utilities, sqlescdb, probe:179
    MESSAGE : ZRC=0xFFFFFF34=-204
    SQL0204N "" is an undefined name.

  4. #4
    Join Date
    Feb 2014
    Location
    India
    Posts
    18
    Oh, Missed the copy and paste. Command is in a shell script which is executed.

    shell contains command:

    db2 create database $2

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by SBA View Post
    SQL0204N "" is an undefined name.
    Looks like there may be an error or missing value in your shell script and the variable is null.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Feb 2014
    Location
    India
    Posts
    18
    Hi Marcus,

    Not really. The parameters are passed correctly and as per the db2diag logs, it starts creating the DB but fails at ALTER statement (check log entry2 in my above comment for db2diag.log). This alter statement is fired by DB2 implicitly and not present in the shell script.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •