RE: List Spooled Files API really SLOW on V5R3

["Winchester Terry" <terry.winchester@xxxxxxxxxxxxxxx>]

Brad,

Apparently there is a problem with QGYSERVER not releasing
locks in certain circumstances. I stumbled over this link:

http://www-912.ibm.com/n_dir/nas4apar.nsf/ALLAPARS/SE24695

Terry Winchester 
Programmer/Analyst
________________________________
The Raymond Corporation
terry.winchester@xxxxxxxxxxxxxxx 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Brad Stone
> Sent: Thursday, May 18, 2006 10:59 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: List Spooled Files API really SLOW on V5R3
> 
> Hi, Mike.
> 
> Yes, it is.  It seems to be related to the QGYSERVER job
> that gets started, as during this time that's the last
> thing in the call stack. 
> 
> Once it seems to come alive again (up to 30 minutes later
> for any number of spooled files) subsequent calls to the
> SPLTOOL command are fine, like they should be.
> 
> It's like that QGYSERVER job is just stuck!
> 
> Brad
> 
> On Thu, 18 May 2006 08:58:47 -0500
>  "Mike the Code Monkey" <koldark@xxxxxxxxx> wrote:
> > Out of curiosity, is this for SpoolTool? If so, we
> > haven't had any problems
> > with it.
> > 
> > On 5/18/06, Brad Stone <brad@xxxxxxxxxxxx> wrote:
> > >
> > > I have a product that uses the QGYOLSPL API to list
> > spooled
> > > files.
> > >
> > > For years it's been great and had great performance.
> >  Now I
> > > have two users that are saying it is taking between 10
> > and
> > > 30 minutes to load the list of subfiles no matter how
> > many
> > > spooled files are in the selection.
> > >
> > > Both are on V5R3.  One has a 520, the other has a 720.
> >  I
> > > can't find any PTFs related to this API and performance
> > > except back in V5R1.
> > >
> > > Has anyone else had issues on V5R3 with any software
> > that
> > > lists spooled files being really slow?
> > >
> > > Brad
> > > --
> > 
> > -- 
> > Mike Wills
> > koldark@xxxxxxxxx
> > http://theriverbendpodcast.com
> > 

Confidentiality Notice:

The preceding e-mail message (including any attachments) contains information 
that may be confidential, protected by applicable legal privileges, or 
constitute non-public information. It is intended to be conveyed only to the 
designated recipient(s). If you are not an intended recipient of this message, 
please notify the sender by replying to this message and then delete it from 
your system. Use, dissemination, distribution or reproduction of this message 
by unintended recipients is 
not authorized and may be unlawful.