Re: How to drop a down dbspace?

I found the answer... I was able to bring the dbspace online with the -O option, then I could drop it... $ onspaces -s slctemp -p tmpdbspace/slctemp_DATA.000 -o 0 -O Steve -- Ignorance can be cured! scooper@thecompounders.com Steven L Cooper <scooper@thecompounders.com> wrote in article <01bca98b$42ee6800$7abf6dce@scooper>... > I am trying to remove a dbspace that is down. Is this possible? > I have included the output from onstat and onspaces below... > > Any help/hints would be great! > Thanks, > Steve > > $ onstat -d> > INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 10:31:57 -- 8936 Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > 104360e8 1 1 1 1 N informix rootdbs > 10436400 2 1 2 1 N informix pccatest > 10436468 3 1 3 1 N informix slctemp > 3 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > 10436150 1 1 0 10000 401 PO- > /data1/IFMXDATA/pccat > est/ROOTDBS.000 > 10436258 2 2 0 128000 84205 PO- > /data1/IFMXDATA/pccat > est/pccatest_DATA.000 > 1043632c 3 3 0 64000 63947 PD- > tmpdbspace/slctemp_DA > TA.000 > 3 active, 2047 maximum > > $ > $ onspaces -d slctemp> WARNING: Dropping a DBspace/BLOBspace. > Do you really want to continue? (y/n)y > WARNING! The dbspace you wish to drop has been disabled. There > may be database catalog entries for tables or indices which contain > data in this dbspace. If you complete the drop they will be unusable. > Do you really want to continue? (y/n)y > Cannot drop the DBspace/BLOBspace. > ISAM error: Unexpected internal error > $> > -- > Ignorance can be cured! > scooper@thecompounders.com > > >