Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Unanswered: Oncheck -cd ->result error

    When I run "oncheck -cd d:t" because I have possible inconsistencies where d=database and t=tablename I obtain a kinky error:

    informix@mangl>oncheck -cd tt_o:nom_up
    TBLspace data check for tt_o:tandt.nom_up
    ERROR:Count of version 1 data pages 455 != pnv_pages 457ERROR: Data page count 4
    My version of Informix is 7.30UC10.
    Thanks for your help !
    Last edited by obaxe28; 06-09-06 at 05:18.

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

    Please run:
    unload to you_file
    select ROWID,* from you_table
    When error ocurre, look last ROWID, then run xx=ROWID+256
    unload you_file2
    select ROWID,* from you_tables
    where ROWID > xx
    Next recreate you_table and load rows.

    good luck.

    Gustavo.

  3. #3
    Join Date
    Jun 2006
    Posts
    2
    Thanks a lot for your answer !

Posting Permissions

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