deleting table from dropped dbspace
Informix: 9.40FC3
O/S: HPUX 11.11
We had a need to restore 2 tables that had all data deleted so we
attempted a ontape -r -D dbspacename. However, after 13 hours, it never
completed (or errored out) so we just cut our losses and dropped and
recreated the tables (only had ~8 tables in it and we had unloads of
most of them) in another dbspace and the dbspace was dropped and
recreated. As it turns out, there was one table that didn't get dropped
and recreated and now it is not letting me drop it and I can't update
statistics now either as it gives 2 errors: 215 "cannot open file for
table" and 135 "ISAM error: TBLSpace does not exist".
How do I drop this table so I can recreate it in another dbspace?
Thanks,
Randy
You have to rollforward your trx log when restoreing using ontape -r
-D...
see manual. this will bring you back where you were when the tables had
all
data deleted!!!!!!!!!!! if you do not rollforward your logs then your
dbspace
will be inconsistent. do it again and rollforward your logs to get out
of this mess.
eq make sure that your dbspace is consistent.
to get data back you can use archecker to do a table level restore.
have a look in the manual howto.
Superboer.
BTW search for table level restore, there was a howto recently
Kennedy, Randy schreef:
> Informix: 9.40FC3
> O/S: HPUX 11.11
>
> We had a need to restore 2 tables that had all data deleted so we
> attempted a ontape -r -D dbspacename. However, after 13 hours, it never
> completed (or errored out) so we just cut our losses and dropped and
> recreated the tables (only had ~8 tables in it and we had unloads of
> most of them) in another dbspace and the dbspace was dropped and
> recreated. As it turns out, there was one table that didn't get dropped
> and recreated and now it is not letting me drop it and I can't update
> statistics now either as it gives 2 errors: 215 "cannot open file for
> table" and 135 "ISAM error: TBLSpace does not exist".
>
> How do I drop this table so I can recreate it in another dbspace?
>
> Thanks,
> Randy
>
>
> ------_=_NextPart_001_01C71D32.B3BE918A
> Content-Type: text/html
> Content-Transfer-Encoding: quoted-printable
> X-Google-AttachSize: 1803
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=Content-Type content="text/html; charset=us-ascii">
> <META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
> <BODY>
> <DIV><SPAN class=808273614-11122006><FONT face=Tahoma size=2>Informix:
> 9.40FC3</FONT></SPAN></DIV>
> <DIV><SPAN class=808273614-11122006><FONT face=Tahoma size=2>O/S: HPUX
> 11.11</FONT></SPAN></DIV>
> <DIV><SPAN class=808273614-11122006><FONT face=Tahoma
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=808273614-11122006><FONT face=Tahoma size=2>We had a need to
> restore 2 tables that had all data deleted so we attempted a ontape -r -D
> dbspacename. However, after 13 hours, it never completed (or errored out)
> so we just cut our losses and dropped and recreated the tables (only had ~8
> tables in it and we had unloads of most of them) in another dbspace and the
> dbspace was dropped and recreated. As it turns out, there was one table
> that didn't get dropped and recreated and now it is not letting me drop it and I
> can't update statistics now either as it gives 2 errors: 215 "cannot open file
> for table" and 135 "ISAM error: TBLSpace does not exist".</FONT></SPAN></DIV>
> <DIV><SPAN class=808273614-11122006><FONT face=Tahoma
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=808273614-11122006><FONT face=Tahoma size=2>How do I drop this
> table so I can recreate it in another dbspace?</FONT></SPAN></DIV>
> <DIV><SPAN class=808273614-11122006></SPAN> </DIV>
> <DIV><FONT face="Comic Sans MS" size=2><STRONG>Thanks,</STRONG></FONT></DIV>
> <DIV><FONT face="Comic Sans MS" size=2><STRONG>Randy</STRONG></FONT></DIV>
> <DIV> </DIV></BODY></HTML>
>
> ------_=_NextPart_001_01C71D32.B3BE918A--