sql code 927 abend

shaktieswararao.Hazaru · New User Joined: 25 Sep 2010 Posts: 20 Location: Hyderabad

Hi,

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 ?

Thanks,
shakti.

Rohit Umarjikar · Posted: Tue Jul 15, 2014 2:26 am

You could be self reviewed the below links, please have a look.
ibmmainframes.com/about56480.html
ibmmainframes.com/about24955.html
ibmmainframes.com/about23571.html

shaktieswararao.Hazaru · New User Joined: 25 Sep 2010 Posts: 20 Location: Hyderabad

Hi Rohit,

Before posting my query i went through al the links which you have shared.
The solution for my problem is not there in the above links.

The above links tells us on how to resolve the abend for Ikjeft01 utility, but i'm using DFSRRC00 utility.

//STEP200 EXEC PGM=DFSRRC00,COND=(0,NE),REGION=3M,
// PARM=(BMP,OFCNT,OFCNT,,,,,,,0,0,,,
// &IMSID,&IMSID.BMP)

I checked few components using DFSRRC00 for db2 but their parm is as below.

//STEP010 EXEC PGM=DFSRRC00,REGION=&CORE,
// PARM='DLI,DSNMTV01,EH004&CYC,,,,,&CKPID,,,,,,&DBRC'

I dont have any idea if I have to make any changes to the parms to call db2.

don.leahy · Posted: Tue Jul 15, 2014 6:20 pm

Where is the job failing? Are there any DB2 calls prior to the call to the stored procedure?

Is the stored procedure a Cobol program? If so, was it compiled and linked to use DSNRLI (RRSAF attachment)?

If these questions make no sense to you, contact your local site support and/or DBA for advice.

Marso · Posted: Tue Jul 15, 2014 7:12 pm

And the code you received is -927, not 927

shaktieswararao.Hazaru · New User Joined: 25 Sep 2010 Posts: 20 Location: Hyderabad

Hi,

Where is the job failing? The step where i'm trying to connect to db2 server from my sub module.

Are there any DB2 calls prior to the call to the stored procedure? No, there are no calls prior to this.

Is the stored procedure a Cobol program? Yes
was it compiled and linked to use DSNRLI (RRSAF attachment)? yes, I compiled it and used DSNRLI.

I have also inlcuded the db2 stored proc load lib in my step.

Rohit Umarjikar · Posted: Wed Jul 16, 2014 12:02 am

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.

shaktieswararao.Hazaru · New User Joined: 25 Sep 2010 Posts: 20 Location: Hyderabad

Hi Rohit,

The DFSRRC00 parm is as below

PGM=DFSRRC00,COND=(0,NE),REGION=3M,
PARM=(BMP,OFCNT,OFCNT,,,,,,,0,0,,,
&IMSID,&IMSID.BMP)

OFCNTCTL is the main module name but in the parm it is as OFCNT.
I have created the plan name as OFCNT.

I have given the LCT in chgman as below.

INCLUDE RESLIB(DFSLI000)
NAME OFCNT(R)

please advise.

Rohit Umarjikar · Posted: Wed Jul 16, 2014 1:28 am

don.leahy · Posted: Wed Jul 16, 2014 7:27 pm

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.

shaktieswararao.Hazaru · New User Joined: 25 Sep 2010 Posts: 20 Location: Hyderabad

Hi,

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.