Re: SQL stored procedure takes longer to run in batch than interactively.

[Bobby Adams <bobby_adams@xxxxxxx>]

Thank you for your comments.  We will be looking at the changes we made 
and determine if they are still required.  Chances are that our work 
load has changed over the years, but we neglected to reevaluate our 
customizations.

On 5/15/2025 18:04, Don Brown via MIDRANGE-L wrote:
>     By default QBATCH, QPGMR and QCMN run in *BASE.
>
>     (DSPSBSD <sub-System) then option 2 for Pools)
>
>     On your system additional pools have been defined and the subsystem
>     description changed to run in the new pools.
>
>     As I have no knowledge of your workload there may be a valid reason for
>     this but generally if I was doing this for a specific reason I would
>     create a new subsystem with an appropriate name and description and route
>     the required jobs to this user defined/created subsystem.
>
>     The maximum active threads you have for QBATCH is very low.
>
>     Just my $0.02
>
>     Cheers
>     Don
>
>      
>
>     Don Brown
>
>     Senior Consultant
>      
>     [1]OneTeam IT Pty Ltd
>     P: 1300 088 400
>
>     -----Original Message-----
>     From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
>     Bobby Adams
>     Sent: Friday, 16 May 2025 3:33 AM
>     To: midrange-l@xxxxxxxxxxxxxxxxxx
>     Subject: Re: SQL stored procedure takes longer to run in batch than
>     interactively.
>
>     Yes.  Ours is below.  I do not know how or why the values were set, but if
>     you have questions I will ask.
>
>      +++++  *MACHINE
>       1118  *BASE
>         10   2          QBATCH      QSYS
>         10  *SHRPOOL10
>         10   2          QCMN        QSYS
>          3   2          QPGMR       QSYS
>         15  *SPOOL
>       2272  *INTERACT
>
>     On 5/15/2025 13:15, Glenn Gundermann wrote:
>     > I'm confused. You have Max Active set to 10?
>     >
>     > Our values look like this:
>     >
>     > +++++ *MACHINE
>     > 2400 *BASE
>     > 5600 *INTERACT
>     > 15 *SPOOL
>     >
>     > Yours truly,
>     >
>     > Glenn Gundermann
>     > Email: glenn.gundermann@xxxxxxxxx
>     > Cell: (416) 317-3144
>     --
>     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: [2]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
>     [3]https://archive.midrange.com/midrange-l.
>
>     Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
>     questions.
>
>     --
>     Message protected by MailGuard: e-mail anti-virus, anti-spam and content
>     filtering.
>     [4]https://www.mailguard.com.au
>
> References
>
>     Visible links
>     1. https://www.oneteamit.com.au/
>     2. https://lists.midrange.com/mailman/listinfo/midrange-l
>     3. https://archive.midrange.com/midrange-l.
>     4. https://www.mailguard.com.au/