 |
 |
Archives of the TeradataForum
Message Posted: Sat, 21 Aug 2004 @ 14:30:53 GMT
| Subj: | | Re: Iinitiating Parallel processing from Queryman |
| |
| From: | | Dieter Noeth |
Ken Hansen wrote:
| | Has anyone experienced erratic performance on Teradata v 5 in respect of parallel/serial processing of Multi-Step_Requests (MSRs) ? | |
| | An MSR submitted for overnight parallel processing, to insert into an empty table, failed and the third step took many hours to roll back.
My client's DBA then advised that MSR's must be initated via BTEQ rather than Queryman, or wrapped with BT/ET. Is this a misunderstanding? | |
MSRs in Queryman are different from BTEQ: Regardless of the position of the semicolon F9 in Queryman always sends a MSR, whereas F5 always
sends seperate statements.
| | I can prove parallel processing of some short MSRs but the documentation appears ambiguous. Is there a way of checking whether the
request was actually submitted for parallel or serial processing? | |
The only way if the request is still running is to use PMon. If it's finished, there's AFAIK no way.
Btw, F6 Explains are MSR, too.
Dieter
| |
