Isolation Level and sacego V4.1V

Posted in 1999

Roland Grzyb — Wed, 18 Aug 1999 14:56:22 +0200 — source: Informix-list mailing list archive (1991-1998)

IIUG Gurus, we use some reports with sacego V4.1V and have set 'SACEISOL=dirty read' on the application server. From time to time the isolation level was not set and the Informix data base reported a lock table overflow (the max. of 256000 locks are configured). It seems that it only occurs when 2 or more sacego (or ISQL with explicit 'Set isolation to dirty read' before running the report) processes are running. Configuration Application Server SNI rm600/10 SINIX 5.41 3 CPU ISQL V4.1V Informix NET 5.03.UC1 Database Server SNI rm400/E40 SINIX 5.44 3 CPU Informix ONLINE 5.01.UC1A2 Informix STAR 5.01.UC1A2 Does anybody get a clue on this? Thanks