Informix Guys Help Help Help

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 thefirst flag column of onstat -u Please Help. Thank You

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