oncheck -cc errors
David Fortune, on IDS 9.21UC7, saw oncheck -cc errors about system catalog nextsize not matching tblspace nxtsize. David Williams said it meant corruption needing restore, rebuild or Informix support. Jean Sagi suggested dbexport/dbimport. Mac Horn thought it might be concurrent index or procedure creation and advised re-running when idle. No confirmed outcome.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
When I run oncheck -cc to verify the integrity of the system catalogs I get
some errors regarding extent size discrepencies e.g.
ERROR: informix.sysindices nextsize 48 != tblspace.nxtsize 8
ERROR: informix.systabauth nextsize 32 != tblspace.nxtsize 8
ERROR: informix.sysdefaults nextsize 132 != tblspace.nxtsize 8
ERROR: informix.sysprocedures nextsize 32 != tblspace.nxtsize 8
Is this something I should really be worried about or is this just a warning
that indicates the system tables have started to fragment.
If so how do you correct this ?
p.s I am running IDS 9.21UC7.
It means you have a corrupt database. Has someone been updating the system
catalogs directly?
You will need to either
a) Restore from backup
b) Unload data from all databases in the instance. Recreate the instance
with oninit -i.
Add all dbspaces/chunks. Recreate all databases, reload all data.
b) Get Informix to dial in and fix the problem. They may insist you do a) or
b) anyway!
----- Original Message -----
From: "DAVID FORTUNE" <david.fortune@ingenicofortronic.com>
To: <ids@iiug.org>
Sent: Wednesday, July 30, 2003 2:50 PM
Subject: oncheck -cc errors [1606]
> When I run oncheck -cc to verify the integrity of the system catalogs I
get some errors regarding extent size discrepencies e.g.
>
> ERROR: informix.sysindices nextsize 48 != tblspace.nxtsize 8
> ERROR: informix.systabauth nextsize 32 != tblspace.nxtsize 8
> ERROR: informix.sysdefaults nextsize 132 != tblspace.nxtsize 8
> ERROR: informix.sysprocedures nextsize 32 != tblspace.nxtsize 8
>
> Is this something I should really be worried about or is this just a
warning that indicates the system tables have started to fragment.
>
> If so how do you correct this ?
>
> p.s I am running IDS 9.21UC7.
>
>
>
>
... I should think in a dbexport / dbimport ...
DAVID FORTUNE wrote:
> When I run oncheck -cc to verify the integrity of the system catalogs I get
some errors regarding extent size discrepencies e.g.
>
> ERROR: informix.sysindices nextsize 48 != tblspace.nxtsize 8
> ERROR: informix.systabauth nextsize 32 != tblspace.nxtsize 8
> ERROR: informix.sysdefaults nextsize 132 != tblspace.nxtsize 8
> ERROR: informix.sysprocedures nextsize 32 != tblspace.nxtsize 8
>
> Is this something I should really be worried about or is this just a warning
that indicates the system tables have started to fragment.
>
> If so how do you correct this ?
>
> p.s I am running IDS 9.21UC7.
>
>
>
>
>
--
Atte,
Jesús Antonio Santos Giraldo
jeansagi@myrealbox.com
jeansagi@netscape.net
David,
I don't see this as a problem.
You might want to check with IBM, but I believe on an active system, this
might indicate that an index or procedure is being created when you ran the
oncheck. I would re-run during an inactive time (as much as possible) and
see if you are still getting the same results.
just a thought.
mac
-----Original Message-----
From: Jean Sagi [mailto:jeansagi@myrealbox.com]
Sent: Saturday, August 02, 2003 3:22 PM
To: ids@iiug.org
Subject: Re: oncheck -cc errors [1624]
.. I should think in a dbexport / dbimport ...
DAVID FORTUNE wrote:
> When I run oncheck -cc to verify the integrity of the system catalogs I
get some errors regarding extent size discrepencies e.g.
>
> ERROR: informix.sysindices nextsize 48 != tblspace.nxtsize 8
> ERROR: informix.systabauth nextsize 32 != tblspace.nxtsize 8
> ERROR: informix.sysdefaults nextsize 132 != tblspace.nxtsize 8
> ERROR: informix.sysprocedures nextsize 32 != tblspace.nxtsize 8
>
> Is this something I should really be worried about or is this just a
warning that indicates the system tables have started to fragment.
>
> If so how do you correct this ?
>
> p.s I am running IDS 9.21UC7.
>
>
>
>
>
--
Atte,
Jesus Antonio Santos Giraldo
jeansagi@myrealbox.com
jeansagi@netscape.net