You don't want to stop spill files. Spill files are where the data is
kept while replication builds the sql necessary to insert the data into
the target. This is a work file for replication. If you get rid of the
spill file replication would lose the data it was replicating.

Frank Crissy
Lead DBA

-----Original Message-----
From: Anthony Liggins
[mailto:db2udbdba-ezmlmshield-x5029143.[Email address protected]
Sent: Tuesday, February 27, 2007 2:38 PM
To: LazyDBA Discussion
Subject: Re: Replication Spill Files


I think those spill files are generated by the type of APPLY statement
issued. I had this same problem but as been a while ago. I'll look this
up~!











"Chip McAllister "
<db2udbdba-ezmlmshield-x26839502.[Email address protected]
02/27/2007 11:22 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Replication Spill Files







I have an "update anywhere" replication that causes "spill" files to be
generated... does anyone have any idea why they're caused and how I can
stop them ?

Chip McAllister
UDB DBA
Tie 293-2505 outside 845-433-2505
BLD 003 2455 South Road Poughkeepsie NY 12601
[Email address protected]


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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