Skip to Content

Copying LOB spaces with BMC AMI Copy

You can use the COPY command in 

BMC AMI Copy

 to copy LOB table spaces.

BMC AMI Copy supports native copying of LOBs for:

  • Full and incremental copies (FULL YES, FULL NO, FULL AUTO, and CHANGELIMIT)

    Warning

    Important

    Real-time statistics are used to know the percentage of changed pages for all types of spaces, including LOBs.

  • Instant Snapshot copies
  • COPY IMAGECOPY copies

Minimal page checking is performed.

If you request statistics (RUNSTATS YES) when you are copying a LOB space, BMC AMI Copy updates the SYSTABLESPACE and SYSTABLE statistics.

You can use the AUX option to specify if BMC AMI Copy should copy any auxiliary objects associated with the base table space. For more information, see the description of the AUX option in the OPTIONS command (OPTIONS-syntax-option-description) and as an installation option (AUX=NO).

Copying LOBs in BMC AMI Copy does not include support for RESETMOD YES. If you specify RESETMOD YES in your job, BMC AMI Copy calls the IBM Db2 COPY utility to make the copy.

 

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

BMC AMI Copy for Db2 13.1