0

Is TDWM configuration data e.g. WlcDefs, RuleDefs, SysCons etc. ever purged? I've noticed that whenever some modification is made in TDWM the old configuration data is kept in the table with the field RemoveDate, RemoveTime. Is this data purged after some configured duration? or is it a common practice to purge this data in the industry?

I'm asking this because there are clear instructions about purging the ResUsage and DBQL data in Teradata documents but so far I haven't found anything on TDWM configuration data.

flag

1 Answer

0

Unless you are making a lot of changes to your TDWM configuration, I would not expect these tables to grow at an alarming rate that would require a maintenance routine to purge them.

I would instead focus your efforts on ResUsage, DBQL, and keeping DBC.AccessRights as lean as possible.

link|flag
this means that most of the time people don't play much with their configurations. – Monis Iqbal Nov 25 at 5:34
1 
 We asked Teradata's observation about this and they said that they have seen varied practices, however majority has been the ones who never purge the configuration data. – Monis Iqbal Mar 1 at 12:39

Your Answer

Get an OpenID
or

Not the answer you're looking for? Browse other questions tagged or ask your own question.