PDCR tables CleanUp

General

PDCR tables CleanUp

Hi ,can someone tell me the steps to CleanUp PDCR tables.

5 REPLIES
Enthusiast

Re: PDCR tables CleanUp

Where are your maintenance routines for PDCR installed to migrate data from the DBC tables to PDCRData? This is where you should also find the script(s) for maintaining the PDCRData tables.

PDCRData should include a table named PDCR_Table_Retention that is used by the maintenance routine to determine which historical data is to be purged from the PDCR tables based on the specified column in ColName and the value in Ret_Period. It also includes the PPI information for those tables defined with a PPI.

Fan

Re: PDCR tables CleanUp

@above

Is there any way other than the automated script to clean the PDCR Database?

Teradata Employee

Re: PDCR tables CleanUp

Using the PDCR automated scripts to purge the PDCR database is highly recommended as the process has been engineered to ensure consistency in table retention.  The stored procedure and table mentioned above provides a simple interface for adjusting retention timeframes for all tables managed by the PDCR purge process.  Creating manual scripts to purge these tables is not ideal.

Enthusiast

Re: PDCR tables CleanUp

You can modify  PDCR_Table_Retention table with proper retention periods for required dictionary tables.

so that daily purging job will automatically delete rows from PDCR tables.

To check the status of daily jobs please check the 'PDCRDATA.PDCRLoad_Hst' table

Fan

Re: PDCR tables CleanUp

Hi,

Thanks for the information.From the table PDCRDATA.PDRCLoad_Hst table I can see one of the PDCR marco that is LoadLogOnOff_hst was last run on 4-Apr-2016.Then after it stopped running.Can you please tell me how I will find out the reason behind this.

Thanks.