Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: How to Disconnect Users During Loads
From:   McCall, Glenn D

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016