DB2 9.7 replication and truncate table

#1

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.

is somewhere clearly stated in docs that truncate is not supported?

#2

On Dec 22 2010, 9:21*am, hsn_ <kolar.ra... (AT) gmail (DOT) com> wrote:

Quote:

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.

is somewhere clearly stated in docs that truncate is not supported?

Hi,

The fact that TRUNCATE statement is not supported by replication is
mentioned at
http://publib.boulder.ibm.com/infoce...ddlhandle.html.

Naresh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DB2 9.7 replication and truncate table

comp.databases.ibm-db2 comp.databases.ibm-db2

DB2 9.7 replication and truncate table - 12-22-2010 , 11:21 AM

Re: DB2 9.7 replication and truncate table - 01-05-2011 , 11:37 AM