FW: No of index | oncheck -cc
> Whenever I run oncheck -cc i get following error message for most of the
> tables.
> (I am running IFX 7.13 UC1 on solaris 2.6)
>
> 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