RE: oncheck -cc errors
John,
I do not know the history for your case. But fact is, that the partition
page will be converted when upgrading from 7.31 to 9.x. Actually this might
be more a cosmetic problem since normal operation might not affected.
However, to fix this difference between systables record and partition page
you could do an 'alter table <table> modify next size <size in kB>'.
The value for next size should be different from the noticed values in
output of 'oncheck -cc'.
Probably you could consider the size of the table, existing extents for
this table and expected growth when choosing nextsize.
This might also work for your tables systabauth and sysdepend.
Example:
Error message is 'informix.systabauth nextsize 664 != tblspace.nxtsize 64'
Neccessary sql statement might be 'alter table 'systabauth' modify next
size 256;'
oncheck -cc might not report this error again
HTH,
Robert
Robert Seifert
_________________________________________________________________
IBM Deutschland GmbH, Data Management Solutions, Software,
Informix Products, Advanced Support
Elite VAR support engineer
Development Support for IBM Informix Products on-site @ SAP
c/o SAP AG, -TechDev05-,Neurottstrasse 16, D-69190 Walldorf, Germany
Phone +49-6227-7-45713, Fax +49-6227-7-47147
mailto:robert.seifert@de.ibm.com or mailto:robert.seifert@sap.com
http://www.ibm.com/software/data/informix
owner-informix-list@iiug.org wrote on 22.04.2005 13:58:37:
> 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
sending to informix-list