Skip to Content
0
Former Member
Jun 25, 2010 at 04:50 PM

ICNV STOP EVERYTHING

21 Views

We are partitioning a large table using ICNV. Data Transfer initally ended, 100% done. Outage for switch is scheduled at a future date.

We needed to alter a partition limitkey without business outage. We executed Control > Stop Everything.

Then DB2 ALTER TABLE... ALTER PARTITION... for QCMtable, followed by an offline REORG of QCMtable.

Row counts show unexpected results, prompting this question:

If Data Transfer has initially ended (100% done), does STOP EVERYTHING have any effect? Or does Data Transfer still "wake up" periodically to synchronize changes, regardless of whether you have "STOPPED EVERYTHING"?

Thanks for your help, Joan