Data Dictionary tables that are in the form of logs, which accumulate increasing amounts of data over time. To avoid excess use of perm space, periodically delete older information from the log tables using SQL DELETE requests.
Older log data can also be transferred to other storage media if site policy requires long-term log record retention. You can create backup log tables to store log history and periodically copy data from the active logs to the backup tables or long-term table storage using the BTEQ .EXPORT command, FastExport, or a Backup and Restore (BAR) Software.
Related Information
| Topic | Reference |
|---|---|
| How to clear old logs or copy the data to backup tables | Deleting Old Log Data Manually from System Tables |