SET,REPL command
You can use the SET,REPL command to modify existing subscriptions.
Modifying subscription information
You can use the following SET command to modify the attributes of an existing subscription or of all subscriptions.
Parameters
- subscription name
- The name of the subscription to modify. You can specify the subscription name as an identifier with or without quotation marks. If the subscription name is mixed case you must use quotation marks.
- ALL
- Modifies the specified attributes for all subscriptions.
- CAPTURECACHE
- The size of the capture cache. A value of 64 to 2048 MB is allowed.
- PERSISTENT
- Automatically restarts replication for the specified subscription. Specify this keyword only for subscriptions that use continuous replication. Valid values are YES or NO.
- SETLOGPOS
- Updates the bookmark information stored at the target server.
When replication is restarted for a subscription, the target bookmark is updated with the new date/time. The bookmark consists of multiple z/OS system clock values, which typically differ from one another. However, the SETLOGPOS command synchronizes all components by setting them to the same specified date/time. In addition, the capture point for all active table mappings is aligned to this date/time when replication begins for the subscription.
Ensure that the specified date/time identifies a period when no updates are occurring to the IMS databases referenced in the active table mappings. Changes are not captured for any in-flight unit-of-recovery that started before the capture point.
Ensure that the specified date/time identifies a point in time when no updates are occurring to any files referenced in the subscriptions table mappings. It must also be set before a tie‑up record is written to the log stream, prior to any updates on the file. Any changes made to files referenced in the subscription are discarded that occur from the new capture point until the next tie-up record is encountered in the log stream.
Specify the time in the format YYYY-MM-DD-hh.mm.ss.thmiju:- YYYY-MM-DD is a calendar date
- hh.mm.ss.thmiju is a time of day
Valid values: You can specify a value to get the current time or specify GMTTIME or SERVERTIME.- GMTTIME
- The Greenwich Mean Time (GMT) time. You must specify this value up to the ss (seconds). For
example:
SET,REPL,SUBSCR=subscription name,'SETLOGPOS, GMTTIME=2011-04-14-18.01.00.123456' - SERVERTIME
- The server time. Specify the local time of the server time zone. You must specify this value up
to the ss (seconds) value. For example:
SET,REPL,SUBSCR=subscription name,'SETLOGPOS, SERVERTIME=2011-04-14-18.01.00.123456'
Note: When GMTTIME or SERVERTIME values are not specified, the bookmark is automatically set to the current time.Important: If you use the SETLOGPOS keyword and either the GMTTIME or SERVERTIME keywords, the entire phrase must be in quotes and the keywords must be upper case. If you modify a bookmark, you might need to refresh the entire subscription and restart replication for the subscription to recreate a valid bookmark. You should only change a bookmark under the direction of IBM® Software Support.Note: Refresh processing is not supported for delimited format subscriptions. - “STATUS= <status>,OBJECT=<object>”
- The status of the subscription. Valid values:
- ACTIVE
- For any subscription, you can set mappings as active for replication. If a mapping is not set as
active, it will not replicate when replication is started for the subscription.
You can use the optional NOW modifier to set the mapping as active and set its log position time to the current time when the command is processed. With this optional modifier, the command syntax looks as follows:
“STATUS=ACTIVE,OBJECT=object,NOW” - PARK
- For any subscription, you can park replication mappings. If a mapping is set as parked, it will not replicate when replication is started for the subscription.
- REFRESH
- Starts refresh processing for the subscription.Note: Refresh processing is not supported for delimited format subscriptions.
