Re: Slow QSYS2.OUTPUT_QUEUE_ENTRIES?

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

thanks Rob.  I've been searching and found Simon Hutchinson's article about
how performance is bad on outpute_queue_entries.  I was going to change it
to use the API's but then I saw that the user had 300K spool files!  I
cleared those out and performance is acceptable now.,

I installed latest cume and TR6 on another machine last night and if all
goes well I will install on production this weekend.

Art

On Tue, Jul 23, 2019 at 8:25 AM Rob Berendt <rob@xxxxxxxxx> wrote:

> I know you said:  V7R3.  PTF's about 6 months ago.
> However I prefer details.  If you've ever had someone said "I just put on
> the cume" only to find out it's one they had on the shelf for 2 years you'd
> understand.  Do a WRKPTFGRP and find the level for SF99703.  What is it?
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art
> Tostaine, Jr.
> Sent: Sunday, July 21, 2019 2:59 PM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Slow QSYS2.OUTPUT_QUEUE_ENTRIES?
>
> CAUTION: This email originated from outside of the organization. Do not
> click links or open attachments unless you recognize the sender and know
> the content is safe.
>
>
> V7R3.  PTF's about 6 months ago.
>
> I am running this Select statement on a job that could have up to 1000
> spool files.  Once I read the spool file and copy to a flat file I delete
> it.  I've been googling trying to figure out why we don't have
> QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC.  That might help me.
>
> SELECT SPOOLED_FILE_NAME, USER_NAME, FILE_NUMBER  FROM
> TABLE(QSYS2.OUTPUT_QUEUE_ENTRIES('*LIBL',:wkPrinter ,'*NO'
>  where job_name = :qJobName;
>
> The job is running slow, and I see that the SQL statement is slow.  Open
> files shows number of reads over 140K?
>
>                       Member/    Record     File    I/O  ----Open---
>  Relative
> File       Library    Device     Format     Type   Count Opt Shr-Nbr
> Record
> QASPOUTQ   QSPL       QASPOUTQ   OUTQSPLFS  LGL   140379 I   NO
> 651455
>
> If I run it interactively I see this in the status line
>
> Query running. 0 records selected, 106310 processed.
>
> Is this normal?
> --
> Art Tostaine
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com