sql replication question

Mathew_paul · #1 (**permalink**) 11-12-09, 07:01

hi

As sql replication generates spill files in target server
if by accidently the files get deleted, will the apply program regenerate the files of the data is lost
kindly suggest
regds
Paul

Marcus_A · #2 (**permalink**) 11-13-09, 01:30

What DB2 platform (OS) are you referring to?

sathyaram_s · #3 (**permalink**) 11-13-09, 01:41

On luw, As I understand it, the spill files are temp work areas for the apply program .. the data is stil l available in the capture tables and the control tables will be updated only after data is populated successfully to target tables ...

BTW, can you delete these files .. i thought they will be 'in use'

Mathew_paul · #4 (**permalink**) 11-13-09, 04:41

DB2 v8.1.1.112
aix 5.3

Quote:

Originally Posted by sathyaram_s

On luw, As I understand it, the spill files are temp work areas for the apply program .. the data is stil l available in the capture tables and the control tables will be updated only after data is populated successfully to target tables ...

BTW, can you delete these files .. i thought they will be 'in use'

in case my apply program is stopped in that case the files can be deleted.

regds
Paul

przytula_guy · #5 (**permalink**) 11-13-09, 09:56

have you killed apply - if stopping apply with asnacmd command - it will only be stopped after process and clean up all spill files

Mathew_paul · #6 (**permalink**) 11-25-09, 01:43

sir

as spill files generates in target server but the size of each files is different.
The files size is different coz its according to source server means
when there a huge amt of transaction happens for example 5000 MB in source and after that commit happens, so as spill file of 5000MB will be generated in target
Kindly correct me on this ??
regds
Paul

Internet Services

Web Development

Digital Marketing

Consumer Tech