Hi Neil.

Sorry. if I can not tell you what I want to do...

First figure out what table and page is currupt.
oncheck -pe, oncheck -pP or oncheck -pp.

Then figure out rowid of table on corrupt page.

unload to <TAPE DEVIDE, if possbile> select * from corrupt table where
rowid not in (.......)

unload other table to tape device.

Regards.

--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592





>From: "Neil Truby" <neil.truby@ardenta.com>
>Reply-To: "Neil Truby" <neil.truby@ardenta.com>
>To: informix-list@iiug.org
>Subject: Corruption in old and unsupported v7 database ...
>Date: Mon, 16 Aug 2004 20:33:25 +0100
>
>My customer is on 7.2x on HP-UX 10.20.
>Informix support patched one of his chinks better a couple of months ago.
>Now (and probably then) he is getting page errors:
>
>Noticed assert failure af.5008e6dc which advised oncheck -cDI 8394250
>Dropped index tfgld1061001abaan
>Ran create unique index "baan".tfgld1061001abaanon "baan".ttfgld106100
>(hash1)
>Process halted with 25580:System erroroccurred in network function, invalid
>arguement
>Ran oncheck cDI 8394250 - It reported bad page, pg-stamp 155ccd15 !=
>PG_STAMP2 0
>Ran onckeck -cD 8394250 - It reported bad page 33a155f: pg_stamp 358403349
>!= PG_STAMP2 0
>
>He's keen to try and do an ASCII unload, but I think it will fail with the
>same thing. I'd like to get a copy of his database to work on, but we have
>no HP-UX 10.20 servers. He doesn't have enough disk space to
>onunlaod/onload the file to that server.
>
>Any other ideas for helping him out? IBM tech Support won;t touch it - the
>version is too old.
>
>thanks
>Neil
>
>

__________________________________________________ _______________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

sending to informix-list