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

    Unanswered: sql replications question

    as apply progrom fetch the data and dumps in target as spill file and
    starts writing to tables is target, some time two three spill file is very big which takes lot of time to complete a cycle,

    Is there is way to set a parameter to commit after every 100000 records have been written from spill file into tables in target

    kindly suggest
    regds
    Paul

    --- HAPPY NEW YEAR---
    GOD BLESS ALL

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    there is not really a commitcount for apply. there are some settings that allow apply to split the work in smaller peaces ..
    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

Posting Permissions

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