Data file attributes

Specify the name of the data set to use for the load utility. Specify additional options to connect to Db2® connector to perform bulk load jobs.

Input data files
Specify the properties for input data files for the load utility. If a data set name is specified, the data files are named as value.P#####, where value is the value in the data set name property and ##### is the partition number, padded with zeros. If a data set name is not specified, the data files are named based on the DSN prefix in the format prefix.IN.P#####. If the table that is loaded is not partitioned, the partition number is 00000.
Discard dataset properties
Specify the properties for discarding data sets for the load utility. If a data set name is specified, the discard files are named as value.P#####, where value is the value in the data set name property and ##### is the partition number, padded with zeros. If a data set name is not specified, the discard files are named based on the DSN prefix in the format prefix.DSC.P#####. If the table that is loaded is not partitioned, the partition number is 00000.
Error dataset properties
Specify the properties for error data set for the load utility. If a data set name is specified, the error files are named as value.P#####, where value is the value in the data set name property, and where ##### is the partition number, padded with zeros. If a data set name is not specified, the error files are named based on the DSN prefix in the format prefix.SYSERR.P#####. If the table that is loaded is not partitioned, the partition number is 00000.
Map dataset properties
Specify the properties for map data set for the load utility. If a data set name is specified, the map files are named as value.P#####, where value is the value in the data set name property, and where ##### is the partition number, padded with zeros. If a data set name is not specified, the map files are named based on the DSN prefix in the format prefix.SYSMAP.P#####. If the table that is loaded is not partitioned, the partition number is 00000.
Work1 dataset properties
Specify the properties for work1 data set for the load utility. This is a temporary dataset. If a data set name is specified, the temporary files are named as value.P#####, where value is the value in the data set name property, and where ##### is the partition number, padded with zeros. If a data set name is not specified, the temporary files are named based on the DSN prefix in the format prefix.WORK1.P#####. If the table that is loaded is not partitioned, the partition number is 00000.
Work2 dataset properties
Specify the properties for work2 data set properties for the load utility. This is a temporary dataset. If a data set name is specified, the temporary files are named as value.P#####, where value is the value in the data set name property, and where ##### is the partition number, padded with zeros. If a data set name is not specified, the temporary files are named based on the DSN prefix in the format prefix.WORK2.P#####. If the table that is loaded is not partitioned, the partition number is 00000.

All the data files and datasets include date and time placeholders, which are replaced with the actual date and time when the job runs. The date format is YYMMDD. The time format is HHMMSS. For example, if the value in the data set name property is USER1.DYYMMDD.THHMMSS and the job is run on 8 February 2010 at 10:21:24 a.m on a nonpartitioned table the data set name is: USER1.D100208.T102124.P00000.