RESETMOD

The RESETMOD option specifies whether to update each space map to clear all of the modified-page indicators in the table space. If you do not specify RESETMOD,

BMC AMI Copy

uses the value of the RESETMOD installation option, which defaults to NO.

Important

BMC AMI Copy ignores the RESETMOD option for indexes and TRACKMOD NO table spaces.

The RESETMOD option impacts the use of COPY syntax options as follows:

If you specify FULL AUTO or CHANGELIMIT with CUMULATIVE YES (the default), and you also specify SHRLEVEL NONE or SHRLEVEL REFERENCE, and the request escalates to FULL YES, BMC AMI Copy forces RESETMOD YES.
If you specify READTYPE FULLSCAN, you must use RESETMOD NO.
If you specify READTYPE AUTO and RESETMOD NO, BMC AMI Copy selects either random I/O or full table space scan. However, if you specify RESETMOD YES, BMC AMI Copy can select only random I/O (that is, the READTYPE FULLSCAN option is invalid with RESETMOD YES).
If you specify SHRLEVEL CONCURRENT, you must use RESETMOD NO.
For Instant Snapshots (DSSNAP YES or DSSNAP AUTO), you must use RESETMOD NO.

For more information, see Merging-incremental-copies and Optimizing-the-elapsed-time-for-an-incremental-copy.

For best performance, you should specify RESETMOD NO whenever possible. The RESETMOD NO option is particularly useful for table spaces that are routinely backed up with full image copies. Resetting-modified-page-indicators-RESETMOD provides more information.

For more information about using the RESETMOD option with the SHRLEVEL option, see Using-the-SHRLEVEL-option. Also, see Db2-commands-issued-by-BMC-AMI-Copy-for-read-and-write-databases, which describes table space status changes made by BMC AMI Copy for various scenarios involving the use of the RESETMOD and SHRLEVEL options.

Important

BMC AMI Copy ignores RESETMOD NO when you create copies of any of the following Db2 catalog and directory table spaces:

DSNDB06.SYSCOPY
DSNDB01.SYSUTILX
DSNDB01.DBD01
DSNDB01.SYSDBDXA

Refer to Copying-the-Db2-catalog-and-directory.

Value	Description
RESETMOD YES	RESETMOD YES specifies that each space map is updated to clear all of the modified-page indicators in the table space. Important The following items apply to RESETMOD YES: When RESETMOD YES applies, BMC AMI Copy issues a DB2 STOP command during the UTILTERM phase to clear the Db2 buffers, except for SHRLEVEL CHANGE copies. When you request incremental image copies and use RESETMOD YES, the space is not stopped when no pages are copied. When you use RESETMOD YES to make an incremental copy, that copy will not be merged with any subsequent incremental copy. If SLCHGRESET is NO, BMC AMI Copy runs the IBM Db2 COPY utility if a COPY command specifies RESETMOD YES and SHRLEVEL CHANGE for a TRACKMOD YES table space. If SLCHGRESET is YES, BMC AMI Copy makes the copy and resets the modified-page indicators natively. BMC AMI Copy ignores the RESETMOD option for indexes and TRACKMOD NO table spaces.
RESETMOD NO	When you specify RESETMOD NO, BMC AMI Copy does not update each space map to clear all of the modified-page indicators for the table space. This allows BMC AMI Copy to run faster if many pages have changed since the last time the modified-page indicators were reset. Refer to Merging-incremental-copies and Keeping-and-recalling-merged-incremental-copies for a discussion of the CUMULATIVE and KEEP options for incremental copies. You must specify RESETMOD NO or set the RESETMOD installation option to NO whenever you use SHRLEVEL CONCURRENT. You must specify RESETMOD NO or set the RESETMOD installation option to NO whenever you make Instant Snapshots (DSSNAP YES or DSSNAP AUTO). Important When RESETMOD NO is used to make incremental copies, BMC AMI Copy sets SHRLEVEL in SYSIBM.SYSCOPY to N for SHRLEVEL CHANGE copies or M for SHRLEVEL REFERENCE copies. However, Db2 treats both N and M as SHRLEVEL CHANGE. Warning If you perform a recovery using a copy made with RESETMOD NO, you must make a full copy using RESETMOD YES before making any more incremental copies using the default READTYPE RANDOM. Failure to do so might result in data loss.

Value

Description

RESETMOD YES

RESETMOD YES specifies that each space map is updated to clear all of the modified-page indicators in the table space.

Important

The following items apply to RESETMOD YES:

When RESETMOD YES applies, BMC AMI Copy issues a DB2 STOP command during the UTILTERM phase to clear the Db2 buffers, except for SHRLEVEL CHANGE copies. When you request incremental image copies and use RESETMOD YES, the space is not stopped when no pages are copied.
When you use RESETMOD YES to make an incremental copy, that copy will not be merged with any subsequent incremental copy.
If SLCHGRESET is NO, BMC AMI Copy runs the IBM Db2 COPY utility if a COPY command specifies RESETMOD YES and SHRLEVEL CHANGE for a TRACKMOD YES table space. If SLCHGRESET is YES, BMC AMI Copy makes the copy and resets the modified-page indicators natively. BMC AMI Copy ignores the RESETMOD option for indexes and TRACKMOD NO table spaces.

RESETMOD NO

When you specify RESETMOD NO, BMC AMI Copy does not update each space map to clear all of the modified-page indicators for the table space. This allows BMC AMI Copy to run faster if many pages have changed since the last time the modified-page indicators were reset. Refer to Merging-incremental-copies and Keeping-and-recalling-merged-incremental-copies for a discussion of the CUMULATIVE and KEEP options for incremental copies.

You must specify RESETMOD NO or set the RESETMOD installation option to NO whenever you use SHRLEVEL CONCURRENT.

You must specify RESETMOD NO or set the RESETMOD installation option to NO whenever you make Instant Snapshots (DSSNAP YES or DSSNAP AUTO).

Important

When RESETMOD NO is used to make incremental copies, BMC AMI Copy sets SHRLEVEL in SYSIBM.SYSCOPY to N for SHRLEVEL CHANGE copies or M for SHRLEVEL REFERENCE copies. However, Db2 treats both N and M as SHRLEVEL CHANGE.

Warning

If you perform a recovery using a copy made with RESETMOD NO, you must make a full copy using RESETMOD YES before making any more incremental copies using the default READTYPE RANDOM. Failure to do so might result in data loss.

RESETMOD

On this page