Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

SYSTEMPAGES

The SYSTEMPAGES option requires that image copies include header, dictionary, and system pages at the beginning of an image copy. The image copies are registered in SYSCOPY. The use of SYSTEMPAGES YES allows an UNLOAD utility to extract data from the image copy. It also facilitates recovery in cases where the recover utility needs SYSTEMPAGES to process versioned rows.

Related topic

Global-COPY-options

The following COPY commands use the SYSTEMPAGES option:

  • COPY TABLESPACE
  • COPY RMGROUP
  • COPY APPLICATION

The following COPY commands ignore the SYSTEMPAGES option:

  • COPY INDEXSPACE
  • COPY INDEX
  • COPY RMGROUPIX
  • MODIFY RECOVERY
  • COPY IMAGECOPY

BMC AMI Copy does not support the SYSTEMPAGES option in the following cases and issues the message BMC47320I OPTION IGNORED: SYSTEMPAGES:

  • For LOB spaces
  • For Instant Snapshot copies

You can use SYSTEMPAGES with the following SHRLEVEL values:

  • SHRLEVEL REFERENCE
  • SHRLEVEL CHANGE
  • SHRLEVEL CONCURRENT

SHRLEVEL CONCURRENT requires XBM and the SNAPSHOT UPGRADE FEATURE. BMC AMI Copy issues the message BMC47427E if these requirements are not met.

Values of SYSTEMPAGES

Value

Description

SYSTEMPAGES YES

SYSTEMPAGES YES is the default value.

SYSTEMPAGES NO

If you specify SYSTEMPAGES NO, BMC AMI Copy ignores the option and issues an informational message that SYSTEMPAGES NO is not supported.


 

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

BMC AMI Copy for Db2 13.1