SEO

#1 (**permalink**) 04-19-2008, 06:04 PM

Informix Versions

4GL - 4.13.UD1
ESQL- 5.03.UC1
SE - 5.02

Operating System: SCO OpenServer 5 versions 5.0.4, 5.0.5, 5.0.6

We are experiencing a number of errors;

-211 Cannot read system catalog catalog-table
-242 Could not open database table table-name
-243 Could not position within a table table-name
-244 Could not do a physical-order read to fetch next row
-245 Could not position within a file via an index
-246 Could not do an indexed read to get the next row
-397 System catalog table-name corrupted
-710 Table table-name has been dropped, altered, or renamed
-750 Invalid distribution format found for table_name

on various sites.

Errors such as -245 don't always point to a corrupt .idx file. The
-750 is a false
report because the table can be seen & selected from on another login.

The hardware has been checked out by Hardware Engineers and found not
to have any faults.
The problem systems are also from a range of manufacturers.

I realise that we are using an old version of Informix, but has anyone
had any experience with
these sorts of issues.

#2 (**permalink**) 04-19-2008, 06:04 PM

Have you run a bcheck

Fatlad wrote:
>
> Informix Versions
>
> 4GL - 4.13.UD1
> ESQL- 5.03.UC1
> SE - 5.02
>
> Operating System: SCO OpenServer 5 versions 5.0.4, 5.0.5, 5.0.6
>
> We are experiencing a number of errors;
>
> -211 Cannot read system catalog catalog-table
> -242 Could not open database table table-name
> -243 Could not position within a table table-name
> -244 Could not do a physical-order read to fetch next row
> -245 Could not position within a file via an index
> -246 Could not do an indexed read to get the next row
> -397 System catalog table-name corrupted
> -710 Table table-name has been dropped, altered, or renamed
> -750 Invalid distribution format found for table_name
>
> on various sites.
>
> Errors such as -245 don't always point to a corrupt .idx file. The
> -750 is a false
> report because the table can be seen & selected from on another login.
>
> The hardware has been checked out by Hardware Engineers and found not
> to have any faults.
> The problem systems are also from a range of manufacturers.
>
> I realise that we are using an old version of Informix, but has anyone
> had any experience with
> these sorts of issues.

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #

#3 (**permalink**) 04-19-2008, 06:05 PM

Yes we have run a bcheck. Initially these errors where thought to be
purely file corruptions.

As I said in my previous posting, some of these errors are phantom
ones.

We've checked the disk's and non have reported problems.

Paul Watson <paul@oninit.com> wrote in message news:<3F005E6B.411B0772@oninit.com>...
> Have you run a bcheck
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Various Informix Errors pointing to file corruption