Archives of the TeradataForum

Message Posted: Tue, 15 Apr 2003 @ 01:29:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

A common approach is to create a views database. The views database has 1:1 views onto tables in another database. Each view contains a locking for access clause.

For example datbase pdata contains a table t1. The following will create a view (in a database named pdata) onto that table which enforces the locking for access.

Replace view pview.t1
Locking pdata.t1 for access
Select * from pdata.t1;

These create views could be automatically generated from the dbc.tables table

Select 'Replace view pview.' || trim (both from tablename) || ' locking
pdata.' || trim (both from tablename) || ' for access select * from pdata.'
|| trim (both from tablename) || ';'
From dbc.tables
Where databasename = 'pdata' and tablekind = 't';

Then point all your users at the pview database and everything should work just fine.

I hope this helps

Glenn Mc

BTW. If the loads you are talking about require exclusive access to a table then even the locking for access might cause the load task to be blocked.

	<Prev	Next>		<<First	<Prev	Next>	Last>>