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.
I've also posted this question at: http://teradataquestions.stackexchange.com/questions/39/tdwm-configuration-data-purging-practices
If you do any sort of historic checks against PDRCINFO.DBQLLogTbl_Hst its useful to join the TDWM.WLCdefs so that I can get the Workload definition other wise I would not understand which workload I was looking at.
So I would say that it is not a good idea to delete it.
true, it's good for historical data and that's my purpose of asking this, dunno if there are people out there who purge it.
On a similar note, I've observed some limitations to viewing such historical data e.g. Teradata does not maintain history of Users, hence if you delete a user then the rules/workloads containing that user would become meaningless. Similarly there is no history for the configurations of the Priority Scheduler data within the Teradata Manager's PSA module.
I had not noticed that . Thanks for the warning. Perhaps disabling the user would be a better practice rather than removal, on the other hand you could find unauthorised users having the accounts reenabled by rookie operators etc.