Truncating Staging Tables

[David_Tsatsi]

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

[Matt_Godfrey]

Hi David,

I believe all that data will be lost

[Kip_Lamb]

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: [phone] | Mobile: [phone] | [e-mail]

<mailto:[e-mail]>[cid:image001.jpg@01D21EF5.6EBDF7D0][cid:image002.png@01D0928A.5E056B60]

 

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

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

[Matt_Godfrey]

David,

Have we answered your question?