RE: isoalation level

Posted in 1998

Brais, Paul — Thu, 23 Jul 1998 13:14:33 -0700 — source: Informix-list mailing list archive (1991-1998)

That seems like alot of locks.=20 So, do you have at times sessions locked out? In those situations do you have to kill sessions to clear up the = locking situations? > ---------- > From: Vicente de Blas Bellido[SMTP:debbelvi@sintelsa.com] > Reply To: Vicente de Blas Bellido > Sent: Thursday, July 23, 1998 5:31 AM > To: informix-list@iiug.org > Subject: Re: isoalation level >=20 > Yes. PeopleSoft recommends CR for isolation. > We have PeopleSoft software and the same problem whit the locks. > Several > process takes a lot of locks so we had to increase the LOCKS = parameter > in > Informix to 2000000 but even so sometimes we have to change the lock > mode in > some tables to use PAGE MODE. >=20 > Brais, Paul escribi=F3: >=20 > > This question is for anyone using PeopleSoft. > > Does PeopleSoft recommend a certain isolation level for the > database? > > My system is currently using CR for isolation. the problem is it is > doing > > alot of locks. I think think this may be causing some performance > problems. > > > > Paul J. Brais > > Northrop Grumman Corp. > > 1 Northrop Ave. > > Hawthorne, Ca. 90250 > > Phone: 310/332-3734 > > Pager: 310/249-1027 > > email: braispa@mail.northgrum.com >=20 >=20 >=20