Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Copy for Db2 13.1.

Overview of BMC AMI Copy commands

NGT Copy provides the COPY command to create full or incremental table space or index copies.

NGT Copy also provides the COPY IMAGECOPY command to copy an existing image copy, and the RECALL command to reinstate a merged incremental copy. The QUIESCE command allows you to quiesce spaces without copying them. The OPTIONS command provides a runtime mechanism to override some of the NGT Copy installation options. The OUTPUT command describes the parameters used to dynamically allocate one or more output data sets. With the MODIFY command, you can maintain the contents of the SYSCOPY and BMCXCOPY tables. With the TEMPLATE command, you can use a template to make image copies of nonrecoverable spaces (using NGT Copy as the copy utility). This section describes the options available with those commands.

With the COPY command, you can:

  • Copy by table space, partition, or data set
  • Copy all data sets for an index space or only a single specified data set
  • Use a RECOVERY MANAGER object set as copy source
  • Use SAP R/3 application objects as copy source
  • Select the I/O method used to write the copy data sets
  • Specify the access allowed for concurrent applications and utilities
  • Quiesce the table space before and after the copy process
  • Perform page integrity checking
  • Let NGT Copy dynamically allocate output copy data sets
  • Make both primary and backup copies for your local and recovery sites
  • Specify whether to reset the modified-page indicators
  • Optimize incremental copy elapsed time
  • Let NGT Copy decide whether to make a full or incremental copy
  • Set boundaries for incremental copies, no copies, or escalation of a copy request to a full copy based on the number of changed pages
  • Perform object sets and multitasking for the copies
  • Specify how NGT Copy should handle unacceptable status or copy data sets already registered
  • Specify that full copies are stored differently than incremental copies
  • Specify that full copies that meet or exceed a specified size are stored in a different location
  • Gather and report statistics on a table space and update the DB2 catalog and the BMCSTATS table with the statistics
  • Specify that NGT Copy gathers statistics for the NACTIVE column of SYSIBM.SYSTABLESPACE
  • Specify whether NGT Copy is to resynchronize hardware mirrors after a Snapshot Copy

With the COPY IMAGECOPY command, you can:

  • Make backup and recovery site copies from a registered primary copy of a table space, index space, or a copy made using a RECOVERY MANAGER object set, or an SAP R/3 application as the copy source
  • Let NGT Copy dynamically allocate copy data sets
  • Specify the input copy RBA or log record sequence number (LRSN)
  • Perform page integrity checking for table spaces
  • Specify what NGT Copy should do if an image copy already exists
  • Make a standard copy, including a LP or RP copy registered in SYSCOPY, from an Instant Snapshot copy

With the EXPORT command, you can create a migration file for use in data migration with the NGT Recover MIGRATE and IMPORT commands. The EXPORT command creates a sequential file that contains table information about all selected table spaces for both BMCXCOPY and SYSCOPY.

Note

This command requires one of the following valid passwords:

  • A Recovery Management solution password
  • A Database Administration solution password

With the RECALL command, you can:

  • Reinstate a merged incremental copy that was retained in the DB2 catalog
  • Specify the start RBA value of the copy to be reinstated
  • Reinstate all incremental copies having the same start RBA value
  • Use the reinstated copy with NGT Recover or DB2 RECOVER
  • Indicate what NGT Copy should do if a space or partition is in an unacceptable status

With the QUIESCE command, you can:

  • Quiesce a table space without making a copy
  • Use a RECOVERY MANAGER object set as source
  • Use SAP R/3 application objects as source

With the OPTIONS command, you can override installation options for the current execution of NGT Copy including:

  • Maximum number of attempts to use a resource
  • Time to wait between attempts to use a resource
  • Maximum numbers of subtasks to use
  • Number of read/write buffers to use
  • How to set the space status for SHRLEVEL CONCURRENT copies
  • How many copies to register
  • The phase in which Snapshot Copies will be restarted
  • The XBM subsystem ID to be used for Snapshot Copies
  • Whether the XBM Utility Monitor is to be used
  • Number of days to keep entries in the BMC history table (BMCHIST)
  • Suppression of specific messages
  • Skipping migrated or archives spaces
  • How to handle index copies
  • Whether NGT Copy is to invalidate the dynamic SQL statement cache with RUNSTATS

With the OUTPUT command, you can dynamically allocate output copy data sets using options to:

  • Define tape data sets
  • Define disk data sets
  • Stack tape output
  • Specify that you want to make Instant Snapshots using intelligent storage devices
  • Specify that you want to make encrypted copies

Use the MODIFY command to:

  • Perform maintenance on entries in the SYSCOPY or BMCXCOPY table by using DELETE, INSERT, UPDATE, and VERIFY options

    Although a specific MODIFY command can use only one of these options, the command can include multiple occurrences of that option. Use these options for maintenance as follows:

    • Use DELETE to delete records from the SYSCOPY or BMCXCOPY table.
    • Use INSERT to insert entries in the SYSCOPY or BMCXCOPY table using a list of SYSCOPY or BMCXCOPY column conditions to specify the insertion criteria.
    • Use UPDATE to change the value of an existing SYSCOPY or BMCXCOPY column entry to a new, specified value. SET and WHERE keywords are used to indicate the new value and update criteria, respectively.

    • Use VERIFY to:

      • Detect when image copies in SYSCOPY or BMCXCOPY are not in the ICF catalog, and if they are not in the catalog, either delete the entry from SYSCOPY or BMCXCOPY or issue a warning message
      • Verify the recoverability of the specified table or index space, and if the space is unrecoverable, either issue a warning message or make a copy of the space. The recoverability is determined by checking for COPY-pending status and SYSCOPY or BMCXCOPY events.
      • Verify that there is a minimum number of copies registered in SYSCOPY or BMCXCOPY, and if not, either issue a warning message or make a copy of the space
      • Verify that the elapsed time since the last copy was made is not greater than a specified number of days, and if it is greater, either issue a warning message or make a copy of the space
      • Verify that the number of log data sets made since the last copy was made is not greater than a specified number, and if it is greater, either issue a warning message or make a copy of the space

      Note

      These analyses can be performed for the local site, the recovery site, or both.

  • Perform MODIFY operations for multiple table spaces, index spaces, RECOVERY MANAGER object sets, and application-owned objects, such as those in SAP R/3.
  • Use wildcards to specify the spaces
  • Specify spaces for exclusion from a specified operation
  • Vary the transaction commit rate
  • Specify conditions under which each row in the SYSCOPY or BMCXCOPY table may be modified

Note

If you use the MODIFY command for a table space where a COPY-pending condition was changed by a method other than by creating an image copy, the MODIFY command views this table space as unrecoverable and places it in COPY-pending status. (With the DELETE and VERIFY subcommands, you can use the NOCOPYPEND option to avoid this. See DELETE-subcommand-syntax-options and VERIFY-subcommand-syntax-options.)

With the TEMPLATE command, you can specify a copy template to be used to make a copy whenever a nonrecoverable copy condition is detected or when the verify conditions are outside user-defined thresholds specified by the MODIFY VERIFY command. The template specifies all of the NGT Copy options that you want to use to make the copy.

The remainder of this section describes the NGT Copy options that provide these capabilities.


 

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