Db2 Tools

 View Only

NEW: CA Database Analyzer™ for Db2 for z/OS Enhanced with Support for LISTDEF for Multiple Action Procedures and Utility Codes

By Jakub Hofman posted Aug 27, 2021 04:59 AM

We are pleased to announce that CA Database Analyzer™ for DB2 for z/OS now supports the use of LISTDEF to generate JCL to execute multiple utilities in the order that you specify. Each utility uses one or more steps in the generated action JCL to process the specified list (or lists) of objects. Previously, you could only select one utility code and tie one action procedure to an extract procedure to take advantage of LISTDEF statements. Now, you can select multiple utility codes in one action procedure, or can tie multiple action procedures (that include multiple utility codes) to an extract procedure.

The Db2 Image Copy (IC), REORG (RO), and RUNSTATS (RS) utility codes are supported. In addition, the user application (US) utility code can be used to process all the selected tablespaces and indexes in one list. A new model member (MJULDUS) is provided to copy and customize for use with the US utility code.

LISTDEF statements allow for increased concurrency during executions, greater flexibility, and time-savings.

PTF that unlocks this enhancement is LU02455.