Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    PUNE - INDIA
    Posts
    7

    Unanswered: Not table to Delete Database

    Hello,

    We have created 3 database on our server.
    While doing test migration from IDS 7.31 to IDS 2000 Version 9.21 one of database got problem.
    We are able to complete migration.

    Since problematic database is not important so we want do drop that database.

    Now if we try to delete that database system give following error.

    211: Cannot read system catalog (systables).
    103: ISAM error: illegal key descriptor (too many parts or too long).

    If we try to execute any oncheck command then following error occurred.

    $pwd
    /userhome/informix
    $
    $ oncheck -pt baanpdm5
    ISAM error: TBLspace does not exist

    $

    If we try to drop dbspace then following error occurred

    $ onspaces -d pdmdbs
    WARNING: Dropping a DBspace.
    Do you really want to continue? (y/n)y
    Cannot drop the Space.
    ISAM error: DBspace is not empty
    $
    $

    IS THERE ANY SUGGESTIONS FOR HOW TO DELETE THIS DATABASE

    Thanks
    Shekhar

  2. #2
    Join Date
    Jan 2003
    Posts
    30

    Corrupt db

    Hmm,

    Your db is corrupt.

    You can delete the row for that db from the sysmaster:sysdatabases table.
    This will allow you to recreate the db. (not supported)

    But then you won't release all the space taken by the initial db.

    Best is to dbexport all the db's you want to keep.

    Reinitialize the instance and load the db's again.

    best regards
    Koen

Posting Permissions

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