Valid for
Extract
Description
Use TCPSOURCETIMER
or NOTCPSOURCETIMER
to specify whether the Collector adjusts the timestamps of each record from the source system to the timestamps of the target system. When transmitting data to trails or files (RMTFILE
or RMTTRAIL)
on the target system using the TCP/IP Collector, the default is to adjust the timestamps. Although timestamps are stored in Greenwich Mean Time (GMT), the clocks of the source and target systems are frequently un-synchronized. Adjusting those timestamps allows Manager and GGSCI to calculate the true latency between the source and target systems.
However, when data is moved over TCP/IP between two NonStop systems and the systems are also linked with an Expand network, this adjustment is already made. Under those conditions, specify NOTCPSOURCETIMER
to avoid the incorrect "double adjustment." NOTCPSOURCETIMER
should be used when a Replicat on the target system uses @GETENV
to get the COMMITTIMESTAMP
header field for any column mapping.
Default
TCPSOURCETIMER
Syntax
TCPSOURCETIMER | NOTCPSOURCETIMER