 |
 |
Archives of the TeradataForum
Message Posted: Tue, 20 Feb 2007 @ 19:31:26 GMT
| Subj: | | Re: Blocking and queuing |
| |
| From: | | Vinay Bagare |
Anomy.Anom wrote:
| | I have a scenario wherein ETL jobs are interrupted by a nightly back up and seem to be queuing up. However, when the HUT lock is released,
the jobs do not continue to process. | |
| | Is this to be expected, or should the jobs just continue as if they were blocked by another session? | |
I think it should.
You should also ensure that backups are complete.
Archival jobs may miss backups on objects that have an active Fastload, MLOAD, etc.
Thanks,
Vinay Bagare
Technical Manager
Amp'd Mobile Inc
www.ampd.com
| |
