Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Location
    Bellevue,WA
    Posts
    20

    Unanswered: -243 Handled error -111 Message: Could not position within a table-URGENT

    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.
    Last edited by b_ravindra_74; 02-05-03 at 17:20.

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    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
    ***********************************************

    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
    ***********************************************

  3. #3
    Join Date
    Sep 2002
    Location
    Bellevue,WA
    Posts
    20
    Originally posted by eherber
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •