Re: table sysdistrib inconsistent
- From: "Art S. Kagel" <art.kagel@xxxxxxxxx>
- Date: Tue, 20 Nov 2007 11:51:20 -0800 (PST)
On Nov 20, 7:38 am, "S. Wolschke" <hektor1...@xxxxxxxxx> wrote:
Hey,
nice problem in one of our databases.
The update statistics doesnt work.
The update statistics crahs with the following error
Cannot Update statistics for table: scott;
SQLCODE = -211, ISAM = -172, POS = 67
ok, try to kick the statistics
update statistics low for table scott drop distributions;
211: Cannot read system catalog (sysdistrib).
172: ISAM error: Unexpected internal error
An unload on table scott works fine, the problem is in the sysdistrib
table.
select * from sysdistrib where tabid=127 (127=table scott)
243: Could not position within a table (informix.sysdistrib).
103: ISAM error: illegal key descriptor (too many parts or too
long).
To drop and recreate the database is the last option for me. The
customer works 24/7 on this database.
Maybe i can drop and recreate the table scott, but the sysdistrib has
an problem, so im not sure.
It's possible to delete the table scott in sysdistrib?
Anyone a good idea?
SLES8, IFX 9.40UC3
Sebastian
You can safely delete rows from sysdistrib. Its contents are only
looked at by UPDATE STATISTICS and the optimizer, however, that may
not be the problem. There may be some corruption on the table's
partition page.
If UPDATE STATISTICS... DROP DISTRIBUTIONS is not working then the
manual delete will likely fail as well. I'd take Superboer's advice
and start with tech support.
Art S. Kagel
.
- References:
- table sysdistrib inconsistent
- From: S. Wolschke
- table sysdistrib inconsistent
- Prev by Date: Informix idump v4.0
- Next by Date: Re: Informix idump v4.0
- Previous by thread: Re: table sysdistrib inconsistent
- Next by thread: Re: table sysdistrib inconsistent
- Index(es):
Relevant Pages
|
|
