Fw: IBM i work management

If you're interested, our DB2 Lab Services team regularly helps clients
running Cognos (or any other BI tool) tune those queries. I know one of
the consultants was just saying how he helped a customer last week take a
report running 8 minutes down to less than 1 second. So while it may be
true Work Management can be affecting things, its probably also very
important to understand what else you can do to accelerate those queries.
If you're interested, contact mackd@xxxxxxxxxx

Regards,
Kathy Steinbrink


----- Forwarded by Kathryn Steinbrink/Rochester/IBM on 04/07/2016 10:26 AM
-----

From: Bryan Dietz <bdietz400@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 04/07/2016 09:40 AM
Subject: Re: IBM i work management
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



If you are not able to use the new SQL services here is what I created
"back in the day"

http://archive.midrange.com/midrange-l/200503/msg01345.html


Bryan



Kevin Adler wrote on 4/6/2016 6:13 PM:

FYI, if you need to isolate a user or group of user to a specific
subsystem for these remote jobs, you can use

QSYS2.SET_SERVER_SBS_ROUTING:

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/QSYS2.SET_SERVER_SBS_ROUTING%28%29%20-%20procedure