 |
 |
Archives of the TeradataForum
Message Posted: Mon, 17 Oct 2006 @ 00:15:29 GMT
| Subj: | | Re: Need script for killing sessions automatically for particular user at particular time |
| |
| From: | | Stover, Terry |
Anomy.Anom wrote:
| | We solved a similar issue by giving report users access to views created with 'locking row for access' modifier. Now load jobs can run at
the same time as users run reports. | |
You can still run into locking problems if you are dropping & recreating indexes during your data load. The create index statement takes
an exclusive lock when it updates the dictionary and headers.
| |
