oncheck -cc errors
Posted in 2005
Topics: Installation, Setup & Upgrades, Storage & Space Management, Platform-Specific Issues, Versions, Editions & End-of-Life
I have had a script running the following command for years and since
we upgraded to 9.4 I'm getting errors. We have IDS 9.40.HC3 on a HP-UX
11i 4 cpu box.
oncheck -cc -q cars
ERROR: informix.systabauth nextsize 664 != tblspace.nxtsize 64
TBLspace name systabauth
Owner informix
TBLspace number 20006b
Tabid 4
Row size 77
Number of columns 4
Number of indexes 2
Number of rows 144152
Date created 11/19/1997
TBLspace major version number 4
TBLspace minor version number 958
TBLspace type T
Locking level B
Number of pages used 6611
First extent size 16
Next extent size 1328
Flags 0
Site
Database name
ERROR: informix.sysconstraints nextsize 160 != tblspace.nxtsize 8
TBLspace name sysconstraints
Owner informix
TBLspace number 200150
Tabid 11
Row size 335
Number of columns 7
Number of indexes 3
Number of rows 4132
Date created 11/19/1997
TBLspace major version number 6
TBLspace minor version number 957
TBLspace type T
Locking level B
Number of pages used 250
First extent size 16
Next extent size 320
Flags 0
Site
Database name
ERROR: informix.sysdefaults nextsize 128 != tblspace.nxtsize 8
TBLspace name sysdefaults
Owner informix
TBLspace number 20005c
Tabid 14
Row size 264
Number of columns 5
Number of indexes 1
Number of rows 3982
Date created 11/19/1997
TBLspace major version number 3
TBLspace minor version number 957
TBLspace type T
Locking level B
Number of pages used 590
First extent size 16
Next extent size 256
Flags 0
Site
Database name
ERROR: informix.sysdistrib nextsize 456 != tblspace.nxtsize 8
TBLspace name sysdistrib
Owner informix
TBLspace number 20006e
Tabid 24
Row size 305
Number of columns 9
Number of indexes 1
Number of rows 21405
Date created 11/19/1997
TBLspace major version number 3
TBLspace minor version number 957
TBLspace type T
Locking level B
Number of pages used 3569
First extent size 16
Next extent size 912
Flags 0
Site
Database name
Anyone know why I am getting these errors on 9.4 and was not on 7.31?
And, is there anything I can do to 'fix' them?
John David Adamski
Information Systems Specialist
Graceland University
On 21 Apr 2005 11:27:59 -0700, "jda" <adamski@graceland.edu> wrote:
>I have had a script running the following command for years and since
>we upgraded to 9.4 I'm getting errors. We have IDS 9.40.HC3 on a HP-UX
>11i 4 cpu box.
>
>
>
>oncheck -cc -q cars>
>ERROR: informix.systabauth nextsize 664 != tblspace.nxtsize 64
> TBLspace name systabauth
> Owner informix
> TBLspace number 20006b
> Tabid 4
> Row size 77
> Number of columns 4
> Number of indexes 2
> Number of rows 144152
> Date created 11/19/1997
> TBLspace major version number 4
> TBLspace minor version number 958
> TBLspace type T
> Locking level B
> Number of pages used 6611
> First extent size 16
> Next extent size 1328
> Flags 0
> Site
> Database name
>ERROR: informix.sysconstraints nextsize 160 != tblspace.nxtsize 8
> TBLspace name sysconstraints
> Owner informix
> TBLspace number 200150
> Tabid 11
> Row size 335
> Number of columns 7
> Number of indexes 3
> Number of rows 4132
> Date created 11/19/1997
> TBLspace major version number 6
> TBLspace minor version number 957
> TBLspace type T
> Locking level B
> Number of pages used 250
> First extent size 16
> Next extent size 320
> Flags 0
> Site
> Database name
>ERROR: informix.sysdefaults nextsize 128 != tblspace.nxtsize 8
> TBLspace name sysdefaults
> Owner informix
> TBLspace number 20005c
> Tabid 14
> Row size 264
> Number of columns 5
> Number of indexes 1
> Number of rows 3982
> Date created 11/19/1997
> TBLspace major version number 3
> TBLspace minor version number 957
> TBLspace type T
> Locking level B
> Number of pages used 590
> First extent size 16
> Next extent size 256
> Flags 0
> Site
> Database name
>ERROR: informix.sysdistrib nextsize 456 != tblspace.nxtsize 8
> TBLspace name sysdistrib
> Owner informix
> TBLspace number 20006e
> Tabid 24
> Row size 305
> Number of columns 9
> Number of indexes 1
> Number of rows 21405
> Date created 11/19/1997
> TBLspace major version number 3
> TBLspace minor version number 957
> TBLspace type T
> Locking level B
> Number of pages used 3569
> First extent size 16
> Next extent size 912
> Flags 0
> Site
> Database name
>
>Anyone know why I am getting these errors on 9.4 and was not on 7.31?
>And, is there anything I can do to 'fix' them?
>
Has anyone been updating the system tables directly lately?
JWC