For transactions against a table to be replicated, the primary table in the primary database must be marked for replication and replication must be enabled for that table:
For ASE: Tables are already marked for replication, based on the setting of sp_reptostandby in the primary database.
For Oracle: The setting of pdb_convert_datetime affects the generated results. For a detailed description of the pdb_convert_datetime configuration parameter, refer to Chapter 2, “Configuration Parameters” in the Mirror Activator Mirror Replication Agent Reference Manual
To mark a table in the primary database
Log in to the Mirror Replication Agent administration port.
Use the pdb_setreptable command to determine if the table you want to mark is already marked in the primary database:
pdb_setreptable pdb_table
where pdb_table is the name of the table in the primary database that you want to mark for replication.
If the pdb_setreptable command returns information that the specified table is marked and replication is enabled, you need not continue this procedure.
If the pdb_setreptable command returns information that the specified table is marked but replication is disabled, skip step 3 and go to step 4 to enable replication for the table.
If the pdb_setreptable command returns information that the specified table is not marked, continue this procedure to mark the table for replication.
Use the pdb_setreptable command to mark the table for replication and specify the name to use for replication:
Use the following command to mark the table for replication using a replication definition with the same table name:
pdb_setreptable pdb_table, mark
where pdb_table is the name of the table in the primary database that you want to mark for replication.
Use the following command to mark the table for replication using a replication definition with a different table name:
pdb_setreptable pdb_table, rep_table, mark
where:
pdb_table is the name of the table in the primary database that you want to mark for replication.
rep_table is the name of the table in the with all tables named rep_table clause in the replication definition for this table.
When marking a table for replication, you can specify that the table owner’s name is sent along with the table name in the LTL. To do this, use the owner keyword after the mark keyword, as shown in the following example:
pdb_setreptable pdb_table, mark, owner
where pdb_table is the name of the table in the primary database that you want to mark for replication.
If the pdb_dflt_object_repl parameter is set to true (the default), the table marked for replication with the pdb_setreptable command is ready for replication after you invoke the pdb_setreptable command successfully, and you can skip step 4 in this procedure.
If the pdb_dflt_object_repl parameter is set to false, you must enable replication for the table before replication can take place.
Use the pdb_setreptable command to enable replication for the marked table:
pdb_setreptable pdb_table, enable
where pdb_table is the name of the marked table in the primary database for which you want to enable replication.
Use the pdb_setreptable command with the all keyword to mark or enable all user tables at once:
pdb_setreptable all, {mark|enable}
where mark or enable are the keywords identifying the action that should be taken against all user tables in the database.
After the table is marked and replication is enabled for the table, you can begin replicating transactions that affect data in that table.
