Running SHRLEVEL CHANGE CONSISTENT YES
To enable read or write access to your data during unload processing, UNLOAD PLUS uses the snapshot-processing features of
XBM
or
SUF
to unload a consistent image of the data.
This feature is available only when DIRECT YES is in effect.
XBM and SUF are licensed, installed, and maintained separately from UNLOAD PLUS. You can use either XBM or SUF, depending on the license that you have obtained:
- A license for the full version of the XBM product authorizes you to use all XBM features.
- A license for SUF authorizes you to use only the snapshot and zIIP-processing features of XBM.
For detailed information about XBM and SUF, see theEXTENDED BUFFER MANAGER for DB2 documentation.
To unload a consistent data image
- Ensure that a currently supported version of XBM or SUF is installed and available to UNLOAD PLUS.XBM and SUF require a started task.
- Create and activate the XBM management set that contains the appropriate snapshot object definition.
- Create and activate the XBM configuration that contains the appropriate cache attributes.For proper UNLOAD PLUS performance, ensure that XBM or SUF is configured with sufficient cache for the number of concurrent snapshots and the level of Db2 update activity at your site. For specific cache configuration information, see EXTENDED BUFFER MANAGER for DB2 documentation.
- Specify SHRLEVEL CHANGE CONSISTENT YES on your UNLOAD command statement.
- (Optional) To use a specific XBM subsystem, specify that subsystem ID with either the XBMID installation or command option.
- (Optional) Specify the WTOMSG option to write a message to the MVS log that indicates that snapshot-processing initialization for UNLOAD PLUS has successfully completed.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*