dbschema fails
Hi all,
I have a 7.3 installation on Linux and we are getting ready to
upgrade to 9.4. This week we tried running a dbschema to ready our test
server and it failed reporting an ISAM failure. Further diagnostics with
oncheck and we found out that a few temporary tables that were created over
the last few months were placed on a damaged tablespace. I think the server
in question probably has a hard drive failing. Since these tables are not
part of our main applications nobody ever noticed anything was wrong. The
problem is that we need to create a dbschema of the remaining tables and it
looks like this won't be possible.
Is there a way to make dbschema jump a few tables? I was
thinking that maybe we could delete them from systables. I tried dropping
the tables but since the tablespace is damaged it refuses to drop the
tables.
Thanks,
Sandro
select "dbschema -d db -t " || tabname
from systables
where tabname not in ("x","y"..);
output that to a file and run it as a shell command
or
http://www.iiug.org/software/index_all.html#U
and get utils_ak2
and use myschema from it.
Use myschema from it with
----- Original Message -----
From: "Sandro Giometti" <sandro@linkexpress.com.br>
To: <ids@iiug.org>
Sent: Sunday, June 13, 2004 1:58 AM
Subject: dbschema fails [3113]
> Hi all,
>
>
>
> I have a 7.3 installation on Linux and we are getting ready to
> upgrade to 9.4. This week we tried running a dbschema to ready our test
> server and it failed reporting an ISAM failure. Further diagnostics with
> oncheck and we found out that a few temporary tables that were created
over
> the last few months were placed on a damaged tablespace. I think the
server
> in question probably has a hard drive failing. Since these tables are
not
> part of our main applications nobody ever noticed anything was wrong. The
> problem is that we need to create a dbschema of the remaining tables and
it
> looks like this won't be possible.
>
>
>
> Is there a way to make dbschema jump a few tables? I was
> thinking that maybe we could delete them from systables. I tried dropping
> the tables but since the tablespace is damaged it refuses to drop the
> tables.
>
>
>
> Thanks,
>
> Sandro
>
>
>