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

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