DX Operational Intelligence

Expand all | Collapse all

Truncating Staging Tables

Jump to Best Answer
  • 1.  Truncating Staging Tables

    Posted 10-05-2016 09:04 AM

    Hi Guys

     

    I have pulled data into my staging tables but I tried purging some of the data but the status still says staging in progress. It has been saying that fro quite some time now. What will happen if I go ahead and truncate the staging tables when there is data not migrated from the staging tables.

     

    There is also other data that is still in the staging area and wanted to know what will happen if i truncate the tables.

     

    Regards

    David



  • 2.  Re: Truncating Staging Tables

    Posted 10-05-2016 01:16 PM

    Hi David,

    I believe all that data will be lost



  • 3.  Re: Truncating Staging Tables
    Best Answer

    Posted 10-05-2016 01:45 PM

    The truncate command removes all data from the staging tables. So any data that has not been migrated will be lost. Running the truncate ‘resets’ the tables and frees up disk space. Ideally Data Manager would do this on its own but only if the system reports all data are migrated and no staging/pull jobs are running. If a job gets ‘hung’, it can stop this process. Therefore it is advised to truncate the staging tables to resolve this state (again data not migrated will be lost). The SQL for the truncate commands are in the Data Manager admin guide. You can use CCR gap reports to find how far back you need to go for a catch-up pull after truncating.

    >KIP

     

    Kip Lamb

    Sr Principal Consultant, Presales

    CA Technologies | Bellevue, WA 98005

    Office: +1 512 776 0235 | Mobile: +1 425 591 4358 | Kip.Lamb@ca.com

    <mailto:Kip.Lamb@ca.com>[cid:image001.jpg@01D21EF5.6EBDF7D0][cid:image002.png@01D0928A.5E056B60]

     

    <http://www.ca.com/us/default.aspx>

    <http://www.ca.com/us/default.aspx>



  • 4.  Re: Truncating Staging Tables

    Posted 10-05-2016 03:52 PM

    David,

    Have we answered your question?