UNLOAD PLUS data sets
This topic briefly describes the data sets that UNLOAD PLUS uses.
You can override some of the ddnames or ddname prefixes with UNLOAD command options. For more information about how to specify the DD statement names and data set allocation sizes, and when the data sets are required, see UNLOAD-PLUS-DD-statements.
Data sets for DIRECT YES
The following table lists the data sets that UNLOAD PLUS uses when DIRECT YES is in effect.
Data set or ddname | Description | Reference |
|---|---|---|
BMCFORCE | BMCFORCE is an optional data set that contains the thread cancelation report that is generated when you specify either FORCE REPORTONLY or FORCE_RPT YES. | |
DDLIN | DDLIN is an optional input data set for the DDL that defines all of the objects that are related to the table from which UNLOAD PLUS unloads rows. UNLOAD PLUS uses the DDL for Db2 object definitions instead of object definitions in the Db2 catalog when you use the INFILE ddname option to unload data. | |
Input copy data sets | You can optionally specify a copy data set (full image copy or incremental image copy, DSN1COPY data set, or inline copy data set), instead of a Db2 table space, from which you want UNLOAD PLUS to unload rows. | |
Referenced files | These files are output files that you reference in your unload data sets. You unload LOB or XML data to these files instead of to your unload data sets. | |
SORTWKnn | SORTWK is the data set that BMCSORT uses. The data set is used in the UNLOAD phase to sort unloaded rows. You cannot allocate the sort work files as VIO data sets or tape data sets. You must allocate each individual work file on a single DASD unit. | |
SYSCNTLn | SYSCNTL is the output data set that contains the control statements that UNLOAD PLUS generated for the unloaded data. UNLOAD PLUS requires the n value only if you specify multiple data sets. | |
SYSIN | SYSIN is the input data set that contains the UNLOAD command. | |
SYSPRIN2 | SYSPRIN2 is an optional output data set that contains the same UNLOAD PLUS messages that are output to SYSPRINT. In a worklist environment, SYSPRIN2 enables you to view UNLOAD PLUS output in real time. | |
SYSPRINT | SYSPRINT is the output data set that contains UNLOAD PLUS messages. | |
SYSRECnn | SYSREC is the output data set that contains the unloaded rows. UNLOAD PLUS requires the nn value only if you specify multiple data sets. Throughout this book, the primary output unload data set is referred to as a SYSREC data set. The name that you use for SYSREC is different if you change it in the installation options module or override it by using the UNLOADDN option. | |
SYSREDnn | SYSRED is an optional secondary output data set that contains the unloaded rows. UNLOAD PLUS requires the nn value only if you specify multiple data sets. Throughout this book, the secondary output unload data set is referred to as a SYSRED data set. The name that you use for SYSRED is different if you change it in the installation options module or override it by using the UNLOADDN option. | |
UTPRINT | UTPRINT is the data set that indicates that sort messages should be reported. The actual messages for each sort process appear in separate SYSnnnnn data sets, where nnnnn is a system-assigned sequential number. This data set is required by any phase that performs a sort. | |
VSAMDDnn | VSAMDD is an optional VSAM linear data set from which UNLOAD PLUS unloads rows instead of the Db2 table space. UNLOAD PLUS requires the nn value only if you specify multiple data sets. The default ddname, VSAMDD, supports up to 99 partitions. For more than 99 partitions, or to use a ddname other than VSAMDD, you can use the VSAMDDPREFIX option. |
Data sets for DIRECT NO
The following table shows the data sets that UNLOAD PLUS uses when DIRECT NO is in effect.
Data set | Description | See page |
|---|---|---|
Referenced files | These files are output files that you reference in your unload data sets. You can unload LOB or XML data to these files instead of to your unload data sets. | |
SYSCNTLn | SYSCNTL is the output data set that contains the control statements that UNLOAD PLUS generates for the unloaded data. UNLOAD PLUS requires the n value only if you specify multiple data sets. | |
SYSIN | SYSIN is the input data set that contains the UNLOAD command. | |
SYSPRIN2 | SYSPRIN2 is an optional output data set that contains the same UNLOAD PLUS messages that are output to SYSPRINT. In a worklist environment, this data set enables you to view UNLOAD PLUS output in real time. | |
SYSPRINT | SYSPRINT is the output data set that contains UNLOAD PLUS messages. | |
SYSRECnn | SYSREC is the output data set that contains the unloaded rows. UNLOAD PLUS requires the nn value only if you specify multiple data sets. | |
SYSREDnn | SYSRED is an optional secondary output data set that contains the unloaded rows. UNLOAD PLUS requires the nn value only if you specify multiple data sets. |