Select YES to load records into a non-empty table space, or NO to load records into an empty table space.
Specify YES or NO to load data into a non-empty or empty table space, respectively. If NO is specified, and the target table is not empty and you have not used REPLACE, a message is issued and the utility job step terminates with a job step condition code of 8.
Select to replace existing rows in all tables in the table space with newly loaded rows. (LOAD REPLACE)
If you reset the table space, select this check box to keep the compression dictionary, (KEEPDICTIONARY). If you do not select this check box, a new dictionary will be built.
Select this to load data into nonempty data sets. The data sets must be defined as VSAM REUSE.
Select this to reformat table spaces and index spaces up to the high allocated RBA.
Select to write log records during the load process.
Select this if LOAD should set the table space in the COPY pending status, whether or not LOG NO was specified. If your data in the table space can be easily recreated by another LOAD if your data is lost, you do not need to set the COPY pending status. It is recommended to set the copy pending state.
Select to ensure the utility will delete rows that have errors, and issue an error message.
Select to specify a format for input records.
Specify this to format input records to be compatible with DB2 unload format.
Specify this to format input records to be compatible with SQL/DS format.
Select to specify a format for input records that are floating point values.
Specifies that LOAD is to expect that floating point numbers are provided in System/390� hexadecimal Floating Point (HFP) format. This is the format that DB2 stores floating point numbers in, and is the default if you do not explicitly specify the FLOAT keyword.
Specifies that LOAD is to expect that floating point numbers are provided in IEEE Binary Floating Point (BFP) format. DB2 converts the BFP data to hexadecimal floating point format as the data is being loaded into the DB2 table. If a conversion error occurs while converting from BFP to HFP, DB2 places the record in the discard file.
Specifies that code page data type is ASCII.
Specifies that code page data type is EBCDIC.
Select to specify up to three coded character set identifiers.
Type a valid integer value for a single byte character set.
Type a valid integer value for a graphics and double byte character set.
Type a valid integer value for a double byte character set.
Select to specify the number of sort keys.
Type an integer value for the estimated number of sort keys. The default is 0.
Select to specify a continuation string for long records.
Type the start column number for the continuation string.
Type the end column number for the continuation string.
Type a character string to use as the continuation string.
Type a hexadecimal string to use as the continuation string.
Specify this to define a character string.
Specify this to define a hexadecimal string.
Select to specify that LOAD will not accept substitution characters in a string.
Select to run statistics for the table space. Then specify the options you want from the statistics pages of this notebook.
Type the name of a sequential, BSAM data set that contains data to be loaded. SYSREC is the data definition (DD) name that is associated with this data set name.
Type the name of a sequential, BSAM data set to use as a local primary copy data set. SYSCOPY is the data definition (DD) name that is associated with this data set name.
Type the name of a sequential, BSAM data set to use as a local backup copy data set.
Type the name of a sequential, BSAM data set to use as a primary copy data set at a recovery site.
Type the name of a sequential, BSAM data set to use as a backup copy data set to use at a recovery site.
Type the name of the temporary work files for the sort input data set. SYSUT1 is the data definition (DD) name that is associated with this data set name.
Type the name of the temporary work files for the sort output data set. SORTOUT is the data definition (DD) name that is associated with this data set name.
Type the name of a work data set that will store information regarding errors during load processing. SYSERR is the data definition (DD) name that is associated with this data set name.
Type the name of a work data set that will map the identifier of a table row back to the input record that caused an error.
Type the name of a sequential, BSAM data set that will contain copies of records that did not get loaded, and records loaded and then removed.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.
Type the maximum number of records to be written in the discard data set. The value can range from 0 to 2147483647. The default is 0.
Optional: Specify a device type for temporary data sets to be dynamically allocated by DFSORT. It can be any device type acceptable to the DYNALLOC parameter of the SORT or OPTION control statement for DFSORT. For example, if you do not specify a device type in this field and a sort is required, you must provide the DD statements that the sort program requires for the temporary data sets.
Type the number of dynamically allocated temporary data sets for DFSORT.
Select to specify DFSORT temporary data sets.
Shows the target tables defined for the table space. To add a table to this list, click the Add push button. To modify a table, select it and then click the Change push button.
Shows the characteristics of specific fields in the target table. You can view the field definitions or select a field that you want to modify. To add a field to this table, click the Add push button. To modify a field, select it and then click the Changepush button.
Opens a window so that you can add a new target table to the list.
Opens a window so that you can change a target table in the list.
Removes a target table from the list.
Opens a window so that you can add a new field specification to the selected target table.
Opens a window so that you can change some characteristics of a field in the selected target table.
Removes a field specification from the selected table.
Specifies to output to SYSPRINT the set of messages that report the statistics.
Specifies that the set of messages that report the statistics is not output to SYSPRINT. This is the default.
Specify this to place into the catalog table all collected statistics information for this table space.
Specify this to place into the catalog table only those statistics for access path selection.
Specify this to place into the catalog table only those statistics that help assess the status of a table space or index.
Specify this if you do not want statistics placed into the catalog tables.
Select this to specify tables from which statistical information is to be gathered.
Specify this to gather information for all tables in the table space.
Specify this to gather information for tables you list in the Table options list on this page.
Shows a list of tables from which to collect statistics. To add a table click the Add push button. To change options for a table click the Change push button. To delete a table from the list click the Remove push button.
Opens a window so that you can add a table to the list.
Opens a window so that you can change the options of a table.
Removes a table from the Table options list.
Select to specify indexes from which statistical information is to be gathered.
Specify this to gather information for all indexes in the table space.
Specify this to gather information for indexes you list in the Index options list on this page.
Shows a list of indexes from which to collect statistics. To add an index click the Add push button. To change options for an index click the Change push button. To delete an index from the list click the Remove push button.
Opens a window so that you can add an index to the list.
Opens a window so that you can make changes to an index in the list.
Removes an entry from the Index options list.
Submits the data in the notebook and closes the notebook. Available only when the required fields are completed.
Displays the SQL statements that are generated by your choices in this notebook.
Cancels any unsaved changes that you made and closes this notebook.