Data set allocation for a DSNUTILB load


When LOADPLUS invokes DSNUTILB, you must enable dynamic allocation for all work data sets that the load job requires by specifying ACTIVE YES for those DDTYPEs.

If you specify COPY YES, you must also specify ACTIVE YES for your copy data sets. If you specify any copy or work file data sets in your JCL, LOADPLUS ignores them, regardless of your IFALLOC specification.

With the exceptions described in the following table, LOADPLUS uses your dynamic allocation options to generate a TEMPLATE control statement for each data set. LOADPLUS then passes these TEMPLATE statements to DSNUTILB for data set allocation.

The following table describes the dynamic allocation options considerations for a DSNUTILB load:

Command option

Considerations

ACTIVE

Requires a value of YES for all work file DDTYPEs (and for your copy data sets if you specify COPY YES)

If ACTIVE is NO, LOADPLUS issues message BMC50179E or BMC50181E and terminates.

AVGVOLSP

Ignores this option

DSNPAT

Converts symbolic variables when an equivalent exists

If you specify a symbolic variable that does not have an equivalent, you will receive a DSNUTILB error. For information about which symbolic variables are converted, see DSNPAT.

Also, be aware that user-defined variables are not valid for a DSNUTILB load.

DSNTYPE

Ignores this option

IFALLOC

Ignores this option

If you specify DD statements in your JCL for any of the data sets required for this job, LOADPLUS ignores them. If your JCL contains a data set with the same name as the one that LOADPLUS generates for dynamic allocation, you might encounter a contention error.

MAXEXTSZ

Translates this option to the MAXPRIME keyword of the TEMPLATE control statement

SIZEPCT

Translates this option to the PCTPRIME keyword of the TEMPLATE control statement

If you specify a value greater than 100, LOADPLUS converts it to 100.

SPACE

Required for all dynamically allocated DDTYPEs that are assigned to tape. If you do not specify a SPACE value, DSNUTILB reports message DSNU1036I Unable to estimate space requirements for DDTYPE.

THRESHLD

  • For copy data sets, translates this option to a LIMIT value in the TEMPLATE control statement

    LOADPLUS also builds the secondary TEMPLATE control statement to which the IBM Db2 LOAD utility will switch when the LIMIT value is exceeded.

  • For all other data sets, ignores this option

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

LOADPLUS for DB2 13.1