Hi all

While I am taking ontape backup on the Informix server, It gives the following error & the backup is aborted.

I/O function read mm, pagenum nn, pagecnt aa --> errno = 5

This error I am also getting in the online.log file.

I know its OS I/O read error during an attempt to read data.

All my Chunks are UP.

Can any one suggest what need to be done?


Many Thanks!!!


Regards
ska.

Hi,

Please run:
oncheck -cD databasename or generate list oncheck -cD database:table >table.log.
Idem with oncheck -cI...

Gustavo

I have seen cleaning the tape drive take care of this problem

Hi all,

I checked oncheck -cD gave the following error at end and came out.

---
Could not bfget pagenum nnn, iserrno 0
---

Thanks in advance.

Regards,
ska.

Hi Ska,

Please, run from dbaccess:
unload to /dev/null
select rowid from TABLE (of error)
Next look last rowid, then unload to text file select * from TABLE
where rowid <= (last rowid good).
Next test select * from TABLE where rowid > last rowid + 256, until not of the error.
Netx recreate table and load data from test file.

Gustavo.

Hi Gustavo,

There is no rowid for this table because this is a fragmented table and was created without explicitly specifying "with rowid".


Best Regards,
Ska.