The QUSRBRM.COPY_CONTROL_GROUP procedure copies an existing control group. Use this procedure to copy a backup control group to create a new backup control group. You can assign a new name to the control group that you are creating. You can also copy the control group to a remote system when the Network feature is installed by specifying a system name.
Authorization: The privileges held by the authorization ID of the statement must include the following:
*EXECUTE SQL privilege on this procedure
The BRMS Network feature is required.
The schema is QUSRBRM.
Parameters
|
source-control-group (Required)
Specifies the name of the existing control group that you are copying to create a new control group.
Possible values are:
source-control-group | The existing control group name to copy. The control group name is not case-sensitive and must be 1 to 10 characters long. |
new-control-group (Required)
Specifies the name of the new control group that you want to create from an existing control group.
Possible values are:
new-control-group | The new control group name to create. The control group name is not case-sensitive and must be 1 to 10 characters long. |
control-group-type (Optional)
Specifies the type of control group that is being copied.
Possible values are:
ARC | Specifies that the control group being copied is an archive control group. |
BKU | Specifies that the control group being copied is a backup control group. This is the default if a value is not specified. |
MGR | Specifies that the control group being copied is a migration control group. |
copy-list (Optional)
Specifies how to handle BRMS list objects that are in the existing control group being copied.
Possible values are:
ALL | Specifies to copy and create all BRMS list objects from the existing control group. |
NEW | Specifies to copy and create new BRMS list objects from the existing control group if the BRMS list object does not already exist. |
NO | Specifies to not copy BRMS list objects that are in the existing control group. This is the default if a value is not specified. |
overwrite (Optional)
Specifies what to do if the the new control group that you want to create from an existing control group already exists.
Possible values are:
NO | Specifies to not overwrite the control group if it already exists. This is the default if a value is not specified. |
YES | Specifies to overwrite the control group if it already exists. |
system-name (Optional)
Specifies the system name where the new control group will be created.
Possible values are:
LOCAL | Specifies that the local system name is the target where the new control group is created. This is the default if a value is not specified. |
NETGRP | Specifies that the new control group should be copied and created on all systems in the BRMS network. |
system-name | The system name where the new control group is created. Note: The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name. |
Examples:
To copy an existing backup control group named MYCGTEST on the local system with all the BRMS list objects and overwriting the control group if it already exists:
call QUSRBRM.COPY_CONTROL_GROUP( SOURCE_CONTROL_GROUP=> 'MYCGTEST', NEW_CONTROL_GROUP=> 'MYCGCOPY', CONTROL_GROUP_TYPE=> 'BKU', COPY_LIST=> 'ALL', OVERWRITE => 'YES', SYSTEM_NAME => 'LOCAL') |
|---|
Error Messages
The following SQL States and error messages may be returned by this procedure.
U0001 | System name is not valid. |
U0002 | Source control group name not found. |
U0003 | Source control group name not valid. |
U0004 | New control group name not valid. |
U0005 | Control group type not valid. Must be ARC, BKU, or MGR. |
U0006 | Copy list value not valid. Must be ALL, NEW, or NO. |
U0007 | Overwrite value not valid. Must be NO or YES. |
U0008 | Copy Control Group failed. |
U9997 | Functional authority to BRMS Enterprise QIBM_Q1A_BKU required. |
U9998 | BRMS Network Functions features required. |
U9999 | Illegal execution. |