DDL Generation Batch utility enhancement

The DDL Generation Batch utility is used to generate CREATE DDL statements, which can then be used to define databases and program views within IMS, as well as provide programmable and automated solutions for IMS. The DDL generation batch utility also goes by the shorter name of zDDL batch utility.

The DDL Generation Batch utility is included with the IMS Universal JDBC driver and uses type-4 connections. The IBM® Java™ for z/OS® (JZOS) Batch Launcher must be used to run the DDL Generation Batch utility.

Requirements

Ensure you have met the following requirement before using the DDL Generation Batch utility:

Resources that you intend to use with the DDL generation batch utility must be specified to IMS. If you do not specify all resources properly, IMS will generate many OLDs of logs for each execution of the DLL generation batch utility.

Restrictions

The following restriction must be considered while using the DDL Generation Batch utility:

If you use a wildcard for the DBDSRC or PSBSRC input statement, the corresponding DBDSRC DD or PSBSRC DD statements can only contain a single data set.

Changes to troubleshooting for IMS

Errors may be returned by the JZOS Batch launcher or by the DDL Generation Batch utility during operation of the utility. These errors are explained in detail within DDL Generation Batch utility.

Documentation changes

The following table lists the publications that contain new or changed topics for the DDL Generation Batch utility enhancement. Publications that are not impacted by this enhancement are not included in the table.