Another July 2013 Performance Article - DB2 for z/OS CPU Query Parallelism and IIPHONORPRIORITY

In this article Jeff Lane presents a real life situation in which parallelism presented a performance dilemma. Do you tune for response time or reduced cost? 

"Would you ever think that binding your on-line packages with DEGREE=ANY would cause your transactions to increase in elapsed time?  Well it’s not just binding with DEGREE=ANY but a combination of available processors (GPs & zIIPs), and z/OS settings which can contribute to increasing transaction elapsed times."

Download the article here:

http://www.idug.org/p/do/sd/sid=5485&type=0

View the entire Content Committee file library here:

http://www.idug.org/p/do/si/topic=428&type=0

1 Comment

What are the impact if we change Degree(1) to DEGREE(ANY) parameter for package

June 15, 2017 06:16 AM by JITINDER CHOUDHARY

If we change DEGREE(1) to DEGREE(ANY) is there any impact on dynamic sql queries. Or can we use DEGREE(ANY) with dynamic sql queries?

Please suggest.

Thanks and regards,

Jitinder Choudhary

Recent Stories
The High Availability and Resiliency Architecture in Db2 Warehouse on Cloud

Implementation of Db2 11.1 HADR with TSA in the RedHat system

IBM Db2 LUW on the Amazon AWS Cloud, a primer