Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2005
    Posts
    2

    Unanswered: Need Help With: The container is already in use. SQLSTATE=42730

    Hi everybody,

    I have reinstalled DB2 7.2 Rev 5 (Win2000 EE) on my local machine after deleting all the catalog directories. However, when I go to create a new database using the wizard, I'm getting:

    The container is already in use. SQLSTATE=42730

    How do I clear this error so I can continue with creating the new database?

    Thanks in Advance!!

    Bob Hitchins

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    db2 has drop database to remove the database and all its catalog.
    Check where are you creating a container and the database_path.
    If another database is using that container , then db2 will not allow you to
    create the database.

    As a last resort use db2untag command, but I strongly recommend
    consult IBM before doing anything like that.

    regards

    Mujeeb

  3. #3
    Join Date
    Sep 2004
    Posts
    111
    Once you uncataloged the databases, Did you cleaned up or removed the catalog directories manually. Some time db2 does not clean up the catalog directories.

    Thanks,
    Raj

  4. #4
    Join Date
    Sep 2004
    Posts
    111
    I mean database directories.

    Thanks,
    Raj

  5. #5
    Join Date
    Feb 2005
    Posts
    2
    Quote Originally Posted by udbraja
    Once you uncataloged the databases, Did you cleaned up or removed the catalog directories manually. Some time db2 does not clean up the catalog directories.

    Thanks,
    Raj
    I haven't added any databases to uncatalog. I un-installed DB2 from my local machine, deleted the catalog directories (C:\DB2, C:\DB2CLTSV, C:\DB2LOG) and then reinstalled DB2. When I go to create a new database, that is when I get the container error.

    Thanks for your response!
    Bob

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You probably still have stuff under /sqllib that's left from your previous installation. Deinstall DB2, remove what you call "catalog directories", also find and remove a directory called "SQLLIB" (it's either in the root or under "Program Files"; use file search if you have difficulties locating it), then reinstall DB2.

    Next time you do it don't forget to drop all databases before deinstalling DB2.

Posting Permissions

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