Skip to Content

The IBM LOAD utility

Related topics

Load utilities options

You can use the IBM LOAD utility to perform the following functions:

  • Build image copies and gather statistics
  • With the BASIC UNLOAD, UNLOAD PLUS, or IBM UNLOAD utility, unload and load objects that are defined as Unicode
  • With the IBM UNLOAD utility, unload and load data contained in LOB and XML columns

When you select IBM LOAD LOG NO, the product uses the IBM LOAD utility and inserts the IBMLOAD keyword into the ALUIN input stream. When the work ID is analyzed, Analysis inserts the -LOAD command into the worklist.

Warning

Important

If a table space is being created in the worklist, Analysis includes the REUSE parameter in the -LOAD command.

When you select IBM LOAD LOG YES so that you can log the loaded records, the product also inserts the LOG keyword into the ALUIN input stream.

Error
Warning

If you are using spanned records, you cannot multitask the unloading and loading of data.

If you are using a tape data set for SYSUT work data sets with IBM LOAD, you must manually edit the worklist and JCL to ensure that multiple instances of LOAD use unique work data sets for ddnames.

Load Unicode, LOB, and XML data

ALTER and BMC AMI Change Manager for Db2 can use the unload and load utilities shown in Unload Unicode LOB and XML data.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

ALTER and BMC AMI Change Manager for Db2 13.1