Re: ONCHECK -CI
Posted in 2005
TBP — — source: Usenet: comp.databases.informix
herbO via DBMonster.com wrote:
> Can the message "Index fragment in DBspace" that is returned from the
> execution of "oncheck -ci" be eliminated? Dropping the table or the index
> and recreating in new dbspaces has not done so for me.
create database mashed;
create table tab1 (col1 int, col2 char);
create index idx_fragment on tab1 (col1);
create index idx_non_fragment on tab1 (col1, col2) in table; > oncheck -cDI mashed:tab1 -x
Validating indexes for mashed:informix.tab1...
Index idx_non_fragment
Index idx_fragment
Index fragment partition rootdbs in DBspace rootdbs
TBLspace data check for mashed:informix.tab1
See also DEFAULT_ATTACH.