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.

Information
Limited support BMC 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 Recovery Manager for Db2 13.1.

Copying object sets


Use the LIKE parameter to copy an existing object set.

BMC AMI Recovery Manager verifies that the new name does not already exist, and then copies the object set into the repository. The new object set retains all utility options setting of the original object set, and you can optionally retain the authorizations and objects of the original object set as well.


Use the following syntax to copy an object set:

Warning

Important

RETAIN AUTH is not required because authorization is performed by the Solution Common Code (SCC).


 CREATE OBJECTSET creator2.name2 LIKE creator1.name1
   RETAIN AUTH yes|no
   RETAIN OBJECTS yes|no

If you want to copy an existing object set but also include additional objects, you can use the LIKE parameter when creating a new object set with the INCLUDE TABLESPACE, INCLUDE TABLE, INCLUDE SQL, or INCLUDE INDEX options.

Information
Example
CREATE OBJECTSETcreator2.name2
 INCLUDE TABLE SPACE tablespaceName
   LIKE creator1.name1
   RETAIN AUTH yes|no
   RETAIN OBJECTS yes|no




 

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

BMC AMI Recovery Manager for Db2 12.1