Linux 3.1 DB2 V8.1 FP10

I have removed the TOOLSDB without dropping the tools catalog and now I am having problems.

If I run "db2 drop tools catalog systools in database toolsdb" I get,
SQL1013N The database alias name or database name "" could not be found.

If I run "db2 create tools catalog systools create new database TOOLSDB" I get,
SQL1005N The database alias "TOOLSDB" already exists in either the local
database directory or system database directory.

If I run, "db2 drop database TOOLSDB" I get,
SQL1013N The database alias name or database name "TOOLSDB " could not be found. SQLSTATE=42705

I have tried

http://www-1.ibm.com/support/docview...en&rss=ct71db2

It did not help. Now I am thinking to delete the TOOLSDB database files from /home/db2inst1/db2inst1/NODE0000/.................but I don't know which directory/files would be belong to TOOLSDB.

It looks like we have 4 database but 5 SQL0000X directory. Can someone please help ?

Thanks.

What is the output for "LIST DB DIRECTORY"?

Andy

4 user databases (no TOOLSDB)

You say that you are 5 DB directories. What happens if you run "catalog db toolsdb on <path> authentication server" where path is that 5th directory?

Andy

Ok. I ran "db2 catalog db toolsdb" and now I can see the database. I don't know which SQL0000X directory is belong to which database. I tried to create a task but I get a

"DBA1177N A database connection to the Tools Catalog Database cannot be made. SQLCODE"-1390"


Where do I go from here ?


Thanks.

The "LIST DB DIRECTORY" should have given you which directory belonged to which DB. Can you post the ENTIRE output from this? What is the entire path of each of the 5 SQL0000X directories?

Andy

list db directory gives:

Database 3 entry:

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


Complete path is: /home/db2inst1/db2inst1/NODE0000/SQL0000X

The directory that belongs to TOOLSDB is /home/db2inst1/db2inst1/NODE0000/SQL00001/

Database alias = TOOLSDB
Database name = TOOLSDB
Database directory = SQL00001
Database release level = a.00
Comment =
Directory entry type = Home
Catalog database partition number = 0
Database partition number = 0




when I run,
"db2 catalog db TOOLSDB on /home/db2inst1/db2inst1/NODE0000/SQL00001/ authentication server"

I get,
SQL6028N Catalog database failed because database "TOOLSDB" was not found in the local database directory.

Thanks for your help.............After that I applied to the above IBM link and it worked..............