ttRepSubscriberWait
subscriberStoreName
. It also waits until the subscriber has acknowledged that the updates have been durably committed at the subscriber database.
Call this procedure in a separate transaction, when no other transaction is pending on the active database. This call returns an error if any transactions on the active database are open.
If you set the waitTime
parameter to -1
and the subscriberStoreName
parameter to NULL
, the ttRepSubscriberWait
procedure does not return until all updates committed up until the time of the procedure call have been transmitted to all subscribers, and all subscribers have acknowledged that the updates have been durably committed.
The ttRepSubscriberWait
procedure should not be used when an urgent response is required. Instead, you should use the return receipt service.
The procedure is working as expected for transient error scenarios.
Note:
If this procedure is called after all write transaction activity is quiesced at a store (there are no active transactions and no transactions have started), it may take 60 seconds or longer before the subscriber sends the acknowledgment that all updates have been durably committed at the subscriber.
The procedure does not return any failure output ( 01
value) for permanent error scenarios.
Required Privilege
This procedure requires no privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttRepSubscriberWait('replicationName', 'replicationOwner', 'subscriberStoreName', 'subscriberHostName', waitTime)
Parameters
ttRepSubscriberWait
has these parameters:
Parameter | Type | Description |
---|---|---|
|
|
The name of the replication scheme on which to operate. May be |
|
|
The owner of the replication scheme. May be |
|
|
The name of the subscribing database whose state is to be set. May be |
|
|
The subscriber's host. May be |
|
|
Number of seconds to wait for the specified subscriber(s). A value of |
Result Set
ttRepSubscriberWait
returns the result set:
Column | Type | Description |
---|---|---|
|
|
|
Examples
If there is one defined replication scheme REPOWNER.REPSCHEME
, to direct the transmitting database to wait ten minutes for subscriber REP
2 on SERVER2
to catch up, use:
CALL ttRepSubscriberWait('REPSCHEME','REPOWNER', 'REP2', 'SERVER2', 600);
See Also
- ttRepDeactivate
- ttRepTransmitSet
- ttReplicationStatus
- ttRepPolicySet
- ttRepStart
- ttRepStop
- ttRepSubscriberStateSet
- ttRepSyncGet
- ttRepSyncSet
- ttRepDuplicateEx in Oracle TimesTen In-Memory Database C Developer's Guide