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 object options


This section describes options you can use for the objects (TABLESPACE, RMGROUP, OBJECTSET, or APPLICATION) specified by the Object List.

You can use a different value for each of these options for each TABLESPACE, RMGROUP, OBJECTSET, or APPLICATION in your QUIESCE statement. Object options apply to the most previous TABLESPACE, RMGROUP, OBJECTSET, or APPLICATION specification and can be specified in any order.

QUIESCE object options

Option

Description

CLONE

The CLONE option indicates that the QUIESCE command is to create a quiesce point for only the specified clone table space.

The base table space and its clone can not be processed in the same BMC AMI Copy command.

DSNUM

The DSNUM option identifies either a single partition or data set in the table space named in the TABLESPACE option, or all of the partitions or data sets contained in that table space. The default is all of the partitions or data sets (DSNUM ALL).

Important

You cannot run multiple quiesces against the same partition (for DSNUM integer) or the same table space (for DSNUM ALL).

Values of DSNUM

Value

Description

DSNUM integer

DSNUM integer is the number of a single partition or data set in the target table space that you want to quiesce. For a partitioned table space, integer is the partition number. For a nonpartitioned table space, integer is the ordinal number of the data set for the table space. Specify this option when you want a quiesce point for only one partition or data set in that table space. The value of integer must be in the range 1 through 4096.

DSNUM begin:end

DSNUM begin:end specifies a range of partitions to process. You specify the range of partitions with two numbers separated by a colon (:) with or without spaces. The following example gives a specification that copies physical partitions 10 through 20:

QUIESCE TABLESPACE ACCOUNTS.*
        DSNUM 10:20

During the table space selection process, only partitioned table spaces that overlap the partition range qualify for selection. Nonpartitioned and partitioned table spaces that do not have as many partitions as the low value of the range do not qualify for selection, and BMC AMI Copy issues the following message:

 BMC47431IdatabaseName.tableSpaceName DID NOT QUALIFY FOR RANGE SELECTION

LOGICAL

Adding the LOGICAL option after a DSNUM begin:end specification allows you to indicate logical partitions rather than physical partitions and have the logical partitions mapped to their respective physical data set numbers. BMC AMI Copy then continues as if you specified a physical range of partitions. You might use the LOGICAL option if you have rotated your partitioned table spaces to create a logical view of the physical data sets.

In the following specification, the logical partition numbers 10 through 20 are mapped to their respective physical data set numbers:

QUIESCE TABLESPACE ACCOUNT.*
        DSNUM 10:20 LOGICAL

DSNUM ALL

DSNUM ALL is the default for a TABLESPACE specification and specifies that you want to quiesce all partitions or data sets in the target table space.

DSNUM PART

Specify DSNUM PART when you quiesce a partitioned table space and you want the quiesce to be made and registered by partition instead of by table space. By contrast, DSNUM ALL quiesces and registers a partitioned table space as one space.

When you use wildcard selection of table spaces with some partitioned and others nonpartitioned, specifying DSNUM PART provides quiesces by partition or by table space, as appropriate.

EXCLUDE

Use the EXCLUDE option after a wildcard table space specification to exclude one or more spaces from the quiesce. You can use the wildcards % and * or specific names to specify the exclusions.

The excluded spaces must be in the form of a list following the EXCLUDE keyword. Each item in the list must be in the formdatabaseName.tableSpaceName and you must separate the individual items by commas. Optionally, you can enclose the list in parentheses. For more information, see Excluding-specified-spaces-from-a-wildcard-specification.

PART integer

The PART option identifies a partition to be quiesced. integer is the number of the partition and must be in the range from 1 to the number of partitions defined for the table space. PART can be specified as an alternative to DSNUM for compatibility with the Db2 QUIESCE utility.


Related topic



 

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