RE: oncheck -cc errors
Update systables ?
I wouldn't recommend that, unless you have Tech Support sitting on the
other side of a telephone line, instructing you to do it ..........
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of superboer
Sent: 22 April 2005 07:52 AM
To: informix-list@iiug.org
Subject: Re: oncheck -cc errors
do you have a test system??
if so restore a backup of your system onto it and
start hacking...
> ERROR: informix.systabauth nextsize 664 != tblspace.nxtsize 64
> Next extent size 1328
it sounds like the info on the partition pages are not the same as what
is
stored in systables;
you could try !ONLY ON A TEST SYSTEM!
update systables set nextsize = 128
where tabname ="systabauth";
you may have to bounce the engine;
try to run oncheck and see if it disappears..
Superboer.
BTW are you sure that noone did this to systables in the past in the
first
place?? eq did someone do
update systables set nextsize = 664
where tabname ="systabauth"; ... etc. to try and trick the engine increateing a bigger next size????
"jda" <adamski@graceland.edu> wrote in message
news:<1114108079.518469.322290@l41g2000cwc.googlegroups.com>...
> 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
sending to informix-list