If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Oncheck -cd ->result error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-09-06, 04:15
obaxe28 obaxe28 is offline
Registered User
 
Join Date: Jun 2006
Posts: 2
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 04:18.
Reply With Quote
  #2 (permalink)  
Old 06-12-06, 09:33
gurey gurey is offline
Registered User
 
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.
Reply With Quote
  #3 (permalink)  
Old 06-13-06, 19:20
obaxe28 obaxe28 is offline
Registered User
 
Join Date: Jun 2006
Posts: 2
Thanks a lot for your answer !
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On