Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2004
    Posts
    268

    Unanswered: TOOLSDB Problem URGENT !!!!!

    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the output for "LIST DB DIRECTORY"?

    Andy

  3. #3
    Join Date
    Oct 2004
    Posts
    268
    4 user databases (no TOOLSDB)

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  5. #5
    Join Date
    Oct 2004
    Posts
    268
    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.

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  7. #7
    Join Date
    Oct 2004
    Posts
    268
    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

  8. #8
    Join Date
    Oct 2004
    Posts
    268
    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.

  9. #9
    Join Date
    Oct 2004
    Posts
    268
    Thanks for your help.............After that I applied to the above IBM link and it worked..............

Posting Permissions

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