DDL section of the DFSDFxxx member

The <SECTION=DDL> can be refreshed to customize the data set information before each DDL submission without an IMS shutdown.

DEDB area data sets are allocated automatically during CREATE DATABASE processing only when AUTOCREATE=YES is specified in the <SECTION=CATALOG> section of the DFSDFxxx PROCLIB member.

Parameters

The parameters of the DDL section of the DFSDFxxx member are described in the following list.

DSN=(cluster_name,db_type)

The definition of the VSAM cluster for the DEDB area. This parameter is required. You can specify a maximum of 44 characters and cannot use special characters, such as @, $, or #.

cluster_name

Name of the VSAM cluster. You can include the &DBNAME and &AREANAME symbols. If you include the &DBNAME or the &AREANAME symbol, or both, the data set name is generated by replacing the symbols with the database name and the area name.

db_type

Can be the following:

TYPEFP

Fast Path DEDB databases.

The following example shows a definition for the DSN= parameter:

DSN=(AAAAAAAA.&DBNAME.&AREANAME.BBBBBBBB.CCCCCCCC,TYPEFP)

DSNDATA=(data_component_name,db_type)

The definition of the data component. This parameter is optional. You can specify a maximum of 44 characters and cannot use special characters, such as @, $, or #.

data_component_name

Name of a VSAM data component. You can include the &DBNAME and &AREANAME symbols. If you include the &DBNAME or the &AREANAME symbol, or both, the data set name is generated by replacing the symbols with the database name and the area name.

db_type

If the DSNDATA= parameter is used, the following value is required for the db_type variable:

TYPEFP

Fast Path DEDB databases.

The following example shows a definition for the DSNDATA= parameter:

DSNDATA=(AAAAAAAA.&DBNAME.&AREANAME.BBBBBBBB.CCCCCCCC,TYPEFP)

SHARELVL=

Database data sharing level. The default value is 0.

CREATEOPTS=(CREPGM=YES|NO|Y|N)

Optional parameter. CREATOPTS=(CREPGM=YES|Y) is the default. This parameter creates options to be used at DDL Auto Create|Auto Import processing at DDL CREATE submission.

CREPGM=YES|Y

The default value. DDL Auto Create|Auto Import creates a runtime program definition of EMP types if such definition does not exist and Dynamic Resource Definition is enabled at DDL CREATE PROGRAMVIEW processing. Default program descriptor is used with BMPTYPE(Y) as override.

CREPGM=NO|N

DDL Auto Create|Auto Import does not create a runtime program definition if such definition does not exist and Dynamic Resource Definition is enabled at DDL CREATE PROGRAMVIEW processing.

Note: Default database descriptor is used with RESIDENT(Y) as override for DEDB databases.

Manual or IMS checkpoint-triggered EXPORT DEFN command must be used to export runtime database definition and runtime program definition created by DDL Auto Import so that they would be recovered across an IMS cold start.

CYLINDERS=

The amount of space in cylinders allocated to the area data set. This parameter is required when the area data sets are not managed by SMS. The maximum value is 16777215.

TRACKS=

The amount of space in tracks allocated to the area data set. This parameter is required when the area data sets are not managed by SMS. If CYLINDERS parameter is specified, this parameter is ignored. The maximum value is 16777215.

DATACLAS=

Data class for automatically generated, SMS-managed area data sets. If CYLINDERS or TRACKS are specified, the value will override the space values specified in the class.

MGMTCLAS=

Management class for automatically generated, SMS-managed area data sets.

PREALLOC=

This parameter is for DEDBs with SDEP defined. PREALLOC=NO|N is the default.

If PREALLOC=YES|Y, the data set must be empty. Otherwise, terminate data set creation for the DEDB with SDEP.

If the value is PREALLOC=NO\N for a DEDB with SDEP defined, you can use TRACKS= or CYLINDERS= for data set allocation. Both TRACKS= and CYLINDERS= are required for SDEP message that is not accurate.

PREALLOC=YES|Y

Users pre-allocate area data sets for newly DDL created DEDB with SDEP defined. The DDL auto data set creation will use the pre-allocated data sets for DEDB with SDEP. The pre-allocated data sets must be empty for DDL auto data set creation to use to format and register the area data sets to DBRC.

When DDL Auto Create detects ADS cluster with the same entry name, DDL Auto Create deletes existing cluster and defines new cluster if SDEP is not defined. If SDEP is not defined, the DDL does not define cluster and formats this ADS, or register the ADS to DBRC.

When a ADS cluster is defined, you must specify the following parameters to define a DEDB ADS with SDEP:

• CYLINDERS= or TRACKS=
• SMS class: DATACLAS= or STORCLAS= or MGMTCLAS

PREALLOC=NO|N

This is the default. Users do not pre-allocate area data sets for newly DDL created DEDB with SDEP defined. DDL auto data set creation will use CYLINDERS= or TRACKS= parameter in <SECTION=DDL> of DFSDFxxx PROCLIB for space allocation, formatting, and registering area data sets to DBRC.

When DDL Auto Create detects ADS cluster with same entry name, it stops processing this ADS.

When DEDB does not have SDEP, DDL deletes and defines a new area data set when a duplicate area data set is found.

DDL calculates SPACE of AREA data sets to be created when DEDB doesn't have SDEP. CYLINERS and TRACKS of DDL section of DFSDFxxx are usedwhen DEDB has SDEP.

STORCLAS=

Storage class for automatically generated, SMS-managed area data sets. Required for SMS-managed database data sets.

VOLUME=()

The volumes allocated for a DEDB area data set. You must use parentheses () to contain the values of this parameter, even if you specify only one volume. You can specify a maximum of 100 volumes. If you specify more than 100 volumes, only 100 volumes are used. This parameter is required when the area data sets are not managed by SMS.

The following example shows a VOLUME= parameter:

VOLUME=(vol1,vol2,vol3,,,,,)

or 

VOLUME=(vol1,
        vol2,
        vol3,
        ----
        voln)