Authorities
and privilegesUse the DB2 for OS/390 Load Data Warehouse Center program to load records into one or more tables in a table space.
To load data into a table:
Specify information for your step:
In the Name field, you can type a new name for the step.
Otherwise, you can keep the name that the Data Warehouse Center
automatically supplied for the step. This field is required.
On the Parameters page, if you want to preformat pages in the table space and index spaces associated with the table, select the Entire table space and index spaces are preformatted check box to have the free pages between the high-used RBA (or page) to the high-allocated RBA be preformatted in the table space and index spaces associated with the table. The preformatting occurs after the data is loaded and the indexes are built.
Select the Specify RESUME option at table space level check box to specify whether records are to be loaded into an empty or non-empty table space.
Click NO
to load records into an empty table space.
If the table space is not empty, and you are not replacing contents
(the Reset table space and indexes to empty before load is not
checked), a DB2 for OS/390 message is issued, and the utility job
step terminates with a job step condition code of 8. For nonsegmented
table spaces, space occupied by rows that are marked as deleted or by
rows of dropped tables is not used.
If you want the newly loaded rows to replace all existing rows of all tables in the table space, and not just those of the table that you are loading, select the Reset table space and indexes to empty before load check box (LOAD REPLACE) .
Specify one of the Input data file type radio buttons to select the code page type for the input data. If you specify ASCII, numeric, date, time, and time stamp internal formats are not affected.
Select the Format of the input records check box to identify the format of the input record. The format should be compatible with DB2 unload format (UNLOAD) or with SQL/DS unload format. This action uniquely determines the format of the input. No field specifications are allowed in an INTO TABLE option.
Select the Allow no substitution characters in a string check box to prohibit substitution characters from being placed in a string as a result of a conversion. When this check box is selected and DB2 for OS/390 determines that a substitution character has been placed in a string as a result of a conversion, it performs one of the following actions:
If discard processing is active DB2 issues message DSNU310I and
places the record in the discard file.
Select the CCSIDs for the input file check box to specify up to three coded character set identifiers (CCSIDs) for the input data. Type a valid integer value in one or all of the fields. The default CCSID is the one you chose when you installed DB2 for OS/390. If any of the fields relating to the CCSID are left blank, the field will use the installation default. You can specify an SBCS, mixed DBCS (graphics and double byte character sets), or (double byte character set) data.
Select the Enforce check and referential constraints check box to have DB2 notify you when there are check constraints and referential constraints. When constraints are enforced, and the loading operation detects a violation, DB2 deletes the errant row and issues a message to identify it. If you select to enforce constraint and referential constraints exist, sort input and sort output data sets are required.
In the Maximum number of records to be written on discard data set field, specify a maximum number of source records to be written on the discard data set. The value can range from 0 to 2,147,483,647. If you reach the maximum number, LOAD processing abnormally ends, the discard data set is empty, and you cannot see which records were discarded. The default is 0, which means that there is no maximum. In this case, the entire input data set can be discarded.
Type the name of the discard data set in the Discard data set field. This is a work data set that is required if you specify a number of records to be discarded. This data set holds copies of records that did not get loaded. It also holds copies of records that were loaded, then removed. It must be a sequential data set that is readable by BSAM services. SYSDISC is the data definition name that is associated with the data set name.
Type the name of a work data set for error processing in the Error data set field. This data set stores information about errors that occur in the LOAD processing. This field is required if you specified a number of records to be discarded during load processing. SYSERR is the data definition name that is associated with the data set name.
Click the Advanced push button to open the DB2 for OS/390 Load Table Space notebook. From this notebook you can specify additional options for loading data into a table. You can also select to gather statistics for a table space, index, or both. The statistics are stored in the DB2 for OS/390| catalog.
On the Processing Options page, in the Agent Site list, select an agent site where you want your step to run. The selections in this list are agent sites that are common to the source tables, the target table, and the transformer or program that you are defining.
If you want to have the option to to run your step at any time, select the Run on demand checkbox. Your step must be in test or production mode before you can run it.
Optional: Select the Populate externally check box if the step is populated externally, meaning that it is invoked in some way other than by the Data Warehouse Center. The step does not have to have any other means of running in the Data Warehouse Center in order to change the mode to production.
If Populate externally is not selected, then the step must either have a schedule, be linked to a transient table that is input to another step, or be started by another program in order to change the mode to production.
In the Retry area, specify how many times you want the step to run again if it needs to be retried and the amount of time that you want to pass before the next run of the step.
Click OK to save your changes and close the step notebook.
Related information