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.

QUIESCE command


You can use the QUIESCE command to establish a quiesce point for a table space, partition, or list of table spaces and records the quiesce point in the SYSIBM.SYSCOPY table. The quiesce points establish recovery points for use in point-in-time recovery. 

BMC AMI Copy

 attaches to the Db2 QUIESCE utility to perform the quiesce.

The authorization for performing a quiesce is the same as that used for making a copy.

The BMC AMI Copy QUIESCE command can run concurrently with other BMC utilities that use SHRLEVEL S or blank, but cannot run concurrently with other BMC AMI Copy jobs against the same space. The QUIESCE command sets SHRLEVEL S and ORIG_STATUS as NULL.

Spaces to be quiesced can be in one of the following statuses:

  • RW
  • RO
  • UT
  • UTRW
  • UTRO—If it is in UTRO, the space is sent to the Db2 QUIESCE utility, but might fail based on its rules for concurrency.
  • UTUT—If it is in UTUT and you have specified UTRETRY=YES, BMC AMI Copy will wait and retry.

Important

No other statuses are allowed.

Using QUIESCE does not directly modify the status of the table space, although the QUIESCE utility acquires an S lock on the space and puts the space in UTRO status.

When using the BMC AMI Copy QUIESCE command, DB2WAIT and DB2NTRY, as set in the installation options or on the OPTIONS statement, are used to perform waits and retries on failures.

When using the BMC AMI Copy SOFT QUIESCE YES, DRAINWAIT, and DRAINDELAY are used along with DRAINRETRY.

BMC AMI Copy bypasses the table space if the VSAM data set does not exist due to the use of the DEFINE NO option in Db2.

Catalog and directory spaces can be quiesced but SYSUTILX cannot be quiesced in a group, so it must be specifically excluded.

The following figure shows the syntax for the QUIESCE command with default values underscored.

When you use the QUIESCE command in the utility job input, these rules apply:

  • The first keyword you specify must be either TABLESPACE, RMGROUP, OBJECTSET, or APPLICATION.
  • You can specify keywords shown in the Object Options in any order.
  • You can specify keywords shown in the QUIESCE syntax in any order.
  • A single data set of a multi-data-set, nonpartitioned space cannot be quiesced.
  • If you do not specify an option that is required during processing, BMC AMI Copy uses the default value of that option.
  • You cannot split a token, such as a keyword or identifier, across lines.
  • An asterisk in column 1 in the SYSIN data set specifies that the line is a comment that will not be echoed in the SYSPRINT output. A double hyphen (--) coded in column 1 through 70 also makes the rest of the line a comment.
  • TABLESPACE values follow the same rules used for COPY TABLESPACE. The TABLESPACE specification can include wildcards or it can be a list.
  • A single QUIESCE command can be followed by multiple TABLESPACE specifications. This allows you to group and use a different value per TABLESPACE for the following options:

    • DSNUM (not applicable to RMGROUP or OBJECTSET)
    • EXCLUDE
    • PART

    When grouping, the options listed above apply to the most previous TABLESPACE. Only one set of the remaining options, which are referred to as global options (see below), can be specified for a group.

    You can use grouping without dynamic allocation by specifying different values for DSNUM ALL or DSNUM integer.

  • The following options are global options for the QUIESCE command and you should specify them only once per QUIESCE command:
    • WRITE
    • ON ERROR BADSTATUS
    • GROUP 

QUIESCE command syntax

QUIESCE command syntax 

GUID-31213932-4517-4D93-A4C2-8CEE214785EE-low.png

QUIESCE command syntax—Object list 

GUID-ACAFA13D-DBB5-4EA8-A3B7-9BB266A0C2C4-low.png

QUIESCE command syntax—Object options 

GUID-161FEE8F-BE19-4BCF-855C-BFCD28E04207-low.png

GUID-86CA97CB-AD5B-4623-9F2A-9F2C8741F2A2-low.png

This section contains the following topics:


 

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