All Forums Tools
leo.issac 184 posts Joined 07/06
12 Aug 2009
Multiple Sessions Setting in Teradata Tools and utilities

I see that we can set the number of sessions in BTEQ. How does this multiple session setting work in BTEQ?

If I run a Batch script in BTEQ with number of sessions set to more than 1, Will I see the benefit in query run-time? How does 'set sessions ' setting work in BTEQ and in general how does multiple session setting work in Teradata?

Fred 1096 posts Joined 08/04
13 Aug 2009

In general, multiple sessions allow for parallelism when transferring data between the client and the Teradata database.

In the case of BTEQ, multiple sessions are only useful in conjunction with .REPEAT, to allow multiple .IMPORT records to be processed concurrently. The request corresponding to each input record will be assigned to one of the sessions, round-robin.

Claudia 4 posts Joined 09/09
29 Sep 2009

Hello, I have one archive with this:

.set sessions 4

.logon tdpid/usr,pwd

.repeat 4

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.

Fred 1096 posts Joined 08/04
30 Sep 2009

Your script says to call SP1 four times; then call SP2, SP3, SP4 each one time, in sequence. Only the four calls to SP1 are eligible to use the parallel sessions.

To run four different stored procedures in parallel, run four BTEQs.

Claudia 4 posts Joined 09/09
01 Oct 2009

Ok, thank you.

You must sign in to leave a comment.