I'm facing an issue in copying data from one machine to another using arcmain copy command
ARCHIVE DATA TABLES (UT_TAB.EVENT) (PARTITIONS WHERE (!EVENT_START_DT BETWEEN '2013-10-01' AND '2013-10-31'!)) , ABORT, RELEASE LOCK, FILE = EV13_OCT;
COPY DATA TABLE (DP_TAB.EVENT_OCT) (FROM (UT_TAB.EVENT)), RELEASE LOCK, FILE = EV13_OCT;
but this archive script archive more rows from source machine for eg:
Source Machine event table for month of october has 14,602,977 rows but the archive scripts archive 17,444,874 rows can anyone please help me in this.
We are getting blockings even in online backup. Blocking gets clear once the backup of that DB get completed.
Locks will be applied on DB level or Table level during online backups?
what is the solution to avoid this situation?