MVSFORUMS.com

[haqshaik]

Hi,
I need some ideas to decide whether Invoking Stored procedure locally through a CICS program is a better chioce or invoking a cobol cics db2 program is a better choice.I have searched through the google, i got th following cons . I would like to listen from the gurus the pros & cons for the above choice.
The cons are as follows:
1)Stored procedures were really designed to save network transmission time for logic and for multiple SQL statements that are invoked from a remote client. This isn't to say that it's never a good idea to invoke stored procedures locally, just be aware that there are performance implications that you need to consider when determining whether to use stored procedures in a non-distributed application to obtain the code reuse benefits.
2)On z/OS, each execution of a stored procedure will be around 30K instructions. This still means the potential for multiple thousands of stored procedure invocations per second, so this is not a show stopper for all applications, it's just something to be considered carefully for your most performance-sensitive non-distributed applications.
The above points i got from the web. The above comments definitly states that invoking stored procedures is not a good practice. But this is bit vague. when discussing with system architects, I feel having some solid conclusions will help me in desicion making. Can some body throw light what kind of performance issues will be there?

Thanks,
Salauddin

[kolusu]

haqshaik,

Check out these excellent articles.

DB2 stored procedure performance considerations, part one

DB2 stored procedure performance considerations, part two

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[haqshaik]

Thanks Kolusu. I am aware of the TCB's part. This has revelaed many things like enclaves and pretty intresting to Know. Is there any e-mail subscription to these CCR issues?. I will try if we have e-mail subscription. If so please let me know.I have subscribed for db2magzing. I think this will aslo get published from CCR only if i am not wrong.Its free. But so far i did not recieve a single copy.
Thanks,
Salauddin