Shows the target tables defined for the table space. To add a table to this list, click Add. To modify a table, select it and then click Change.
Shows the fields defined for the table. You can view the field definitions or select a field that you want to modify. To add a field to this table, click Add. To modify a field, select it and then click Change.
Shows a list of tables from which to collect statistics. To add a table click Add. To change options for a table click Change. To delete a table from the list click Remove.
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.
Opens a window so that you can add a new target table to the list.
Opens a window so that you can add a new target table to the list.
Removes a target table from the list.
Opens a window so that you can add a new field to the selected target table.
Opens a window so that you can change a field in the selected target table.
Removes a field specification from the selected table.
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.
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.
Select YES to load records into a non-empty table space, or NO to load records into an empty table space.
Replaces existing rows in all tables in the table space with newly loaded rows. (LOAD REPLACE)
If you reset the table space, check here to keep the compression dictionary, (KEEPDICTIONARY). If you do not check this box, a new dictionary will be built.
Check to load data into non-empty data sets. The data sets must be defined as VSAM REUSE.
Preformats table spaces and index spaces up to the high allocated RBA.
Check to write log records during the load process.
Select to ensure the utility will delete rows that have errors, and issue an error message.
Select to specify a format for input records.
Select to format input records to be compatible with DB2 unload format.
Select to format input records to be compatible with SQL/DS format.
Select to specify code page data type ASCII.
Select to specify code page data type EBCDIC.
Select to specify up to three coded character set identifiers.
Select to specify the number of sort keys.
Select to specify a continuation string for long records.
Select to define a character string.
Select to define a hexadecimal string.
Select to run statistics for the table space. The select the options you want from the statistics pages of this notebook.
Select to specify DFSORT temporary data sets.
Select to collect statistics. Output is sent to SYSPRINT.
Select if you do not want statistics to be generated.
Select to place into the catalog table all collected statistics information for this table space.
Select to place into the catalog table only those statistics for access path selection.
Select to place into the catalog table only those statistics that help assess the status of a table space or index .
Select if you do not want statistics placed into the catalog tables.
Select to specify tables from which statistical information is to be gathered.
Select to gather information for all tables in the table space.
Select to gather information for tables you list in the Table options list on this page.
Select to specify indexes from which statistical information is to be gathered.
Select to gather information for all indexes in the table space.
Select to gather information for indexes you list in the Index options list on this page.
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.
Type an integer value for the estimated number of sort keys. The default is O.
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 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.
Allocate space compatible for your 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.
Allocate space compatible for your 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.
Allocate space compatible for your 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.
Allocate space compatible for your 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.
Allocate space compatible for your 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.
Allocate space compatible for your 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.
Allocate space compatible for your 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.
Allocate space compatible for your 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.
Allocate space compatible for your 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.
Allocate space compatible for your device.
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.
Specify a device type for dynamically allocated data sets. Use any device type that is acceptable to the DFSORT DYNALLOC parameter of the SORT or OPTION options.
Type the number of dynamically allocated temporary data sets for DFSORT.
Type the name of a sequential, BSAM data set that contains data to be loaded. The default is SYSREC.
Type the name of a sequential, BSAM data set to use as a local primary copy data set. The default is SYSCOPY.
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. The default is SYSUT1.
Type the name of the temporary work files for the sort output data set. The default is SORTOUT.
Type the name of a work data set that will store information regarding errors during load processing. The default is SYSERR.
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.