Online Documentation for SQL Manager for DB2

Specifying LOB source

Use this step of the wizard to specify source directories for LOB, XML files, Vendor Sort, and other directories.

Specify paths to directories in which LOB files are to be stored | paths to directories in which XML files are to be stored | Vendor Sort work directories | Copy target paths, devices, or a shared library.

Items should be delimited with a comma. If you leave the fields empty, path for XML and LOB will be the directory specified at the Specifying data source and destination step.

You can type in the paths manually, or click the ellipsis button to open the Paths to directories... dialog.

Type in a path in the lower editable area or use the button to specify the path to the file using the Open dialog.

The dialog allows you to Add, Replace and Delete paths.

You can also reorder the paths in the list with the help of the buttons.

LOB location

Use the drop-down list to select the LOB data location: Client location, TSM (Tivoli Storage Manager) media, or Other.

Path name to be used on the server for temporary files

Specify the name of the path to be used when creating temporary files during a load operation. Note that the name should be fully qualified according to the server database partition.

Vendor location

Use the drop-down list to select the vendor library location: Client location, TSM (Tivoli Storage Manager) media, or Other.

Copy target location

Use the drop-down list to select the copy target location: Client location, TSM (Tivoli Storage Manager) media, or Other.

Click the Next button to proceed to the Specifying load parameters step of the wizard.