oncheck -cc problems

Posted in 1999

Shevkar, Mukund — Tue, 18 May 1999 09:08:32 -0700 — source: Informix-list mailing list archive (1991-1998)

Whenever I run oncheck -cc i get following error message for most of the tables. Validating database ola Validating systables for database ola ERROR: db.statapps nindexes 12 != tblspace.nkeys 11 + detached keys 0 ERROR: di_nkeys 11 != systables nindexes 12 - detached keys 0 for table db.statapps. TBLspace name statapps Owner db TBLspace number 200195 Tabid 973 Row size 694 Number of columns 140 Number of indexes 12 Number of rows 11438 Date created 02/20/1998 TBLspace major version number 236 TBLspace minor version number 235 TBLspace type T Locking level P Number of pages used 5721 First extent size 2564 Next extent size 256 : What is it and how to correct it? Regards Mukund

↪ replying to Shevkar, Mukund

Dragan Jurkovic — Wed, 19 May 1999 09:30:54 -0400 — source: Informix-list mailing list archive (1991-1998)

Shevkar, Mukund wrote: > Whenever I run oncheck -cc i get following error message for most of the > tables. > > Validating database ola > > Validating systables for database ola > ERROR: db.statapps nindexes 12 != tblspace.nkeys 11 + detached keys 0 > ERROR: di_nkeys 11 != systables nindexes 12 - detached keys 0 > for table db.statapps. > TBLspace name statapps > Owner db > TBLspace number 200195 > Tabid 973 > Row size 694 > Number of columns 140 > Number of indexes 12 > Number of rows 11438 > Date created 02/20/1998 > TBLspace major version number 236 > TBLspace minor version number 235 > TBLspace type T > Locking level P > Number of pages used 5721 > First extent size 2564 > Next extent size 256 > : > What is it and how to correct it? > Regards > > Mukund Run oncheck -cI. Dragan Jurkovic MRRM (Canada) Inc.