Exotic? I would say procedures written in BAL would be exotic, but not
cobol. You can do so much more in a 'real' language than you can ever do
in the pseudocode world of SPL. Since almost everyone knows cobol, it
seems like a perfect fit to me.

-----Original Message-----
From: Serge Rielau
[mailto:db2udbdba-ezmlmshield-x86353675.[Email address protected]
Sent: Thursday, September 22, 2005 5:49 AM
To: LazyDBA Discussion
Subject: Re: Writing db2 procedures in cobol

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-0501rie
lau/
and
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0411rie
lau/

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
>



---------------------------------------------------------------------
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