Re: Where is dbspace?

Julio Cesar de Figueiredo wrote: > > On a raw disk(instance product) I created a database test. > On other instance(training) on the same raw disk and fisical area > other database with thehe same name was created. > I deleted the second database and dbspace but on the first instance > I can't access, drop the database test or delete the instance. > Where I want drop database test, Informix say: > > 311: Cannot open system catalog (systables). > 135: ISAM error: tblspace does not exist> > What I can do to drop this database/dbspace? COme back from an archive tape. By creating a second instance on the same physical area as the first, you hosed the first instance. Somehow the root dbspace was spared; or it looks legitimate enough that the engine does not know it has been overwritten by another instance. Then enroll in the Informix DSA System Administration class. The money spent on the class is made up for by admins not making that mistake. -- -- Jake (In pursuit of undomesticated aquatic avians) +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+