Repgen Features
and Benefits
Repgen
Demo Available for download...
-- script name: repaddgroup
-- Features: Adds each replication group to all master sites.
-- NOTE: This file must only be run at the master definition site prod3.
-- Copyright 2002 by .com Solutions Inc.
-- This output file was created by Repgen version 2.2.4 on Fri May 31
13:29:24 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
-- ************** customer_repgroup
-- create the group
execute dbms_repcat.create_master_repgroup(gname =>'customer_repgroup');
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'customer_repgroup',
all_sites => TRUE);
-- add additional master replication site(s)
execute dbms_repcat.add_master_database(gname =>'customer_repgroup',
master =>'prod5', use_existing_objects=>TRUE, propagation_mode=>'ASYNCHRONOUS');
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'customer_repgroup',
all_sites => TRUE);
-- add conflict resolution site priority group
execute dbms_repcat.define_site_priority(gname =>'customer_repgroup',
name => 'site_sp');
execute dbms_repcat.add_site_priority_site(gname =>'customer_repgroup',
name => 'site_sp', site =>'prod3', priority=>100);
execute dbms_repcat.add_site_priority_site(gname =>'customer_repgroup',
name => 'site_sp', site =>'prod5', priority=>90);
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'customer_repgroup',
all_sites => TRUE);
-- ************** static_tables_repgroup
-- create the group
execute dbms_repcat.create_master_repgroup(gname =>'static_tables_repgroup');
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'static_tables_repgroup',
all_sites => TRUE);
-- add additional master replication site(s)
execute dbms_repcat.add_master_database(gname =>'static_tables_repgroup',
master =>'prod5', use_existing_objects=>TRUE, propagation_mode=>'ASYNCHRONOUS');
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'static_tables_repgroup',
all_sites => TRUE);
-- add conflict resolution site priority group
execute dbms_repcat.define_site_priority(gname =>'static_tables_repgroup',
name => 'site_sp');
execute dbms_repcat.add_site_priority_site(gname =>'static_tables_repgroup',
name => 'site_sp', site =>'prod3', priority=>100);
execute dbms_repcat.add_site_priority_site(gname =>'static_tables_repgroup',
name => 'site_sp', site =>'prod5', priority=>90);
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'static_tables_repgroup',
all_sites => TRUE);
