REplication of DB2 V9.7 tables with XML columns
in [DB2]
|
Prev: function with input parameter not found (SQL0440N)
Next: Can Someone please help me with my Computer stuff? 08275
From: alexs on 27 Jan 2010 10:19 Hi, I'm running Db2 V9.7FP1 64 bit on two Linux servers. I've got a number of databases living on the "primary" server that I'd like to replicate onto the "secondary" server. FWIW the primary box is redhat RHEL5.x and the secondary server is a Ubuntu VmWare image. I've been trying to use a the replication centre admin tool (V9.7.0.441) to set up SQL replication between the two servers. However, in common with what seems like every other time i try and copy database tables that have XML columns in them I get part of the way through the setup and promptly get errors relating to the fact that a table has an xml column in it. Don't have the specific errors to hand at the moment,but as a general question, should I be able to use the replication centre to set up a master/slave relationship between two db2 server for database containing XML data? Any attempt to copy tables with XML columns via the control centre always seem to fail. Any pointers to appropriate documentation much appreciated FYI what I'm planning on doing is having a master db for data entry and a number of salve databases that users have read only access to. the slave databases are front ended by a hardware load balancer which distributes inbound connections to a pool of databases. DB health checking performed by a java servlet running on each database machine that copnnects to a database, performs a query and disconnects. servlet returns an http 200 if thigs are o.k. and 403 of not. Load balancer uses servlets to decide if a database is up or not. Rgds Alex
From: Henrik Loeser on 30 Jan 2010 10:26 You can use either HADR or Q Replication with the XML data type. What you try to do looks a lot like you want HADR. http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.ha.doc/doc/c0006354.html Henrik
From: Serge Rielau on 1 Feb 2010 23:05
Some more feedback from "backstage": We do support XML data type with the free-of-charge SQL replication. Customers need to buy the DB2 Homogeneous Replication Feature and use Q Rep to be able to replicate XML data. See replication information center: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp Transformations on the XML document during replication are also supported (e.g., using XMLQUERY expression to apply a subset of a document at the target). -- Serge Rielau SQL Architect DB2 for LUW IBM Toronto Lab |