SYNC

You can use this information to determine how far the load job has progressed.

By default, LOADPLUS writes BMCSYNC records only after loading the last row or key in a table space, index, or partition. If you want records written more often, specify an integer with the SYNC option to identify the number of 1-KB rows that you want LOADPLUS to process between writing to the BMCSYNC table.

Additional considerations

Note the following additional information about the SYNC option:

• LOADPLUS records monitoring and restart sync points in the BMCSYNC table as the job progresses. You can issue an SQL statement to query this table to determine how far the load has progressed and the status of the objects that you are loading.
• The SYNC option does not control the sync points that are used to restart LOADPLUS. The restart sync points are established only after LOADPLUS loads the last row or key in a table space, index, or partition.
• LOADPLUS ignores this option when either of the following conditions exists:
  • You are running an SQLAPPLY load.
  • LOADPLUS is invoking DSNUTILB.