We have a problem each day when a group of users log off the MPE system at the end of their shift.  As these employees shut down their sessions, we start seeing lots of sessions spending a significant amount of time in an impeded state.  It affects the sessions that are logging off, as well as several others.  When I have displayed stack traces of impeded sessions in Glance, it seems they are usually doing a DBCLOSE.  I surmise that there is contention for a database control block, which causes these processes to impede one another.  Can anyone suggest a solution to this problem?  Is there any kind of setting that would allow greater concurrency in the DBCLOSE process or reduce the amount of time each process has the resource locked?  Does anyone disagree with my diagnosis of the issue?  Any suggestions would be appreciated.
 
Regards,
John Clogg
_________________________________________________________________
Get the power of Windows + Web with the new Windows Live.
http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_012008
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *