For one of my project requirement, I have to invoke a db2 sp. The flow is like below.
A(main module) -> calling submodule B -> calling new submodule c-> invoking db2 sp.
I have compiled the new submodule C with bind parm as DYNAM.
In BAU we have IMS and the batch job is using DFSRRC00 utility, this is the first time we are invoking a db2 sp from batch.
I have created the plan for main module A with pckg list of new submodule C and the DB2 sp bind pacakge.
Modified the LCT card for main module as below
INCLUDE RESLIB(DFSLI000)
NAME Mainmodule(R)
When i submit the job it is failing as the sqlcode is 927.
can someone help me with the issue if there is anything i should take care when compiling the modules/LCT cards/changes to the the proc for DFSRRC00 ?
Can you also verify to have a plan name as your Run Unit ( Program) name? in addition also ensure that DFSLI000 is picked from IMS Libraries and not from DSN library.
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
A stored procedure does not run in the same address space as your BMP. It runs in a separate WLM controlled address space. Your local support people or DBA should be able to tell you the name.
Our application DBA advised to use the IMS-DB2 ATTACH as Y for the calling module.
It got resolved by changing the Chgman compile options in calling module with IMS-DB2 attach as Y.
But when i run the job it is throwing U3042 abend.