tag:blogger.com,1999:blog-4516533711330247058.post1354991219090417125..comments2024-03-28T00:10:23.672-07:00Comments on Robert's Db2 blog: Statement-Level Control of DB2 for z/OS Query ParallelizationRoberthttp://www.blogger.com/profile/02058625981006623480noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4516533711330247058.post-17071726153981663552018-07-05T19:25:47.669-07:002018-07-05T19:25:47.669-07:00I am not sure of the ZPARM parameter to which you ...I am not sure of the ZPARM parameter to which you are referring. You do need to have OPTHINTS in ZPARM set to YES if you are going to use statement-level optimization settings such as DEF_CURR_DEGREE and MAX_PAR_DEGREE in the SYSIBM.SYSQUERYOPTS catalog table.<br /><br />If you have OPTHINTS in ZPARM set to YES (the default value is NO), and if you have a query for which DEF_CURR_DEGREE and MAX_PAR_DEGREE in SYSQUERYOPTS are set to ANY and (for example) 5, respectively, for the query in question parallelism will be enabled and the maximum degree of parallelism will be 5, regardless of the settings of the CDSSRDEF and PARAMDEG parameters in ZPARM.<br /><br />RobertRoberthttps://www.blogger.com/profile/02058625981006623480noreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-1972422945000173642018-06-26T09:36:23.461-07:002018-06-26T09:36:23.461-07:00Hi Robert,
Whil going through this article, I just...Hi Robert,<br />Whil going through this article, I just happened to think that would the dB2 level ZPARAM's be needed to be set in case we decide to use the Statement Level Control over Query Parallelization.Abhihttps://www.blogger.com/profile/13872629105923037207noreply@blogger.com