Re: Informix Guys Help Help Help

Thanks, I'll give it a try. Superboer wrote: > loonnggg shot: > > may be you compiled your spl's (update statistics for procedure) with > pdqpriority set. > when a program execute's it, it'll try to set pdq. > > if your system has switched it of, it will not set pdq but it may cause > mutexes on mgm??? > > so you could try: > > set pdqpriority 0; > update statistics for procedure;> and check if that helps. > > i would also check your 4gl programs, your environment and > the environment when the database is started for occurances of pdq. > > > Superboer. > > > > > > > yossik1@optonline.net schreef: > > > I recently posted this question in this group, with no response. > > > > we are having this problem for a long time. And no one (not even IBM) > > has provided a solution. > > > > So here is the question again to all your great informix gurus and hope > > someone reads this. > > > > This happens mainly when users log off the system (on the system we > > have about > > 1000 users and hundreds of users will log off at the same time), We see > > lots of > > MGM mutex locks > > > > PDQPRIORITY is set to 0 (we never never use PDQ) > > > > OS: Solaris 8 > > Informix Version: IDS - 7.31.FD7 > > Programs: Informix 4GL > > > > mutex locks are MGM mutexes. > > with PDQ turned off onstat -g mgm shows no quires running > > > > onstat -g lmx points to MGM mutex when there is lots of 'S' in the> > first flag column of onstat -u > > > > Please Help. > > > > Thank You