DB2 Stored Procedures setup

CICS® IAuses DB2® Stored Procedures to perform complex DB2 tasks.

A stored procedure is an executable code that can be called by other programs. You might choose to use stored procedures for the code that is used repeatedly. Other benefits of stored procedures include network traffic reduction, result sets returned directly to an application, or access to data without granting the privileges to the applications.

Start of changeCICS IA supports both Native and External SQL Stored Procedures. Native Stored Procedures are only supported in DB2 V9.1 or above. For more information about available stored procedures, see CICS IA External Interfaces.End of change

External DB2 Stored Procedures run in a started task called WLM (Work Load Manager) associated with each DB2 subsystem. Sample JCL for a stored procedure can be found in hlq.SCIUSAMP.DB2(CIUSPTSK). The name of the started task must match the one supplied in the CICS IA configuration variable _wlm_.

You can find more information about implementing DB2 Stored Procedures in the DB2 for z/OS Administration Guide.


Concept Concept

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//ciuug16x.html