This chapter describes all of the Sybase Replication Agent commands shown in Table 1-1.
Command name |
Description |
Page |
---|---|---|
Returns the path to the Sybase Replication Agent system log file. |
||
Returns a list of the Sybase Replication Agent capabilities. |
||
Returns the current date and time from the primary data server. |
||
Executes the specified SQL statement in the current database. |
||
Returns the current value of the database generation ID; updates the value of the database generation ID. |
||
Returns a list of all the columns in the specified table. |
||
Returns a list of all the databases in the primary data server. |
||
Returns a list of all the columns that make up the primary keys in the specified table. |
||
Returns a list of the parameters for the specified procedure. |
||
Returns a list of all the procedures in the specified database. |
||
Returns the name of the database specified for SQL statement execution. |
||
Returns a list of all the tables in the specified database. |
||
Returns a list of owners whose objects will be filtered for initialization; adds, removes owners to the list. |
||
Specifies the database to be used for SQL statement execution. |
||
Returns replication marking status; enables or disables replication for all marked columns or a specified column. |
||
Returns DDL replication status; enables or disables replication for DDL statements. |
||
Returns stored procedure replication marking status; marks a specified procedure for replication; unmarks all marked procedures or a specified procedure; enables or disables replication for all marked procedures or a specified procedure. |
||
pdb_setrepseq (For Oracle only) |
Returns the sequence replication marking status; marks specified sequence for replication; unmarks all marked sequences or a specified sequence; enables or disables replication for all marked sequences or a specified sequence. |
|
Returns table replication marking status; marks all tables or a specified table for replication; unmarks all marked tables for replication; enables or disables replication for all marked tables or a specified table. |
||
returns, adds or removes record identifiers from a list of records to skip in processing. |
||
Truncates the Sybase Replication Agent transaction log. |
||
Returns the type and version of the primary data server. |
||
Returns names of transaction log objects; creates transaction log base objects in the primary database; removes transaction log base objects from the primary database. |
||
Stops current Log Reader activity, processes data in internal queues, drops connections, and puts Sybase Replication Agent in Admin state. |
||
Returns help information for configuration parameters; sets the value of a configuration parameter. |
||
Returns the current date and time from the Sybase Replication Agent server. |
||
Changes the disk device path for a log device recorded in the RASD. |
||
Places a dump marker in the Sybase Replication Agent transaction log. |
||
Returns help information for Sybase Replication Agent commands. |
||
Returns information about the primary database from the RASD. |
||
Returns information about the primary database from the RASD. |
||
Returns information about primary database log devices from the RASD log device repository. |
||
Returns information about fields (columns in tables, or input parameters in stored procedures) from the RASD. |
||
Returns LTM locator field values. |
||
Returns information about primary database users from the RASD. |
||
Returns the current value of the LTM Locator stored by Sybase Replication Agent; zeroes the current LTM Locator; retrieves a new LTM Locator from Replication Server. |
||
Returns the Maintenance User for the Sybase Replication Agent connection. |
||
Emulates the Replication Server ra_marker system function, placing a marker object in the Oracle redo log |
||
Places a marker in the Sybase Replication Agent transaction log. |
||
Sets the Sybase Replication Agent admin user login and password. |
||
Returns statistics for either a specified Sybase Replication Agent component or all components; resets statistics for all components. |
||
Returns the current Sybase Replication Agent state. |
||
Truncates older versions of primary database articles in the system data repository in the RASD. |
||
Truncates older versions of primary database users in the system data repository in the RASD. |
||
Updates the log device repository in the RASD. |
||
Returns the Sybase Replication Agent version. |
||
Returns Replication Agent, primary data server, Replication Server, and communications driver versions. |
||
Backs up the Replication Agent System Database (RASD). |
||
Restores the Replication Agent System Database (RASD). |
||
Starts replication for the current active log and puts Sybase Replication Agent in Replicating state. |
||
Creates a replication definition at Replication Server for a marked table and procedure, or for all marked tables and procedures. |
||
A replication definition for a table is dropped at the Replication Server. |
||
Shuts down Sybase Replication Agent. |
||
Immediately stops all Log Reader activity, drops connections, and puts Sybase Replication Agent in Admin state. |
||
Tests Replication Agent connections. |
||
Returns current trace flag settings; changes a specified trace flag. |
The remaining sections in this chapter describe each Sybase Replication Agent command in detail.