The application is purely a DB2 business lookup with logging to a table so it would be easy to rewrite it as a native SQL stored procedure but as the MPP will live on for some time it means 2 versions of the code in 2 different languages for the foreseeable future. The alternative would be to have a WLM based external stored proc call the same COBOL business routines, 1 set of code (that's already written) called from 2 places. Sweet.
But from what I remember the versioning and change management isn't as strong with the WLM syntax, it's difficult not to have a brief outage when promoting new code because there's only 1 collid in the proc syntax and 1 WLM library. Are Workload managed stored procs on their way out? That's making me lean towards recommending duplicating the code in native.
BTW is there an update to this excellent but dated redbook? http://www.redbooks.ibm.com/abstracts/sg247604.html?Open
Sr DBA, Database & Mainframe Support
Health Solutions Delivery Br.
Health Services Cluster
4th flr, 49 Place d'Armes
Kingston ON K7L 5J3
[login to unmask email]<mailto:[login to unmask email]>