ttRepSyncSet

Description

Sets static attributes associated with the caller's use of the replication-based return service. This procedure operates with either the RETURN RECEIPT or RETURN TWOSAFE service.

Required privilege

This procedure requires no privilege.

Syntax

ttRepSyncSet(requestReturn, returnWait, localAction)

Parameters

ttRepSyncSet has these optional parameters:

Parameter Type Description

Parameter	Type	Description
`requestReturn`	BINARY(1)	0x00 - Turn off the return service for the current transaction. 0x01 - Turn on return services for the current transaction. Committing the transaction resets this attribute to its default value of 0 ("off"). You can use this parameter to turn on or turn off return services only when the replication subscribers have been configured with RETURN RECEIPT BY REQUEST or RETURN TWOSAFE BY REQUEST.
`returnWait`	TT_INTEGER	Specifies the number of seconds to wait for return service acknowledgement. The default value is 10 seconds. A value of '0' means there is no wait time. This timeout value overrides the value set by the RETURN WAIT TIME attribute in the CREATE REPLICATION or ALTER REPLICATION statement. The timeout set by this parameter persists across transaction boundaries and applies to all return services independent of the BY REQUEST option.
`localAction`	TT_INTEGER	Action to be performed in the event the subscriber is unable to acknowledge commit of the transaction within the timeout period specified by `returnWait`. This parameter can only be used for return twosafe transactions. Set to NULL when using the RETURN service. 1 -- NO ACTION. On timeout, the process recovery commits the transaction. This is equivalent to a forced commit. (default) 2 -- COMMIT. On timeout, the commit function writes a COMMIT log record and effectively ends the transaction locally. No more operations are possible on the same transaction.

requestReturn

BINARY(1)

0x00 - Turn off the return service for the current transaction.

0x01 - Turn on return services for the current transaction. Committing the transaction resets this attribute to its default value of 0 ("off").

You can use this parameter to turn on or turn off return services only when the replication subscribers have been configured with RETURN RECEIPT BY REQUEST or RETURN TWOSAFE BY REQUEST.

returnWait

TT_INTEGER

Specifies the number of seconds to wait for return service acknowledgement. The default value is 10 seconds. A value of '0' means there is no wait time.

This timeout value overrides the value set by the RETURN WAIT TIME attribute in the CREATE REPLICATION or ALTER REPLICATION statement.

The timeout set by this parameter persists across transaction boundaries and applies to all return services independent of the BY REQUEST option.

localAction

TT_INTEGER

Action to be performed in the event the subscriber is unable to acknowledge commit of the transaction within the timeout period specified by returnWait. This parameter can only be used for return twosafe transactions. Set to NULL when using the RETURN service.

1 -- NO ACTION. On timeout, the process recovery commits the transaction. This is equivalent to a forced commit. (default)

2 -- COMMIT. On timeout, the commit function writes a COMMIT log record and effectively ends the transaction locally. No more operations are possible on the same transaction.

Result set

ttRepSyncSet has no result set.

Examples

To enable the return receipt service in the current transaction for all the replication elements configured with RETURN RECEIPT BY REQUEST or RETURN TWOSAFE BY REQUEST, use:

rc = SQLExecDirect ( hstmt
, (SQLCHAR *)"{CALL ttRepSyncSet( 0x01 )}"
                    , SQL_NTS )

Notes

The call to enable the return receipt service must be part of the transaction (AutoCommit must be off).