Task
|
Statement
|
---|---|
Drop the master database definitions from a replica database
|
|
Drop a replica database from the master database
|
|
Register a replica database with the master database
|
MESSAGE APPEND ... REGISTER REPLICA, see MESSAGE APPEND
|
Configure synchronization
|
|
Change the network name associated with a database
|
|
Rename a server
|
|
Define catalog-level parameters
|
|
Define the user name and password to use when the replica database is registered in the master database
|
|
Map replica user ids to specified master user ids
|
Task
|
Statement
|
---|---|
Store synchronization history
|
|
Create a bookmark in a master database
|
|
Remove a bookmark defined in a master database
|
|
Create or replace publications
|
|
Remove a publication definition from the master database
|
|
Remove a publication registration from a replica database
|
|
Remove data that is no longer needed in a replica database
|
|
Export data from a master database to a file
|
|
Import data to a replica database from a data file that was created by the EXPORT SUBSCRIPTION statement
|
|
Grant access rights on a publication to a user or role
|
|
Revoke access rights to a publication from a user or role
|
|
Conserve memory by streaming the associated data
|
Task
|
Function or statement
|
---|---|
Read parameters from the parameter bulletin board
|
|
Set parameters on the parameter bulletin board
|
|
Save transactions in the replica database for propagation to the master database
|
|
Set properties in the replica database for a transaction that is saved for propagation to the master database
|
Task
|
Statement
|
---|---|
Start a message to send to the replica database
|
|
Append tasks to a message that was created in the replica database with the MESSAGE BEGIN statement
|
|
Closes a message in a replica database (ready to send to master database)
|
|
Send message to the master database
|
|
Request a message from the master database, if a reply to a sent message was not received by the MESSAGE FORWARD statement
|
|
Re-execute message on the replica database (if the execution of a reply message fails)
|
|
Execute a failed message on the master database
|
|
Delete a message from the database (in order to recover from an error)
|
|
Delete the current transaction from a given message in the master database
|