Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2004
    Posts
    5

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

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

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

    Gustavo

  3. #3
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    I have seen cleaning the tape drive take care of this problem

  4. #4
    Join Date
    Aug 2004
    Posts
    5
    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.

  5. #5
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

  6. #6
    Join Date
    Aug 2004
    Posts
    5
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •