Archives of the TeradataForum
Message Posted: Thu, 23 Oct 2003 @ 20:12:38 GMT
| Subj: || || Re: How to purge content from DBC.DBQL tables |
| From: || || Ballinger, Carrie |
However you end up purging from your DBQL tables (and by collecttimestamp is probably the most sensible), suggest you end logging for all
users before you start such maintenance.
Tech Alert 705 describes a potential problem if a user attempts to delete rows from a DBQL table while data is being written into it by
DBQL. Errors can occur (3161) that may cause the system to reset. DR 84044, when released, will fix this condition, and will be rolled
forward to 5. 0.1 and 5.1 patch releases. The getaround is to disable DBQL before deleting any rows from the DBQL tables.