Running LOAD RESUME YES (SQLAPPLY load)

For an SQLAPPLY load, the object that you are loading remains in read/write status while LOADPLUS loads the data by using SQL insert processing.

For this type of load, LOADPLUS uses the High-speed Apply Engine component of the BMC AMI Log Master for Db2 product. This feature does not require that you have a license for the BMC AMI Log Master product. However, the High-speed Apply Engine must be installed and made available through the STEPLIB, JOBLIB, or LINKLIST at runtime. The High-speed Apply Engine is installed separately from the BMC AMI Log Master product.

To run an SQLAPPLY load job

1. Ensure that a minimum of version 13.1.00 of the High-speed Apply Engine is available to LOADPLUS.

2. With your LOAD command, specify one of the following syntax options or the equivalent installation option:

   • RESUME YES SHRLEVEL CHANGE SQLAPPLY
   • RESUME YES SHRLEVEL CHANGE without PART n REPLACE

   Optionally, specify one or more of the options that are available with SHRLEVEL CHANGE SQLAPPLY. For information about these options, see SHRLEVEL.

3. Include an APTDUMP DD statement in your JCL.If High-speed Apply generates a SNAP dump in response to an error, High-speed Apply writes the dump to this data set. For more information, see APTDUMP-data-sets-in-LOADPLUS.
4. Use the information in Considerations for an SQLAPPLY load to make any necessary changes to your JCL or environment.