oncheck
Posted in 2005
*INFORMIX 7.31.UD1 / LINUX*
How can I correct the situation below?
[informix@apcbd98 guardiao]$ oncheck -cDI guardiao:chmd_chamada
Validating indexes for guardiao:guardiao.chmd_chamada...
Index 163_278
Could not check rowids and perform data<->index check
*ISAM error: Illegal value in varchar length field
* Index xif53chmd_chamada
Could not check rowids and perform data<->index check
ISAM error: Illegal value in varchar length fieldIndex xif81chmd_chamada
Could not check rowids and perform data<->index check
ISAM error: Illegal value in varchar length fieldIndex xie1chmd_chamada
ERROR: Keys in node 0xa9e74 are not in order.
ERROR: Index xie1chmd_chamada for guardiao:guardiao.chmd_chamada is bad.
Index xie7chmd_chamada
Could not check rowids and perform data<->index check
ISAM error: Illegal value in varchar length fieldIndex xie2chmd_chamada
ERROR: Keys in node 0xa9f79 are not in order.
ERROR: Index xie2chmd_chamada for guardiao:guardiao.chmd_chamada is bad.
Index xie5chmd_chamada
Could not check rowids and perform data<->index check
ISAM error: Illegal value in varchar length fieldIndex xie6chmd_chamada
Could not check rowids and perform data<->index check
ISAM error: Illegal value in varchar length field
WARNING: Check of index 163_278 was not completed.
WARNING: Check of index xif53chmd_chamada was not completed.
WARNING: Check of index xif81chmd_chamada was not completed.
Index xie1chmd_chamada is bad. OK to repair it? y
Error recreating index.
ISAM error: Illegal value in varchar length field
TBLspace data check for guardiao:guardiao.chmd_chamada
BAD PAGE 2b15da: Bad data row - rowid 177942276
BAD PAGE 336808: Bad data row - rowid 179953924
ERROR: Remainder piece 9be2a01 found in page but not referenced by d
--
*Jairo Gubler*
/Analista de Sistemas
//APL - IBD (Interfaces e Banco de Dados)/
*DMGITRO TECNOLOGIA*
*E-mail:* jairo.gubler@digitro.com.br <mailto:jairo.gubler@digitro.com.br>
*Fone:* (48) 3281 7213
*Fax:* (48) 3281 7299
*Site:*www.digitro.com.br <http://www.portaldigitro.com.br>