IDS Forum

How to check a Non vanilla Index

Posted By: Thirugnanam, Kannan
Date: Monday, 19 January 2009, at 12:30 p.m.

IDS version: 9.40 FC4

OS: Sun Solaris 9

Index schema

create index "informix".messagequeue_ix4 on "informix".messagequeue

(singleton,type,channel) using btree in efdbefs2009idx2dbs ;

Fields: singleton "informix".boolean default 'f' not null

type varchar(10)

channel varchar(255) not null

Prelude: The instance crashed today morning complaining that this index
was corrupt.

When I run a oncheck -cIDn on the table, I get the below comments for
this index.

Index messagequeue_ix3

Index fragment in DBspace efdbefs2009idx2dbs

Index messagequeue_ix3: Non vanilla index. data
crosschecking not enabled

Any idea on how to check this index or did it actually check the index
and it is just an output message.

Your help or suggestion is appreciated.

Thank you,

Kannan

***** Jackson Hewitt Email Disclaimer *****

The sender believes that this E-mail and any attachments were free of any virus, worm,
Trojan horse, and/or malicious code when sent. This message and its attachments could
have been infected during transmission. By reading the message and opening any
attachments, the recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. The sender's business entity is not liable for any
loss or damage arising in any way from this message or its attachments.

Privileged/Confidential Information may be contained in this message. If you are not the
addressee indicated in this message (or responsible for delivery of the message to such
person), you may not copy or deliver this message to anyone. In such case, you should
destroy this message and kindly notify the sender by reply email.

IDS Forum is maintained by Administrator with WebBBS 5.12.