Hi, I'm running DB2 7.2 with fix9. I don't see anyway of replicating summary tables. Only way was to replicate all base tables and define the summary table on the target. We are trying to avoid that as the base tables have lot of data. Any suggestions appreciated.
Hello, Thanks for the response. Creating a view still points to the summary tables. Don't u think so? Even if it doesn't, don't I have to create triggers when deletes,inserts ,updates occur. The deletes,inserts,updates cannot be figured out as every refresh dumps compete data. Its like full delete and inserting into the table. Correct me if I'm missing something.
I tried just setting up replication straight from a summary table, and it allowed me to set it up no problem (I did not try to actually replicate the data though). Create you target table to be a normal table that looks like the summary table.
Hey Andy, I already tried creating the summary tables as regular tables on the target side. When I did the capture, zero records were going into CD tables. I'll check that again. All other tabs were being captured. Can u please let me know in case u replicate successfully. I want to make sure I'm not missing anything.
Is this the sequence you followed:
Create a view for the summary table data on source
Create the summary table as a regular table.
I currently do not have a working replication environment, so I cannot test if the replication actually works. What I did was create a summary table. Defined it as a replication source. Then created a subscription set that included it. That is it. I just wanted to see it DB2 would let me do that much.
How did you create the summary table (DDL)? This may have an impact on the replication.
That is what I was asking. Refresh deferred summary tables are only updated manually (whenever the REFRESH TABLE SQL is executed).
Try creating it with REFRESH IMMEDIATE instead. Then see what happens.