Db2 for z/OS on IBM Z - Group home

How useful is to use Db2 Stored Procedures for z/OS?.

  
How useful is to use Db2 Stored Procedures for z/OS?.

I don't know yet. First, we know there are two types of Stored Procedures: Internal and External. Internal Stored Procedures are written in SQL PL and run in DBM1 Address Space whereas External Stored Procedures are written in a high level language like Cobol, C, or JAVA and run in a WorkLoad Manager for Stored Procedures. Both Internal and external need to be declared with the Create DDL Sentence and both are defined in the Db2 Catalog. So, I am right now going deep in the use of Db2 Stored Procedures, coding and testing in my Job's Mainframe. My goal is to improve the performance and to expose the Mainframe assets in a centralized way. In our data center we have the banking core systems in a z15 and the systems of engagement in an Azure Cloud. So this apps outside the Mainframe need to access to data in Db2 Tables and VSAM files. Welcome your feedback and comments about this.

Comments

Wed February 01, 2023 05:12 PM

Good to hear, and good luck! Any findings on the resource and performance should be interesting to hear about. And don’t forget to go api-first in the design of the APIs ;D

Wed February 01, 2023 04:19 PM

Thanks Jerker for your comment. Yes, we are using z/OS Connect (ZCEE) to provide the consumers a REST API. The Stored Procedure has to be converted first in a Db2 Service, via the BIND Services. My point is to use Only Db2 Stored Procedures to access Db2 Tables and Vsam files. There is an SP provided by Db2: DSNACICS.  This SP let to access a Vsam File and expose as a service. I am just in the exploratory phase. I don't know about the response time and the CPU usage. I have to test and take performance measures. The other way is to use Cobol Cics programs and ZCEE to provide the REST API to the consumers.

Wed February 01, 2023 02:34 PM

I would definitely consider creating  REST APIs using zOSConnect to expose the assets in a modern and easily consumed way. The APIs could use DB2restful services if it’s straight up database access and/or include cics applications when cobol programs are involved.