Archives of the TeradataForum
Message Posted: Fri, 08 Mar 2002 @ 14:07:12 GMT
| Subj: | | Blocking problems |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Friday, March 08, 2002 08:25 -->
Hello all,
How have folks enforced batch windows where you are loading with Multiload. We are having issues of user sessions blocking the '.END
MLOAD' statement, even though they are using access locks. MLOAD needs an exclusive lock for this step.
I have given some thought to setting up a shell script in cron that uses bteq to build the necessary abort session commands and passing
them in on the command line to csnrun. The draw back of this it that it's a hard window instead of event driven off the MVS Mload jobs. Is
anyone doing something like this? It would be nice to abort sessions from MVS because then it could be event driven off of the load jobs
since they vary a little bit in time that they actually run each day. All ideas appreciated........!
| 
