RE: oncheck -cc errors
John and Dirk,
I wonder that this issue is still discussed since I already mentioned how
to get rid of this problem...
Please see below.
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 18:28:17:
> 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