Results 1 to 6 of 6
  1. #1
    Join Date
    May 2002
    Location
    santa ana
    Posts
    6

    Unanswered: SQL1005N The database alias "test" already exists in either the local database

    I've tried to create a database on C drive and get error
    /************************************************** *******

    SQL1005N The database alias "test" already exists in either the local database directory or the system database
    directory.
    /************************************************** ****
    I did "uncatalog database test" but it still doesn't work.
    Any advices for me?

    Thanks,

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: SQL1005N The database alias "test" already exists in either the local database

    Looks like there is a database 'test' in C drive which is not cataloged in the system database directory ...

    If you want to catalog the exisiting database then

    db2 catalog database test on C:

    If you want to create a new one, catalog the database using the above command, drop it and then issue the create database command.

    Hope this helps.

    Cheers

    Sathyaram

    Originally posted by emtga
    I've tried to create a database on C drive and get error
    /************************************************** *******

    SQL1005N The database alias "test" already exists in either the local database directory or the system database
    directory.
    /************************************************** ****
    I did "uncatalog database test" but it still doesn't work.
    Any advices for me?

    Thanks,

  3. #3
    Join Date
    Apr 2009
    Posts
    1

    thank you sathyaram_s

    I ran into the same problem and your suggestion worked, thank you!

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You probably have an old, uncataloged database named "test" in your file system at the default location. So you should catalog the database. Then you can drop it if you don't need the old one.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Oct 2010
    Posts
    1

    Thumbs up Thanks!

    Many Thanks, your suggestion helped me too :-)

    Manish

    IBM ISL

  6. #6
    Join Date
    Oct 2012
    Posts
    1
    Hi

    Please follow the below steps and see whether its working : (on Windows)

    1. db2 list db directory on c:

    Database alias = SAMPLE
    Database name = SAMPLE
    Database directory = SQL00002
    Database release level = d.00
    Comment =
    Directory entry type = Home
    Catalog database partition number = 0
    Database partition number = 0

    In your case it is Test.. and if it is present there

    Go to this path >>> C:\DB2\NODE0000

    and find SQL00002

    Please delete this and try to create again ...

Posting Permissions

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