SYNC

Specify an integer with the SYNC option to identify the number of 1-KB rows that you want UNLOAD PLUS to process between writing to the BMCSYNC table.

Related topic

Basic-processing-options

SYNC.png

This option is meaningful only when DIRECT YES is in effect.

UNLOAD PLUS writes records to the BMCSYNC table that show the number of 1-KB rows that UNLOAD PLUS processed during the UNLOAD phase. You can use this information to determine how far the UNLOAD job has progressed. By default, UNLOAD PLUS writes records only after the last row is read or unloaded from a table space.

UNLOAD PLUS records monitoring 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 unload has progressed and the status of objects that the utility is unloading.

Restriction

UNLOAD PLUS ignores this option when DIRECT NO is in effect.

  

 

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