Previous Topic: WgnMachineRelationNext Topic: MonitorID


WgnMonitorCache

This table is used to store objects changes that need to be replicated to other machines.

Column

Primary Key

Datatype

Length

Notes

CacheID

Unique ID for the cache entry.

Yes

INTEGER

4

Cache entries should be ordered by ID to ensure they are read in the correct order.

MonitorID

The replication monitor that owns the cache entry.

 

INTEGER

4

Follow the hyperlink for details.

CacheType

The type of cache entry

 

INTEGER

4

Follow the hyperlink for details.

CacheData

The update data associated with the cache entry.

 

LONGVARBINARY

 

May be NULL, depending on the CacheType.

DBOperation

The database operation associated with the cache type.

 

INTEGER

4

Follow the hyperlink for details.

TransIDM

Part-key identifying the replication transaction ID.

 

INTEGER

4

Unused

TransID

Part-key identifying the replication transaction ID.

 

INTEGER

4

Unused

TransCommit

Indicates whether the remote machine has committed the transaction.

 

INTEGER

4

Unused

MachineIDM

Part-key identifying the machine which sourced the cache entry

 

INTEGER

4

Foreign key: WgnMachine

'Sourced' refers to immediate parent/child. NULL if locally sourced.

MachineID

Part-key identifying the machine which sourced the cache entry

 

INTEGER

4

Foreign key: WgnMachine

'Sourced' refers to immediate parent/child. NULL if locally sourced.

RetryCount

Indicates the number of attempts to replicate the row to the parent machine.

 

 

 

Used for Application Data only.