Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: sql replication question

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    What DB2 platform (OS) are you referring to?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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'
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Oct 2007
    Posts
    246
    DB2 v8.1.1.112
    aix 5.3




    Quote Originally Posted by sathyaram_s View Post
    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

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have you killed apply - if stopping apply with asnacmd command - it will only be stopped after process and clean up all spill files
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Oct 2007
    Posts
    246
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •