Db2 Tools

NEW: Support for LISTDEF in RUNSTATS Action JCL

By Jakub Hofman posted 02-09-2021 10:35 AM

Support for LISTDEF in RUNSTATS Action CA Database Analyzer™ for DB2 for z/OS now supports the use of LISTDEF to execute RUNSTATS against a list of objects in one step. The generated action JCL contains a LIST keyword followed by the LISTDEF statement for each RUNSTATS control statement. A new model member (MJULDRS) and new automatic symbolics are provided to create action JCL to execute RUNSTATS on the objects defined in a LISTDEF. You can use LISTDEF to allow for greater concurrency during executions.
To take advantage of this feature, specify U (Update) in the Job Generation Parms field on the Build Extract Procedures panel, then specify Y (Yes) in the Order by Utility Codes field on the Job Generation Parms panel. You can use the new LISTDEF_STEP_LIMIT parameter to control the number of objects that are processed per step when you execute RUNSTATS with a LISTDEF. The LISTDEF_STEP_LIMIT parameter can be specified in the PDA parmlib member or the MJULDRS model member.

PTF that unlocks this enhancement: LU00145