 |
 |
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.
Thanks, --Carrie
| |