Chapter 1: Command Reference

This chapter describes all of the Sybase Replication Agent commands shown in Table 1-1.

**Table 1-1: Replication Agent commands**
Command name	Description	Page
log_system_name	Returns the path to the Sybase Replication Agent system log file.	§
pdb_capabilities	Returns a list of the Sybase Replication Agent capabilities.	§
pdb_date	Returns the current date and time from the primary data server.	§
pdb_execute_sql	Executes the specified SQL statement in the current database.	§
pdb_gen_id	Returns the current value of the database generation ID; updates the value of the database generation ID.	§
pdb_get_columns	Returns a list of all the columns in the specified table.	§
pdb_get_databases	Returns a list of all the databases in the primary data server.	§
pdb_get_primary_keys	Returns a list of all the columns that make up the primary keys in the specified table.	§
pdb_get_procedure_parms	Returns a list of the parameters for the specified procedure.	§
pdb_get_procedures	Returns a list of all the procedures in the specified database.	§
pdb_get_sql_database	Returns the name of the database specified for SQL statement execution.	§
pdb_get_tables	Returns a list of all the tables in the specified database.	§
pdb_ownerfilter	Returns a list of owners whose objects will be filtered for initialization; adds, removes owners to the list.	§
pdb_set_sql_database	Specifies the database to be used for SQL statement execution.	§
pdb_setrepcol	Returns replication marking status; enables or disables replication for all marked columns or a specified column.	§
pdb_setrepddl	Returns DDL replication status; enables or disables replication for DDL statements.	§
pdb_setrepproc	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.	§
pdb_setreptable	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.	§
pdb_skip_op	returns, adds or removes record identifiers from a list of records to skip in processing.	§
pdb_truncate_xlog	Truncates the Sybase Replication Agent transaction log.	§
pdb_version	Returns the type and version of the primary data server.	§
pdb_xlog	Returns names of transaction log objects; creates transaction log base objects in the primary database; removes transaction log base objects from the primary database.	§
quiesce	Stops current Log Reader activity, processes data in internal queues, drops connections, and puts Sybase Replication Agent in Admin state.	§
ra_config	Returns help information for configuration parameters; sets the value of a configuration parameter.	§
ra_date	Returns the current date and time from the Sybase Replication Agent server.	§
ra_devicepath	Changes the disk device path for a log device recorded in the RASD.	§
ra_dump	Places a dump marker in the Sybase Replication Agent transaction log.	§
ra_help	Returns help information for Sybase Replication Agent commands.	§
ra_helparticle	Returns information about the primary database from the RASD.	§
ra_helpdb	Returns information about the primary database from the RASD.	§
ra_helpdevice	Returns information about primary database log devices from the RASD log device repository.	§
ra_helpfield	Returns information about fields (columns in tables, or input parameters in stored procedures) from the RASD.	§
ra_helplocator	Returns LTM locator field values.	§
ra_helpuser	Returns information about primary database users from the RASD.	§
ra_locator	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.	§
ra_maintid	Returns the Maintenance User for the Sybase Replication Agent connection.	§
ra_marker	Emulates the Replication Server ra_marker system function, placing a marker object in the Oracle redo log	§
ra_migrate	Places a marker in the Sybase Replication Agent transaction log.	§
ra_set_login	Sets the Sybase Replication Agent admin user login and password.	§
ra_statistics	Returns statistics for either a specified Sybase Replication Agent component or all components; resets statistics for all components.	§
ra_status	Returns the current Sybase Replication Agent state.	§
ra_truncatearticles	Truncates older versions of primary database articles in the system data repository in the RASD.	§
ra_truncateusers	Truncates older versions of primary database users in the system data repository in the RASD.	§
ra_updatedevices	Updates the log device repository in the RASD.	§
ra_version	Returns the Sybase Replication Agent version.	§
ra_version_all	Returns Replication Agent, primary data server, Replication Server, and communications driver versions.	§
rasd_backup	Backs up the Replication Agent System Database (RASD).	§
rasd_restore	Restores the Replication Agent System Database (RASD).	§
resume	Starts replication for the current active log and puts Sybase Replication Agent in Replicating state.	§
rs_create_repdef	Creates a replication definition at Replication Server for a marked table and procedure, or for all marked tables and procedures.	§
rs_drop_repdef	A replication definition for a table is dropped at the Replication Server.	§
shutdown	Shuts down Sybase Replication Agent.	§
suspend	Immediately stops all Log Reader activity, drops connections, and puts Sybase Replication Agent in Admin state.	§
test_connection	Tests Replication Agent connections.	§
trace	Returns current trace flag settings; changes a specified trace flag.	§

The remaining sections in this chapter describe each Sybase Replication Agent command in detail.