Stored procedure , it CALLs native COBOL prog

shivaganeshaa · New User Joined: 11 Aug 2005 Posts: 14 Location: chennai

www.angelfire.com/electronic/mrktheni/techs/project_docs/db2/db2_sp_faq.pdf

Please see Question(faq) # 11.

I am running a stored procedure , it CALLs native COBOL program.
Is it must that I should change my STEPLIB concatenation in JCL used to start WLM –managed address space ?
In the above link please see question 11 , can you provide any more details.

If there is another option , where SYSLIB or STEPLIB must be mentioned.

All help is highly appreciated.

Rohit Umarjikar · Posted: Wed Mar 14, 2012 8:56 pm

As per my knowledge, you do not need to provide any WLM details in steplib/joblib.
These are seperate WLM jobs running which makes your SPs address space available.

shivaganeshaa · New User Joined: 11 Aug 2005 Posts: 14 Location: chennai

Robert Sample · Posted: Fri Mar 16, 2012 12:14 am

You can see the STEPLIB concatenation is question 7. In general, an application programmer would NOT be able to add steplibs to the Application Environment JCL in WLM -- that would have to be done by a systems programmer. Since WLM controls resources for the entire system, not just your DB2 stored procedure, changes to WLM are usually very carefully controlled and verified before implementation.

Unless you are specifically needing APF authorization, you would be best not using it. And since we don't know how your site is set up, nor how it is using WLM Application Enviornments, you are asking about things that can only be answered by SOMEONE WORKING AT YOUR SITE.

Contact your DB2 DBA or site support group for assistance and specific answers to your questions.