Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Jaipur, India
    Posts
    40

    Unanswered: Database Creation Problem - SQL1088W

    Hi,

    I am facing problem with the database creation. Please provide some pointers regarding this, Thanks in advance.

    Following are the details:

    Server Details:
    AIX 5.3 with Maintenance Level 3
    DB2 8.2 Fix Pack 4.2

    Command Details:

    db2=> create database CMDB
    SQL1088W The database was created, but an error occurred while binding the utilities. The utilities are not bound to the database.

    db2=> CATALOG DATABASE CMDB
    SQL6028N Catalog database failed because database "CMDB" was not found in the local database directory.

    db2=> CONNECT TO CMDB
    SQL1013N The database alias name or database name "TEST" could not be found. SQLSTATE=42705

    db2=> LIST DATABASE DIRECTORY
    System Database Directory
    Number of entries in the directory = 3

    Database 1 entry:
    Database alias = EAIDB
    Database name = EAIDB
    Local database directory = /home/mqm
    Database release level = a.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    Database 2 entry:
    Database alias = BKDB
    Database name = BKDB
    Local database directory = /home/mqm
    Database release level = a.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    Database 3 entry:
    Database alias = SAMPLE
    Database name = SAMPLE
    Local database directory = /home/mqm
    Database release level = a.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    On binding the database
    ./db2 bind /home/mqm/sqllib/bnd/@db2cli.lst blocking all grant public

    LINE MESSAGES FOR db2cli.lst
    ------ ------------------------------------------------------------------- SQL0061W The binder is in progress.
    SQL1024N A database connection does not exist.
    SQLSTATE=08003
    SQL0082C An error has occurred which has terminated processing.
    SQL0092N No package was created because of previous errors.
    SQL0091N Binding was ended with "3" errors and "0" warnings.

    Disk Space at the home directory
    # cd /home/mqm
    # df .
    Filesystem 512-blocks Free %Used Iused %Iused Mounted on
    /dev/hd1 262144 47768 82% 1067 16% /home

  2. #2
    Join Date
    Feb 2004
    Location
    Jaipur, India
    Posts
    40
    Hi All,

    The problem has been resolved. Actually there was not enough space in the home directory.

    I have created the database on some other path and it got created.

    create database CMDB on /usr/databases

    Thanks & Regards,
    Amit Kanodia

Posting Permissions

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