i've an issue with -927 sqlcode. i'm running an IMS- COBOL pgm in batch. the pgm has DB2 IO routines. i get -927 return from all the DB2 routines. can any one please help me in this.
below is the relevant jcl information used.
//RUNTEST EXEC PGM=DFSRRC00,COND=(0,NE),
// PARM=(DLI,DSNMTV01,IMXSTBPS,,,,,,)
//*
//****--------------------------------------------------
//* THE SUB ROUTINE NAME SHOULD BE PASSED AS SYSIN PARAM
//* FOLLOWING ARE THE VALID VALUES.
//* 1. IMXPOLD
//****--------------------------------------------------
/*
//DDITV02 DD *
DB2T,SYS1,DSNMIN10,,A,-,,IMBOLPL,IMXSTBSR
END
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
hy gowtham_1982,
you are running your program in any ims region...
therefore you should note:
if your program is ABC, there must be also any db2 plan ABC,
otherwise it is not possible to connect to db2.
the other possibility is, you create a RTT, which gives the db2 plan.
nevertheless, you need to link edit the correct language interface
to the program (i.e. DFSLI000)
you are running your program in any ims region...
therefore you should note:
if your program is ABC, there must be also any db2 plan ABC,
otherwise it is not possible to connect to db2.
the other possibility is, you create a RTT, which gives the db2 plan.
nevertheless, you need to link edit the correct language interface
to the program (i.e. DFSLI000)
martin9
you mean to say that it is a must to have a plan. my issue is, the component does not have any DB2 statements on its own. it invokes two routines which have DB2 statements. moreover, my component does not also have any plan at all.
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
hy gowtham_1982,
this is the reason for the abend.
you need the plan for connection to db2.
the plan must have the name of the run unit,
which is your program name. (for ims only).
if you run db2 with ikjeft01, i.e.
RUN PROGRAM(prog) PLAN(batch),
the plan can have anyname, but not with
ims. only if you use any RTT-Macro, which is
turning the db2 plan to any other value under ims.
db2 requires always a plan, even it is connected
with ims. your program might have no db2 statements,
but your run unit, ok?
this is the reason for the abend.
you need the plan for connection to db2.
the plan must have the name of the run unit,
which is your program name. (for ims only).
if you run db2 with ikjeft01, i.e.
RUN PROGRAM(prog) PLAN(batch),
the plan can have anyname, but not with
ims. only if you use any RTT-Macro, which is
turning the db2 plan to any other value under ims.
db2 requires always a plan, even it is connected
with ims. your program might have no db2 statements,
but your run unit, ok?
martin9
hi martin9,
let me throw some more light on this issue. actually, we are including another Db2 IO routine as a fix to an issue. there is already a DB2 routine invoked by the component. after my change, while testing i'm facing the issue -927. this will be actually tested online and will run as online in live environment. since that cannot be accomplished now, i try testing it as batch. i get the same issue in online too. kindly give me idea on this.
this is the reason for the abend.
you need the plan for connection to db2.
the plan must have the name of the run unit,
which is your program name. (for ims only).
if you run db2 with ikjeft01, i.e.
RUN PROGRAM(prog) PLAN(batch),
the plan can have anyname, but not with
ims. only if you use any RTT-Macro, which is
turning the db2 plan to any other value under ims.
db2 requires always a plan, even it is connected
with ims. your program might have no db2 statements,
but your run unit, ok?
martin9
hi martin9,
let me post you the real situation i face. please read my previous post if you get more confused. please skip the bolded area if you feel uncomfortable.
I'm testing a RPC(remote procedure call) component. generally rpc's will have a different front end and the back end will be mainframes. in my case it is HTML front end and COBOL+IMS+DB2 mainframe backend.
i need to test my fixes i've made with a different teter. please see my previous post for the fix.
i get connectivity issue resulting with -927 sqlcode for both the routines i invoke. because for this i don't get the desired output. even if i test the fix in batch or through the rpc tester, i face the same issue. i xpedited the component and found the issue.
martin9, now what i feel is having a PKG component for my SRC may help. that is the only possible try out to be done. even in that i need a clarification if you can help.
as in my case, my component is invoking two different DB2 routines with different plans which are IMBOLPL and IMMOLPL. then how can i have a pkg for my component.
please let me know if you need more info or clarifications if any.
