Hi All,

I am facing a serious problem of CLOB column data column getting
truncated during migration of data and during data refresh (at times).
Can you please let me know is there any settings in DB2 for maximum
column size while migrating the data?

Made an observation that sometimes data is getting truncated during
migration i.e. during export and import and especially during data
refresh.
For example, size of truncated data in target database is consistently
32700 bytes (what could be this magic number??, anywhere any settings?).

Any idea why data is getting truncated during migration and especially
during data refresh.

All suggestions are highly appreciated.

Thanks in advance.


Regards,
Syed


The information contained in this e-mail and any accompanying documents
may contain information that is confidential or otherwise protected from
disclosure. If you are not the intended recipient of this message, or if
this message has been addressed to you in error, please immediately
alert the sender by reply e-mail and then delete this message, including
any attachments. Any dissemination, distribution or other use of the
contents of this message by anyone other than the intended recipient is
strictly prohibited.

Confidentiality Statement:

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.


DB2 & UDB email list listserv db2-l LazyDBA home page