Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 15 Nov 2002 @ 21:45:57 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Pausing a Stored Procedure
From:   Patrick Dimitroff


I am doing some investigation for techniques to control table Loading via MLOADs. The particularity is that those MLOADs will run on MVS and on UNIX and may try to update the same tables.

To synchronize the process, we are looking to build a kind of lock table that will be managed by Strored Procedures. If a given table is already taken by another process then the current one will wait until it is turn.

This 'Locking' will occur in a BTEQ preceding the MLOAD step.

Now my problem is to force a Stored Procedure to wait a certain amount of time before rechecking the lock status of a table.

I create a timer routine playing with the current time but I am afraid that it will be a real CPU hug.

Do you have any solution to solve my problem?



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020