I have a dpf instance with a few large tables, which are partitioned, and a number of small tables which are not. I'd like the small table to fully exist on each node of the partition for performance reasons. How do I make db2 fully replicate these small tables to each node?
A:
Did you try searching? Google "db2 replicated tables" and the first hit is a link to the specific documentation for replicated MQTs.
That said: replicated MQTs should be an exception. I've been working with DPF (EEE) for over 10 years, and the number of times that a replicated MQT has become a necessity is very small. DB2 is very smart about shipping broadcasting dimension table data out to the database partitions where the fact tables are located, and this data is cached locally.
Ian Bjorhovde
2010-06-15 20:20:52
I was expecting to find some built in property of the table, rather than setting up MQTs. I've now setup the MQTs, the query optimizer is using them, and performance is 8x better.
brianegge
2010-06-15 20:51:41