Create Support Objects
Before you can create Ingres Replicator support objects for a table, you must have registered it. Support objects include Replicator Server database procedures and the shadow and archive tables, all of which are created individually for each table.
Note: To create support objects, the relationship between the CDDS assigned to the table and local database must be defined. In addition, to correctly configure a horizontally partitioned table, the CDDS lookup table must exist and be populated with the required rows.
To create support objects for a table or all tables
1. Open the Table Registration Summary window, place the cursor on the table where support objects are to be created, and choose Support.
A new menu line appears.
2. Choose ThisTable if you want to create support objects for the highlighted table, or choose AllTables if you want to create support objects for all registered tables.
A yes appears in the Sup column of the Table Registration Summary window next to the table or tables for which you created support objects.
If the table is assigned to a CDDS that is full peer in the local database, a shadow table, archive table, and remote replication procedures are created. If the table is assigned to a CDDS that is protected read-only in the local database, a shadow table and remote replication procedures are created. If the table is assigned to a CDDS that is unprotected read-only in the local database, no support objects are necessary.
Last modified date: 01/30/2023