QTP as a system hog

[georgia miller]

Dave,
We are on HP3000 PH819.C3.  We have had this problem back to PH6.09.  We started having 
this problem when MPE did their ques differently (don't know the version maybe around 3.0)  When a QTP process is hogging all the 
machine resources is when there is a locking issue where more than one user is trying
to get access to a file that is locked with QTP.  Even using SET LOCK FILE REQUEST doesn't
help when users are trying to access the same file.  What we've found is that when MPE
experiences a locking issue like this, where a user is locked out of a file, it keeps bumping
up the number of resources for the user or process that has the file locked in an attempt
to get the other user access sooner.  It keeps throughing resources at the offender until
they have the entire machine resources.  No one else can do anything, even a simple
MPE command until the process is done and the lock released.  Luckily this doesn't
happen that often and when it does, the offending process finishes in about 10 minutes
when it has all the machine resources going towards getting it done.

Making sure that SET LOCK FILE REQUEST on every QTP helps it from happening as
much.  Also on systems with a lot of users, we try to limit the QTP processes to the
evening when only a few users are on at a time.  When it does happen, everyone
takes a break or starts catching up on email or something for a few minutes, 
until the process finishes.  Also doing long extracts and sorting with Quiz instead
of QTP helps.  I like writing QTP code better than Quiz when it comes to creating
subiles and doing totals, etc.  But QTP causes problems because of the locking
issues that is does that Quiz doesn't do.

Georgia Miller
Great Falls Public Schools
Great Falls, Montana
____________________________________________________________________

>To: powerh-l@lists.swau.edu; HP3000-L@RAVEN.UTC.EDU
>From: Dave Knispel on Tue, Apr 18, 2000 11:27 AM
>Subject: QTP as a system hog

>
>To all,
>
>I'm working on an HP3000 using QTP version 8.19.C2.  I have a QTP process
>that is reading a NM/KSAM file, doing a select, sorting, then writing out
>two subfiles.  This process keeps taking over my system.  Even running in
>the EQ it will take all available system resources so no one (even the folks
>in a higher queue) can get any CPU time.
>
>Has anyone seen this before?  Any help would be appreciated.
>
>I'm posting this to both the HP3000-L and the Powerhouse-L.
>
>David Knispel
>dave.knispel@frequencymarketing.com
>Phone: 513-248-5029
>Fax: 513-248-2672
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
>Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
>This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.