BYTE and TEXT Information in ATS Files

When the information recorded in the ATS file includes BYTE or TEXT data, the replicated row data (RRD) information is reported, as the following examples show.

Example 1

<1200, TEXT, PB 877(necromsv) 840338515(00/08/17 20:21:55)>

In this example:

• 1200 is the size of the data.
• TEXT is the data type (it is either BYTE or TEXT).
• PB is the storage type (PB when the BYTE or TEXT is stored in the tablespace, BB for blobspace storage).
• The next two fields are the server identifier and the time stamp for the column if the conflict-resolution rule is defined for this replicate and the column is stored in a tablespace.

Example 2

<500 (NoChange), TEXT, PB 877(necromsv) 840338478(00/08/17 20:21:18)>

In this example, (NoChange) after the 500 indicates that the TEXT data has a size of 500, but the data has not been changed on the source server. Therefore the data is not sent from the source server.

Example 3

<(Keep local blob),75400, BYTE, PB 877(necromsv) 840338515(00/08/17 20:21:55)>")

In this example, (Keep local blob) indicates that the replicated data for this column was not applied on the target table, but instead the local BYTE data was kept. This usually happens when time-stamp conflict resolution is defined and the local column has a time stamp greater than the replicated column.