RE: oncheck -cc errors
Superboer & JWC
To my knowledge no one updated the systables directly. It is possible
someone has in the past updated them directly to get larger next sizes
trying to minimize the number of extents on these tables. We have had
this database in IDS sine 1997 I believe maybe 1996 and I did not come
on board until mid-2001.
When we upgraded to 9.4 we also migrated from another server, that old
server is still in house running 7.31. it is planned to keep for a
little while and upgrade it to 9.4 as a backup machine, so will have a
test machine soon to try this.
Thanks
John
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of John Carlson
Sent: Thursday, April 21, 2005 10:04 PM
To: informix-list@iiug.org
Subject: Re: oncheck -cc errors
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
sending to informix-list