QUSRBRM.COPY_CONTROL_GROUP Procedure

Owned by Peter Lafler
Last updated: Mar 15, 2023 by Aaron Fistler
3 min read

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

QUSRBRM.COPY_CONTROL_GROUP (SOURCE_CONTROL_GROUP=> source-control-group, NEW_CONTROL_GROUP=> new-control-group, CONTROL_GROUP_TYPE => type, COPY_LIST=> copy-list, OVERWRITE=> overwrite, SYSTEM_NAME=> system-name)

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')

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.

 

Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.