ml_active_remote_id

Stores the synchronization status for each remote database in the server farm.

Column

Description

remote_id

VARCHAR(128). The unique integer that identifies the ID of the remote database currently being synchronized.

server_id

INTEGER. The value that references the server_id in the ml_server table.

status

CHAR(1). The synchronization status for the remote database. The value O indicates an ongoing synchronization, and C indicates a cancelled synchronization.

Remarks

This table does not contain data unless a server farm is running.

For DB2 mainframe consolidated database types, this table is called ml_active_rid. See IBM DB2 mainframe system table name conversions.

Constraints

PRIMARY KEY( remote_id )

FOREIGN KEY( server_id ) REFERENCES ml_server( server_id )