CHANGE_NRG procedure

The CHANGE_NRG procedure sets the description or the load balance link count for one or all of the Db2® Mirror Network Redundancy Groups (NRGs).

Authorization: The privileges held by the authorization ID of the statement must include *IOSYSCFG special authority. For the authority needed to use this procedure, see Authorization.

The schema is QSYS2.

nrg-name

A character or graphic string that contains the name of the NRG to change.

The valid NRG names and their primary uses are:

MIRROR_DATABASE

NRG for immediate replication of database-related objects and operations.

Object types: *DTAARA, *ENVVAR, *FILE, *JOBD, *JRN, *LIB, *PGM, *SQLPKG, *SQLUDT, *SQLXSR, *SRVPGM, and *SYSVAL.
SQL Data Definition Language operations.
Replication due to the restore of an object.

MIRROR_ENGINE

NRG used by the Db2 Mirror engine to manage the Db2 Mirror environment.

MIRROR_IFS

NRG used for accessing Integrated File System (IFS) data.

MIRROR_OTHER

NRG for immediate replication of security objects, security attributes, and non-database objects or operations.

Object types: *AUTL, *DTAQ, *FCNUSG, *JOBQ, *OUTQ, *SECATR, *SPLF, *USRIDX, *USRPRF, and *USRSPC.
Replication of objects due to Replication Criteria List changes.
Comparison of objects between the two nodes.

MIRROR_RESYNC

NRG for resynchronization of objects and data that were changed while replication was suspended.

The following special value is also allowed.

*MIRROR: All of the Db2 Mirror NRGs will be changed.

nrg-description

A character or graphic string that contains up to 50 characters of descriptive text for the NRG. If this parameter is omitted, the descriptive text is not changed.

load-balance-link-count

An integer value that defines the load balance link count. It must be a value from 1 to 16. If this parameter is omitted, the load balance link count is not changed.

Example

Set the load balance link count to 3 for all NRGs.

CALL QSYS2.CHANGE_NRG(NRG_NAME => '*MIRROR',
                      LOAD_BALANCE_LINK_COUNT => 3);