Which version of DB2 are you on?
An external procedure can beat an SQL Procedure in V8 and V8.2 only if it
runs UNFENCED.
I doubt the gain will be significant in V8.2.
Also note that COBOL stored procedures nowadays are rather exotic, albeit
supported.
I have yet to come across a warehousing procedure (batch procing of the
staging table????) which can't be significantly improved by fixing the
algorithm.
Take a look at this article:
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0501rielau/
and
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0411rielau/
There is also a tracer and profiler you can find under my name at the same
site.
Cheers
Serge
"Ritesh" <db2udbdba-ezmlmshield-x26008834.[Email address protected] wrote on
09/22/2005 03:07:12 AM:
> Hi DBAs,
> We are using UNIX AIX system with DB2 as its database. This project is a
> datawarehousing project and we have got procedures( written in DB2) which
> normally take around 10-12 hours to run.
> Is that possible to rewrite these procedures in COBOL which can help in
> performance improvement?
>
>
> Regards,
>
> Ritesh Sinha
>
>
> Whilst this email has been checked for all known viruses, recipients
> should undertake their own virus checking as Xansa will not accept
> any liability whatsoever.
>
> This email and any files transmitted with it are confidential and
> protected by client privilege. It is solely for the use of the
> intended recipient.
> Please delete it and notify the sender if you have received it in
> error. Unauthorised use is prohibited.
>
> Any opinions expressed in this email are those of the individual and not
> necessarily the organisation.
> Xansa, Registered Office: 420 Thames Valley Park Drive,
> Thames Valley Park, Reading, RG6 1PU, UK.
> Registered in England No.1000954.
> t +44 (0)8702 416181
> w www.xansa.com
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
DB2 & UDB email list listserv db2-l LazyDBA home page