Hi,

One of our application making requests to the Informix database has thrown following errors
-243 Handled error -111 Message: Could not position within a table.
This error has been reported only once .

I don't see any errros reported in the online.log file.When I checked the details of error 243 in the error messages doc .Won't any errors of these kind reported in the online.log file.How do we detect these problems on the database.

I have 3 servers running informix db.When i issue the onstat -p command I see
ixda-RA idx-RA da-RA RA-pgsused lchwaits
1134523 40129 448628 1592046 145774

The idx-RA shows a big number on one server but it is 1 on the other 2 servers.The load is equal on all the 3 db servers.What do i conclude from this.

Any idea of how to use the bcheck and secheck utility.We are using IDS 9.2.

What is the difference b/w Informix SE and IDS.I don't see the secheck utility available under the bin directory or anywhere.What other utilities do we have under IDS 9.2 to detect the errros I have reported.

Please can anyone help me.These are some serious production problem.

There is no 'secheck' available for IDS.
You need to run:

oncheck -cDI <dbname>:<tablename>

This will check the data and index pages of the
specified table.

It might be helpful to execute 'oncheck -cDI' on the
whole database.
However this is critical in a production environment,
so the best thing is to restore your databaseserver
to a second machine and execute the oncheck
on this second machine for the whole database(s).

And I would also recommend that you take a training or
order an informix consultant if you don't know the
difference between SE and IDS.

HTH.

Best regards

Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************

***********8