Informix ids 9.x error

在查詢某筆資料的時候，database竟出現錯誤訊息如下：

243: Could not position whthin a table (cpu.bb_file).
111: ISAM error:  no record found.


這可能是index page損壞所致，可以利用以下指令查查

oncheck -cDI :

run這個指示很快就會有結果：以下是這次的結果，紅色字是其建議要做的事。

這是個人使用心得，要使用的網友請自行評估風險。

oncheck -cDI ds:bb_file

Validating indexes for ds:cpu.bb_file...

Index bb01_bb02

   Index  fragment in DBspace dbs1

ERROR:The btree item points to a wrong rowid.

Btree item contains fragid 0x600748 rowid 0x2f5d02, key value:

Key:"7AAVI     ":3:

Fragid 0x600748 Rowid 0x2f5d02 contains key value:

Key:"9SMICOR   ":107:

Index bb03

   Index  fragment in DBspace dbs1

ERROR:The btree item points to a wrong rowid.

Btree item contains fragid 0x600748 rowid 0x35c602, key value:

Key:"<00>                             ":

Fragid 0x600748 Rowid 0x35c602 contains key value:

Key:"Mr. Fernando Santos           ":

Please Drop and ReCreate Index bb01_bb02 for ds:cpu.bb_file.

Please Drop and ReCreate Index bb03 for ds:cpu.bb_file.

TBLspace data check for ds:cpu.bb_file