• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Autodesk GIS Design Server

    Reply
    *Mena, Antoni

    Database deletion

    99 Views, 1 Replies
    09-26-2002 09:48 PM
    I'm trying to delete an AGDS database using dbm_delete.exe tool.
    After entering the database name and password, I get the next error:
    "Cannot get exclusive access to database ...".
    I have ensured that there is no user connected to the system and the
    message still appears.

    What is happening? What or who can be using the database?
    What is dbm_delete exactly trying to do?

    I would like to say that the databases are LTC enabled, for if it helps.
    This problem only happens with some databases, since I have deleted
    others without any problems.

    Some suggestion?

    Thank-you,

    Antoni Mena.
    Please use plain text.
    *Mena, Antoni

    Re: Database deletion

    09-26-2002 10:04 PM in reply to: *Mena, Antoni
    Found!

    There is an utility that allows to close all connections to a specific
    database: dbm_close.exe.
    All the databases that I was not able to delete had many stored locks.

    Does anybody know what can have left that locks in the database, even
    when the user has closed the session?
    Some client hangs?
    If this is common, I think that a database should be "closed"
    periodically in order to delete obsolete locks.
    Am I wrong?

    Thank-you again,

    Antoni Mena.


    "Antoni Mena" escribió en el mensaje
    news:E4C4BFB7F9915BC7C261B4060F1437C6@in.WebX.maYIadrTaRb...
    > I'm trying to delete an AGDS database using dbm_delete.exe tool.
    > After entering the database name and password, I get the next error:
    > "Cannot get exclusive access to database ...".
    > I have ensured that there is no user connected to the system and the
    > message still appears.
    >
    > What is happening? What or who can be using the database?
    > What is dbm_delete exactly trying to do?
    >
    > I would like to say that the databases are LTC enabled, for if it
    helps.
    > This problem only happens with some databases, since I have deleted
    > others without any problems.
    >
    > Some suggestion?
    >
    > Thank-you,
    >
    > Antoni Mena.
    >
    >
    >
    Please use plain text.