BMC AMI Unload DD statements

ULDPARMS DD statement

This DD statement is required only to override the BMC AMI Unload parameters (ULDPARMS) specified during installation. You can specify ULDPARMS in a data set or in the JCL. 

For more information about ULDPARMS, see BMC-AMI-Unload-parameters-ULDPARMS-DD.

UTLPARMS DD statement

This DD statement is required only to override BMC AMI Utilities global parameters (UTLPARMS) specified during installation. You can specify UTLPARMS in a data set or in the JCL. 

For more information about UTLPARMS, see Global product parameters (UTLPARMS).

SYSREC and SYSRED DD statements

The SYSREC DD statement and the optional SYSRED DD statements specify the unload output data sets. You can override this DD name using the UNLOADDN option on the UNLOAD command. The default value is SYSREC.

Instead of providing a data set name with the DD statement, you can dynamically allocate the data set by using one of the following methods. The value of the OVERRIDEOUTPUT parameter determines which method BMC AMI Unload uses.

• Providing the data set name in the XULDDYNM-unload-data-set-and-discards-automation-control-point
• Providing the data set name in an BMC-AMI-Unload-OUTPUT-command in your unload SYSIN (placing the OUTPUT command before any UNLOAD commands that reference it).

If you plan to use multiple unload data sets with the UNLOADDNPFX keyword, see the UNLOADDNPFX keyword on the UNLOADDN page.

For information about unloading partitions to multiple data sets, see Unloading-partitions-in-partitioned-table-spaces-to-multiple-data-sets.

SYSCNTL and SYSPUNCH DD statements

SYSCNTL (default for the UNLOAD command and for UNLOAD PLUS for DB2 ) and SYSPUNCH (default for the UNLD command and IBM UNLOAD utility) are the DD names to which BMC AMI Unload writes the output LOAD statement. You can write this statement to either a sequential data set or to a SYSOUT class. 

When you specify multiple unload data sets, the ddname that you specify becomes the ddname prefix. For UNLOAD, when you unload partitions, you should specify a single SYSCNTL DD statement or OUTPUT SYSCNTL command. 

Considerations

Consider the following information about using SYSCNTL data sets:

• We recommend that you do not use a partitioned data set (PDS).
• If you use an external server, then you must use the OUTPUT statement to allocate the SYSCNTL file instead of using a //SYSCNTL DD statement.
• For UNLOAD, when you unload partitions, you may specify a single SYSCNTL DD statement or OUTPUT SYSCNTL command and BMC AMI Unload will generate a LOAD statement for all partitions. 
• To override the default ddname, use the CNTLDDN keyword.
• If you specify data control block (DCB) attributes, you must specify one of the following sets of attributes:
  • For fixed-length data sets, RECFM can be F, FB, or FBS. The logical record length (LRECL) must be a minimum of 80 bytes.
  • For variable-length data sets, RECFM can be V or VB. LRECL must be a minimum of 84 bytes.
• If you do not specify DCB attributes, BMC AMI Unload uses DCB=(RECFM=FB,LRECL=80,BLKSIZE=3120).
• For UNLOAD, if you omit any allocation of SYSCNTL (or other ddname if CNTLDDN is used), Unload does not allocate an output data set or generates a LOAD statement unless the XULDDYNM automation routine sets ALLOC_SYSPUNCH='Y'.
  

Using multiple SYSCNTL data sets with multiple SELECT statements

If you want to unload multiple tables, the recommended approach is to use individual UNLOAD statements. If you have existing JCL that uses multiple SELECT statements in an UNLOAD command, you can also specify multiple SYSCNTLn DD statements or OUTPUT SYSCNTLn commands. 

Specify a numbered ddname such that the numeric suffix corresponds with the first, second, third, and so forth SELECT statements in the UNLOAD command. When unloading a SELECT statement that does not have a corresponding data set in the JCL, and you have specified CNTLCARDS, BMC AMI Unload puts the corresponding control cards in the default data set, SYSCNTL.

NGTAUTO DD statement

If you are using automation control points with your job, you can specify an NGTAUTO DD statement to override the default data set (specified during configuration or with the NGTAUTO1 or NGTAUTO2 parameter).

This statement should reference a partitioned data set containing the automation exits that you wish to use. 

For more information about BMC AMI Utilities global parameters, see Global product parameters (UTLPARMS).