Replication Agent object names

There are two variables in the transaction log component database object names shown in this chapter:

prefix – represents the one- to three-character string value of the pdb_xlog_prefix parameter (the default is ra_).
xxx – represents an alphanumeric counter, a string of characters that is (or may be) added to a database object name to make that name unique in the database.

The value of the pdb_xlog_prefix parameter is the prefix string used in all Replication Agent object names. The value of the pdb_xlog_prefix_chars parameter is a list of the non-alphanumeric characters allowed in the prefix string specified by pdb_xlog_prefix. This list of allowed characters is database-specific. For example, in Microsoft SQL Server, the only non-alphanumeric characters allowed in a database object name are the $, #, @, and _ characters.

You can use the pdb_xlog command to view the names of Replication Agent transaction log components in the primary database.

See the Replication Agent Administration Guide for details on setting up log object names.

Table objects

Insert and delete permissions are granted to Public only on the DDL shadow table for the database name prefixddl_trig_xxx. No permissions are granted on the other tables.

Procedure objects

Table 4-10 lists the procedure objects that are considered Replication Agent objects. The sp_SybSetLogforReplTable and sp_SybSetLogforReplProc procedures are created in the Microsoft SQL Server mssqlsystemresource system database. Although execute permission on these procedures is granted to Public, only the Replication Agent pds_username user is able to successfully execute the procedures because only the pds_username user is granted select permission on the sys.sysschobjs table. No permissions are granted on the other procedures when they are created.

The stored procedures listed in Table 4-10 have no effect when executed outside the context of replication.

**Table 4-10: Replication Agent procedure objects**
Procedure/Table	Database name
Marks/unmarks an object	prefixmark_xxx
Verifies an object	prefixcheck_xxx
Retrieves the ID of the last committed transaction	prefixlct_sql_xxx
Marks/unmarks a table	sp_SybSetLogforReplTable
Marks/unmarks a procedure	sp_SybSetLogforReplProc

Marker objects

Table 4-11 lists the marker procedures and marker shadow tables that are considered Replication Agent objects. No permissions are granted when these procedures and tables are created.

**Table 4-11: Replication Agent marker objects**
Procedure/Table	Database name
Transaction log marker procedure	rs_marker_xxx
Dump marker procedure	rs_dump_xxx
Transaction log marker shadow table	prefixmarkersh_xxx
Dump marker shadow table	prefixdumpsh_xxx

Trigger objects

Table 4-12 lists Replication Agent trigger objects.

**Table 4-12: Replication Agent trigger objects**
Object	Database name
Captures DDL commands	prefixddl_trig_xxx
Captures create_table DDL commands	prefixcreatetable_trig_xxx