Changing the Status of Destinations and Subscriptions

#### Search Results

Search

# Changing the Status of Destinations and Subscriptions

This section describes the programs REPTCHGD and REPTCHGS that you can use to change the status of multiple Destinations and Subscriptions. You can find the programs in the SYSAOS library and you can execute them as Natural batch programs or as standalone online programs.

- Managing Destinations with REPTCHGD

- Managing Subscriptions with REPTCHGS

## Managing Destinations with REPTCHGD

The program REPTCHGD allows you to change the status of multiple Destination names to Opened or Closed, or change it to Active or Inactive. You can execute the program as a Natural batch program or as a standalone online program.

REPTCHGD makes a call for the status of all Destinations for the Replication Server, while ensuring that it does not duplicate a previous status call of a Destination. In other words, if a Destination is Closed, and you want it Closed, REPTCHGD does not issue a duplicate call.

You can only choose one database to change at a time. You cannot request both `OPEN` and `ACTIVE` in a single execution.

You can reference a group of names when specifying the Destination name using these two methods:

- Using the ending/trailing * wildcard entry, i.e., `ADA*`, or simply `*` for all existing names.

- Specifying a `NAME` and marking Perform GE with a `Y`. All Names greater than or equal to that `NAME` are part of the status change.

If you specify a `NAME` without the `*` or the Perform GE functionality then only that `NAME` is selected for a status change.

#### Example – Batch Job

The following is example sets all Destinations for Reptor DBID 21954 to Open.

    //CMSYNIN  DD *
      LOGON SYSAOS
      *   DBID,NAME,GE,OPEN,CLOSE,ACTIVE,INACTIVE,PFKEY
      REPTCHGD
      21954,*,N,Y,N,N,N,%K5
      FIN
      /*

#### Example – Online Execution

    Input the following:
    Reptor DBID to select:     0
    Destination Name.... :            Perform GE Name? ..: N
      Status to Open?....: N   Status to Close?...: N
      Status to Active?..: N   Status to Inactive?: N

    Press PF3 to terminate
    Press PF5 to update the status

Executing REPTCHGD with a specified DBID, an `*` for the Destination Name, and Status to Open? set to `Y`, creates either REPGOOD or REPTERR messages output like the following, plus a summary of information indicating what was accomplished:

    Page      1                                     24-10-14  16:37:14

    REPGOOD : Open Destination completed successfully. ADA1CPY
    REPGOOD : Open Destination completed successfully. A4027
    REPGOOD : Open Destination completed successfully. A4028
    REPTERR : REPTOR Open Destination failed ENTX-OUT
    REPTERR : REPTOR Open Destination failed EWISDEST
    REPTERR : REPTOR Open Destination failed EXXDEST
    REPTERR : REPTOR Open Destination failed E102TOL
    REPTERR : REPTOR Open Destination failed E102TON
    REPTERR : REPTOR Open Destination failed FILE1
    REPTERR : REPTOR Open Destination failed MQ-OUT
    REPTERR : REPTOR Open Destination failed MQS4ODAA
    REPTERR : REPTOR Open Destination failed ODINN

    Reptor 21954 has 1140 Destinations
    Name specified: *
    Changed 3 Destinations to Open status
    9 Destinations failed to Open
    1128 Destinations status matched, no action taken

    REPTCHGD has completed

You can find additional information in the selected Replication Server SYSLOG for the REPGOOD or REPTERR messages:

    ADAF8N 21954 Open  request received for destination ADA1CPY
    ADAF8U 21954 Destination ADA1CPY  opened on all tasks
    ….
    ADAF8N 21954 Open  request received for destination ENTX-OUT
    ADAF8B 21954 Connect failed: Unexpected reason code
    ADAF8B 21954 10.14.109.101:0071:TCP
    ADAF8B 21954 Error info: 012/036/00000000/000000D0
    ADAF8U 21954 Destination ENTX-OUT open failed

## Managing Subscriptions with REPTCHGS

The program REPTCHGS allows multiple Subscription names to be set to Active or Inactive. You can execute the program as a Natural batch program or as a standalone online program.

REPTCHGS makes a call for the status of all Subscriptions for the Replication Server, while ensuring that it does not duplicate a previous call for a status of a Subscription. In other words, if a Subscription is Active, and you want it Active, REPTCHGS does not issue a duplicate call.

You can reference a group of names when specifying the Subscription name using these two methods:

- Using the ending/trailing * wildcard entry, i.e., `ADA*`, or simply `*` for all existing names.

- Specifying a `NAME` and marking Perform GE with a `Y`. All Names greater than or equal to that `NAME` are part of the status change.

If you specify a `NAME` without the `*` or the Perform GE functionality then only that `NAME` is selected for a status change.

#### Example – Batch Job

The following is example sets all Subscriptions for Reptor DBID 21954 to Active.

    //CMSYNIN  DD *
     LOGON SYSAOS
     *   DBID,NAME,GE,ACTIVE,INACTIVE,PFKEY
     REPTCHGS
     21954,*,N,Y,N,%K5
     FIN
     /*

#### Example – Online Execution

    Input the following:
    Reptor DBID to select:     0
    Subscription Name... :            Perform GE Name? ..: N
      Status to Active?..: N
      Status to Inactive?: N

    Press PF3 to terminate
    Press PF5 to update the status

Executing REPTCHGD with a specified DBID, an `*` for the Subscription Name, and Status to Active? set to `Y`, creates either REPGOOD or REPTERR messages output like the following, plus a summary of information indicating what was accomplished:

    Page      1                                    24-10-14  17:18:47

    REPGOOD : Activate Subscription completed successfully. ETX-OUT
    REPGOOD : Activate Subscription completed successfully. P101001
    REPGOOD : Activate Subscription completed successfully. SUBMQOUT
    REPGOOD : Activate Subscription completed successfully. SUB4027
    REPGOOD : Activate Subscription completed successfully. SUB4028
    REPGOOD : Activate Subscription completed successfully. 52234101
    REPGOOD : Activate Subscription completed successfully. 52234303
    REPGOOD : Activate Subscription completed successfully. 52234404
    REPGOOD : Activate Subscription completed successfully. 52234505
    REPGOOD : Activate Subscription completed successfully. 52234707
    REPGOOD : Activate Subscription completed successfully. 52234808
    REPGOOD : Activate Subscription completed successfully. 52234909
    REPGOOD : Activate Subscription completed successfully. 52235010
    REPGOOD : Activate Subscription completed successfully. 52235212
    REPGOOD : Activate Subscription completed successfully. 52235313
    REPGOOD : Activate Subscription completed successfully. 52235414
    REPGOOD : Activate Subscription completed successfully. 52235515
    REPGOOD : Activate Subscription completed successfully. 52235616
    REPGOOD : Activate Subscription completed successfully. 52235717
    REPGOOD : Activate Subscription completed successfully. 52235818
    REPGOOD : Activate Subscription completed successfully. 52235919
    REPGOOD : Activate Subscription completed successfully. 52236101
    REPGOOD : Activate Subscription completed successfully. 52236303
    REPGOOD : Activate Subscription completed successfully. 52236404

    (continues for 28 pages)

    Page     29                                    24-10-14  17:18:47

    REPGOOD : Activate Subscription completed successfully. 52336303
    REPGOOD : Activate Subscription completed successfully. 52336404
    REPGOOD : Activate Subscription completed successfully. 52336707
    REPGOOD : Activate Subscription completed successfully. 52337313
    REPGOOD : Activate Subscription completed successfully. 52337414
    REPGOOD : Activate Subscription completed successfully. 52337515
    REPGOOD : Activate Subscription completed successfully. 52337616
    REPGOOD : Activate Subscription completed successfully. 52337717
    REPGOOD : Activate Subscription completed successfully. 52337818
    REPGOOD : Activate Subscription completed successfully. 52337919
    REPGOOD : Activate Subscription completed successfully. 52338303
    REPGOOD : Activate Subscription completed successfully. 52338404
    REPGOOD : Activate Subscription completed successfully. 52338707
    REPGOOD : Activate Subscription completed successfully. 52339313
    REPGOOD : Activate Subscription completed successfully. 52339414
    REPGOOD : Activate Subscription completed successfully. 52339515
    REPGOOD : Activate Subscription completed successfully. 52339616
    REPGOOD : Activate Subscription completed successfully. 52339717
    REPGOOD : Activate Subscription completed successfully. 52339818
    REPGOOD : Activate Subscription completed successfully. 52339919

    Reptor 21954 HAS 1121 Subscriptions
    Name specified: *
    Changed 668 Subscriptions to Active status
    0 Subscriptions failed to activate
    453 Subscriptions were already Active, no action taken

    REPTCHGS has completed

You can find additional information in the selected Replication Server SYSLOG for the REPGOOD or REPTERR messages:

    ADAF2M 21954 Subscription ETX-OUT  activated
    ADAF2M 21954  due to explicit request (DBS/AOS/opcmd)

### On this page

- Managing Destinations with REPTCHGD
- Managing Subscriptions with REPTCHGS