 |
 |
Archives of the TeradataForum
Message Posted: Fri, 15 Sep 2006 @ 17:53:18 GMT
| Subj: | | Re: DIrty Reads and Multiload locks |
| |
| From: | | John Graas |
| | When you create/replace your "dirty read views" make sure that you include 'LOCKING TABLE databasename.tablename FOR ACCESS' in the DDL
statement. This should allow you to access the underlying tables while the data is being loaded and prevent any lock contentions. | |
Easier now is to add the clause "LOCKING ROW FOR ACCESS"
This will cover all tables in the Select SQL. Teradata will upgrade ACCESS locks to the TABLE level when required, but will only use row locks
(single AMP) when it can.
jdg
www.jgraas.com
| |
