Solved

Problem with Database Creation in DB2

Posted on 2007-04-04
4
2,529 Views
Last Modified: 2013-11-17
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
0
Comment
Question by:amitkanodia
  • 2
4 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 18856235
what happens if you try to create the CMDB database again ?
does db2 says it's already exists
0
 
LVL 45

Accepted Solution

by:
Kdo earned 50 total points
ID: 18857152
Hi amitkanodia,

This looks suspiciously like a space problem.

All three of your databases appear to exist in the default tablespace, which is in the /home directory.

The df command shows that /home contains 262144 blocks of 512 bytes.  That's 131MB, not GB.  And it's 82% used leaving about 24MB.  (You've probably got more than 131MB of RAM on the box and certainly have more than 24MB!)

Try creating the database again, this time on another device.

CREATE DATABASE CMDB on path {new location}

e.g.
CREATE DATABASE CMDB on path /usr/databases
CREATE DATABASE CMDB on path /tmp/test
etc.


Good Luck,
Kent
0
 

Author Comment

by:amitkanodia
ID: 18857424
Hi kdo,

Thanks a lot for your help. I am able to create the database on different path.
i.e.
create database CMDB on /usr/databases
in the command specified by you "path" is not the part of the syntax. It is the variable that needed to replace with the actual path.

Once again thanks for the help.
Regards,
Amit Kanodia

0
 
LVL 45

Expert Comment

by:Kdo
ID: 18857454

Glad to help.....

Kent
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now