Output data sets for GEN DDL

When you use the Db2® Admin Tool GEN function to generate DDL for objects in the Db2 catalog, you can choose to place the DDL in different types of output data sets.

Specifically, you can choose to place the DDL in:
  • An existing or new data set
  • An existing or new work statement list (WSL) data set

When you generate DDL for a large number of objects and specify that a new data set be used, either a regular data set or a WSL data set, the default space allocation that Db2 Admin Tool uses might not be sufficient.

If you are experiencing x37 abends on the output data set (either regular or WSL) for the generated DDL, use a preallocated data set instead of a new data set. Define the DDL output data set with the following attributes:
  • RECFM=FB
  • LRECL=80

The generated DDL for all the objects in an ERP system can get very large, for example, 3 million lines of statements. The GEN DDL output data set for that number of statements would require 287 cylinders. You can use ISPF option 3.2 to preallocate a large data set. A WSL data set must be a partitioned data set.