In the brown sticky stuff:-))

I've got table I can't read right through, the oncheck -cDI reports WARNING: index check requires a s-lock on tables whose lock level is page. Validating indexes for drug:viagra.order... WARNING: index check requires a s-lock on tables whose lock level is page. TBLspace data check for drug:viagra.order ERROR:Version 1 on page 72 (0x700947) is out of range ERROR:Version 1 on page 73 (0x700948) is out of range ERROR:Version 1 on page 74 (0x700949) is out of range ERROR:Version 1 on page 75 (0x70094a) is out of range ERROR:Version 1 on page 76 (0x70094b) is out of range ERROR:Version 1 on page 77 (0x70094c) is out of range ERROR:Version 1 on page 78 (0x70094d) is out of range ERROR:Version 1 on page 79 (0x70094e) is out of range ERROR:Version 1 on page 80 (0x70094f) is out of range and the log give me 21:31:27 Informix Dynamic Server 2000 Version 9.20.UC2 21:31:27 Who: Session(98, informix@hobbit, 18721, 296254552) Thread(1271, xchg_3.0, 11a5dd58, 1) File: rssupp.c Line:2658 21:31:27 Results: altering older version row to latest versionfailed 21:31:27 stack trace for pid 281 written to /var/tmp/af.8dfce1f 21:31:27 See Also: /var/tmp/af.8dfce1f 21:31:43 Assert Failed: read_record: decompress_row, source = 12797018,target = 12725018 21:31:43 Informix Dynamic Server 2000 Version 9.20.UC2 21:31:43 Who: Session(98, informix@hobbit, 18721, 296254552) Thread(1271, xchg_3.0, 11a5dd58, 1) File: rsread.c Line:2507 21:31:43 Results: Record notread 21:31:43 Action: Please notify Informix Technical Support. 21:31:43 stack trace for pid 281 written to /var/tmp/af.8dfce1f 21:31:43 See Also: /var/tmp/af.8dfce1f 21:32:06 read_record: invalid rowid = 4801, partnum =700068 ITS is shut, so the question is there anything I can do or do I have to wait, I can't unload the table 'cos of the above

Was the server upgraded from 7.3x? 'Cause it looks to me like there were in-place-alter rows which had not been updated to the newest version before the upgrade. IB this is specifically recommended against. Informix always says to force all tables which have been altered to complete with: UPDATE tablename SET acol = acol;before attempting to upgrade to a newer release. Art S. Kagel Paul Watson wrote: > > I've got table I can't read right through, the oncheck -cDI reports > > > WARNING: index check requires a s-lock on tables whose lock level is > page. > > Validating indexes for > drug:viagra.order... > > WARNING: index check requires a s-lock on tables whose lock level is > page. > > TBLspace data check for > drug:viagra.order > > ERROR:Version 1 on page 72 (0x700947) is out of > range > ERROR:Version 1 on page 73 (0x700948) is out of > range > ERROR:Version 1 on page 74 (0x700949) is out of > range > ERROR:Version 1 on page 75 (0x70094a) is out of > range > ERROR:Version 1 on page 76 (0x70094b) is out of > range > ERROR:Version 1 on page 77 (0x70094c) is out of > range > ERROR:Version 1 on page 78 (0x70094d) is out of > range > ERROR:Version 1 on page 79 (0x70094e) is out of > range > ERROR:Version 1 on page 80 (0x70094f) is out of > range > > and the log give me > > 21:31:27 Informix Dynamic Server 2000 Version > 9.20.UC2 > 21:31:27 Who: Session(98, informix@hobbit, 18721, > 296254552) > Thread(1271, xchg_3.0, 11a5dd58, > 1) > File: rssupp.c Line:> 2658 > 21:31:27 Results: altering older version row to latest version> failed > 21:31:27 stack trace for pid 281 written to > /var/tmp/af.8dfce1f > 21:31:27 See Also: > /var/tmp/af.8dfce1f > 21:31:43 Assert Failed: read_record: decompress_row, source = 12797018,> target > = > 12725018 > 21:31:43 Informix Dynamic Server 2000 Version > 9.20.UC2 > 21:31:43 Who: Session(98, informix@hobbit, 18721, > 296254552) > Thread(1271, xchg_3.0, 11a5dd58, > 1) > File: rsread.c Line:> 2507 > 21:31:43 Results: Record not> read > 21:31:43 Action: Please notify Informix Technical > Support. > 21:31:43 stack trace for pid 281 written to > /var/tmp/af.8dfce1f > 21:31:43 See Also: > /var/tmp/af.8dfce1f > 21:32:06 read_record: invalid rowid = 4801, partnum => 700068 > > ITS is shut, so the question is there anything I can do or do I have to > wait, > I can't unload the table 'cos of the above