Load Ingest Data
Results 1 to 2 of 2

Thread: How to create a job to stop CDC

  1. #1
    minh is offline Junior Member
    Join Date
    Oct 2012
    Posts
    6
    Rep Power
    0

    How to create a job to stop CDC

    Hi,

    we have a job running every night on the server that hold CDC...that job is quite memory consuming ...


    I would like to know how i can put in place a scheduled job that will stop the CDC during that moment to free some memory
    and after that re-start again the CDC ...


    i have seen that in the DB "MSXDBCDC" there is 2 procedure called xdbcdc_start/stop
    it only do an update (set= 0) on the table xdbcdc_databases...

    do i have to use that stored proc ??

    Thanks
    Minh

  2. #2
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    By design, the only way to communicate with the CDC process is by means of the database so those procedures xdbcdc_start/stop
    which update the table xdbcdc_databases are the way to go. The CDC instance is watching those tables and acts according to what's in them.

    In general, the memory consumption should not increase over time. It is hard to opine here since there's very little information in the question but the CDC process uses memory to improve performance when applying transactions so very large transactions could use more memory (to a configured limit).
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

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