|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/12/2009 6:03:17 PM
Posts: 177,
Visits: 64
|
|
We have a facility to teach Multiload,Fastload and BTEQ to use multiple sessions. I wouldlike to understand how this setting works. I.e., If I specify, Set Sessions 5 in BTEQ script how does it work? for example, If I have 5 select statements, 5 insert statements in sequential order in BTEQ script how does Teradata manage the sessions and runs the script.
Is there any documentation that explains how teradata sessions work?
Leo Issac "Wants to Learn More!"
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38,
Visits: 46
|
|
It would be best if you posted this to the Teradata Developer Exchange as this forum will be discontinued.
Please let me know what you mean by "teach" the utilities to use multiple sessions.
FastLoad, MultiLoad, FastExport, et. al. use multiple sessions to get some parallelism out of sending data to Teradata.
The sessions are controlled internally by the utilities.
You indicate how many sessions you would like the tools to use.
Post to ethe Developer Exchange and we can continue this discussion if you would like.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/2/2009 2:59:41 PM
Posts: 1,
Visits: 11
|
|
I have the same question, I have one archive with this:
.set sessions 4
.logon tdpid/usr,pwd
call sp1();
call sp2();
call sp3();
call sp4();
.quit
But they aren´t run in parallel. How can I do execute some stored procedures in parellel using BTEQ?
Thanks.
|
|
|
|