Re: Enterprise Replication

Jonathan Leffler wrote: > Marquis de Bogier wrote: > >> IDS 9.4 (Linux) >> >> I wonder if it's possible to replicate a complete database without >> replicating each table itself. >> We are using a tool which creates new tables, but we can't automatically >> specify the replication command for that new tables from outside that >> tool. >> We always have to look for new tables and, if we found one or more, we >> have >> to enter the replication statement "manually". >> >> For some other circumstances, we cannot use HDR. >> >> So, is there a way, to set up an enterprise-replication for a database, >> which automatically includes replication for new created tables? > > I don't think there is a way at the moment for ER to do that. One > reason is that, in general, the separate ER servers are autonomous, and > may not have the resources available for every table - let alone a need > to copy every table. That said, you have an interesting point. OK - he who knows ER better than I do says: IDS 10.x templates can do the following... cdr define template templatename -M serv1_g -d <dbname> -C always \\ -d <database> --all cdr realize template templatename serv1_g serv2_g serv3_g which will define replicates on all of the tables within the database and replicate them between the three servers. There is another option that will automatically create the tables on the other servers if the tables don't yet exist. That would be --autocreate (and, apparently, there's an optional --dbspace to specify where the table is created). See chapter 6 and appendix A in the ER manual for IDS 10.00 - 25122790.pdf. ER templates are a key new feature of IDS 10.00. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/