Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
DB2 9.7 replication and truncate table
180 views
Skip to first unread message
hsn_
Dec 22, 2010, 12:21:32 PM12/22/10
to
I found that truncate table statement is not correctly replicated via
ASN replication. Truncate is rollforward compatible, so capture
program should be able to detect it from database logs.
ASN replication. Truncate is rollforward compatible, so capture
program should be able to detect it from database logs.
is somewhere clearly stated in docs that truncate is not supported?
Naresh Chainani
Jan 5, 2011, 12:37:56 PM1/5/11
to
Hi,
The fact that TRUNCATE statement is not supported by replication is
mentioned at
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.swg.im.iis.repl.qrepl.doc/topics/iiyrqcapddlhandle.html.
Naresh
0 new messages