Shearer, Greg GS wrote ... > Looks like you should use the 'repcfg' command line tool. > Syntax is described in the 'Command Reference Guide'
As I explained privately to Ajay, although repcfg was designed to do command line configuration, its functionality is incomplete. If anyone is interested, look at the source code in $ING_SRC/front/rep/repmgr/repcfg.sc to understand the basic structure and the parts that still need to be implemented. Currently you can only use repcfg to activate or deactivate a CDDS or to create replication keys on a table. There are some other undocumented utilities that repcfg is supposed to replace, namely, ddgensup, ddgenrul and ddmovcfg (used under the covers by VDBA/rmcmd). The former generates support objects for tables, i.e., shadow and archive tables and database procedures. The second one overlaps the CDDS activation/deactivation of repcfg. The latter moves a replication configuration from one database to another. There's also repdbcfg, which is documented in the CmdRef. Although it was originally designed for something called Mobile Replicator, if I'm not mistaken it can be used to configure regular Replicator databases, CDDSs and replication paths. However, these steps can also be done by a simple SQL script that does INSERTs into dd_databases, dd_db_cdds and dd_paths. The one function for which there is currently no command line support is the registration of a table for replication. Although the simple case is easy and can be done with a SQL script that does INSERTs into dd_regist_tables and dd_regist_columns (and UPDATEs dd_last_number), there are other complications such as horizontal partitioning. If anyone is interested in filling in the missing functionality in repcfg and needs any help, please let me know. Joe Abbate Senior Software Engineer Computer Associates [EMAIL PROTECTED] _______________________________________________ Users mailing list [email protected] http://ingres.ca.com/mailman/listinfo/users
