Getting actual names of the transaction log objects

Because Sybase Replication Agent generates the names of its transaction log objects using its own algorithms, there is not any obvious correlation between the name of a primary object and the names of the transaction log objects (such as shadow tables) that record replicated operations for the primary object. To find out the names of transaction log objects associated with a primary object, use the following procedure.

StepsTo determine the names of transaction log objects associated with a primary object

  1. At the Replication Agent administration port, invoke the pdb_xlog command with no keywords:

    pdb_xlog
    

    The pdb_xlog command returns a list of the transaction log base objects.

  2. At the Replication Agent administration port, invoke the pdb_setrepproc command with no keywords:

    pdb_setrepproc
    

    The pdb_setrepproc command returns a list of all stored procedures marked for replication, including all the Replication Agent transaction log objects associated with each marked procedure.

  3. At the Replication Agent administration port, invoke the pdb_setreptable command with no keywords:

    pdb_setreptable
    

    The pdb_setreptable command returns a list of all tables marked for replication, including all the Replication Agent transaction log objects associated with each marked table.