how to run multiple stored procedures in parallel ?

Database
Enthusiast

how to run multiple stored procedures in parallel ?

Hi

I have to run few procs in parallel.

I have created a wrapper stored procedure which calls all the procedures. Presently it calls procs in sequence. How can I call procs in parallel ?

I have tried msr eg:

CALL TEST_PROC1()
;CALL TEST_PROC2()
;CALL TEST_PROC3()
;CALL TEST_PROC4();

However this does not work.

Any suggestions.

Thanks

Raj

Tags (1)
4 REPLIES
Enthusiast

Re: how to run multiple stored procedures in parallel ?

How about a scheduler? Checkin with  version and package such that they are run in parallel.

Enthusiast

Re: how to run multiple stored procedures in parallel ?

then all the procs need diff session.

can we do something within same session ?

Enthusiast

Re: how to run multiple stored procedures in parallel ?

Can you stuff your other stored procs inside one.

Teradata Employee

Re: how to run multiple stored procedures in parallel ?

If you wish to have two or more SPs run concurrently, they must be run on separate sessions. We do not have enough information about what is going to happen inside the procedure to be able to run them in parallel like we do with parallel steps.