IDS Forum

RES: Error -1801in IDS 11.50.FC4

Posted By: Alberto Romeu Pessonio Filho
Date: Monday, 14 March 2011, at 8:26 a.m.

In Response To: Re: Error -1801in IDS 11.50.FC4 (OLIVIER CONSULTIX)

As far as I know, Informix works with auto-commit when we aren't using an explicit transaction (begin work and commit work) within a transaction.

Try to create this procedure:

CREATE PROCEDURE "user_of_your application".sysdbopen ()

SET ISOLATION TO COMMITED READ;

-- SET LOCK MODE TO WAIT 10;

-- and other configurations for the session of a user

END PROCEDURE;

[]'s

Alberto Pessonio |DBA Informix Senior
IBM Certified Informix System Administrator V7
IBM Certified Informix Managing and Optimizing Databases V7
IBM Certified Informix Dynamic Server Technical Mastery Test v11
Tel. +55 11 4932 5154 | +55 11 7897 1458
www.orizonbrasil.com.br

-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de OLIVIER CONSULTIX
Enviada em: segunda-feira, 14 de março de 2011 09:18
Para: ids@iiug.org
Assunto: Re: Error -1801in IDS 11.50.FC4 [23066]

Thank you for your answers

No, there isn't any message about this error in the log

I just try to set HETERO_COMMIT to 1 but it doesn't solved the problem

I don't know if this will help, but here are some details:

The application is developed with PowerBuilder which use a "auto-commit" (when
a commit or rollback is executed, a new transaction automatically begins).
When the user executes the application, a first transaction is created using
SQLCA (CONNECT USING SQLCA;) with the "dirty read" isolation
When an other transaction is created (with the same user, database, instance
and isolation level), the SQL error -1801 occurs

What I do not understand is that application works on all the other posts on
which this application is installed.

This error occurs since I installed the last OAT version which installed IBM
Informix setnet32 3.70 TC1.

I will try to uninstall this version of setnet32 and install the same version
than the other posts to see if the setnet32 version is really the origin of
the problem

I will post a message to keep you informed when I had the time to perform this
manipulation

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Error -1801in IDS 11.50.FC4
  OLIVIER CONSULTIX -- Monday, 14 March 2011, at 6:43 a.m.
  • Re: Error -1801in IDS 11.50.FC4
    Alexandre Marini -- Monday, 14 March 2011, at 7:41 a.m.
    • Re: Error -1801in IDS 11.50.FC4
      OLIVIER CONSULTIX -- Monday, 14 March 2011, at 8:17 a.m.
      • RES: Error -1801in IDS 11.50.FC4
        Alberto Romeu Pessonio Filho -- Monday, 14 March 2011, at 8:26 a.m.
      • Re: Error -1801in IDS 11.50.FC4
        Petr Pomykacek -- Monday, 14 March 2011, at 8:33 a.m.
  • RES: Error -1801in IDS 11.50.FC4
    Alberto Romeu Pessonio Filho -- Monday, 14 March 2011, at 7:46 a.m.
  • Re: Error -1801in IDS 11.50.FC4
    Jonathan Leffler -- Monday, 14 March 2011, at 2:51 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.