New developerWorks Article About DB2 AESE's Federation and Q Replication

I get a lot of questions about what's included in DB2 Advance ESE where data federation (virtualization) and replication technologies are concerned.  Some of them are simple licensing questions about what you get for no extra charge.  However, many more are about basic functionality. developerWorks helps out in both cases.  For the questions about function, there's a new article on developerWorks.  It's part of a series IBM is doing to detail the benefits of DB2 Advanced ESE.  The article is currently featured on developerWorks' main page for Information Management topics.  If you need an introduction to IBM's data federation or Q Replication technologies, this is an excellent place to start (of course, it says I wrote the article, so maybe I'm biased :)


If you have any questions about the "no cost" aspects of DB2 AESE's Federation or Q Replication, there's a developerWorks group for each technology.  dW's Federation Server group answers questions about the data federation built into DB2 and InfoSphere Warehouse as well as what's in the stand-alone Federation Server product.  dW's Replication Server group answers questions about IBM's two data replication technologies called Q Replication and SQL Replication, including questions about what comes with DB2 and InfoSphere Warehouse.



Views: 642


You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Comment by david t on August 10, 2011 at 10:42pm

Hi, JB,


I understand where you are with this.  I don't know enough about your configuration to know if EXTSHM will help.  However, the tech support people will be working with experts... probably the same people I would need to talk to about this option :)  I recommend continuing to work with IBM through the PMR.




Comment by JB Chakrapani on August 9, 2011 at 11:37am

Hi David,

Thanks for your response. I already went thru the recommendations from the info center and most of them are already in place and it hasnt made a huge difference. I am looking for a 16000 rows /sec apply or somewhat close to that . One of the recommendations from the q rep guide was to set the EXTSHM to ON on the target side, which the q rep tuning guide says will allow more than 16 apply agents to run on target. Does it make any difference to do that on a 64 bit instance? I did not think that parameter applied to 64 bit system.  Have you or anyone you know used that setting and did it help?  I do have a PMR open, but I am just looking around for people who might have done something differently while the tech support is working on it. - JB

Comment by david t on August 8, 2011 at 10:44pm

Hi, JB,

We typically measure data replication in rows per second.  If my math is right :)  7m rows is less than 2000 rows/second.  That should be very easy to achieve under most circumstances.  Have you tried the Tuning section for Q Replication in the DB2 Informatio Center?  If so, and you're still having trouble, please open a PMR and the tech support team will help you get with the right people to determine what the issue is.




Comment by JB Chakrapani on August 2, 2011 at 2:38pm
Hello David, your blog has very useful information on Q rep. I am currently working on a rapid copy setup using Q rep (db2 to db2 ) on the luw platform. We have stuck a snag with the Q rep performance , we are only able to replicate 7 mill msgs per hour. We have 37 mill messages to apply. Working still to tune mq and other areas. Do you have some suggestions? Or some links that could  point us in the right direction? Thanks in advance! - JB

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service