Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
-927 issue

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
gowtham_1982
Warnings : 1

Active User


Joined: 02 Dec 2005
Posts: 109

PostPosted: Wed Apr 05, 2006 10:50 am    Post subject: -927 issue
Reply with quote

hi all.

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

//DDOTV02 DD DUMMY,DCB=(RECFM=FB,LRECL=4096,BLKSIZE=)
//*
//IMS DD DISP=SHR,DSN=IMST.DBDLIB
// DD DISP=SHR,DSN=S00P.CHGMAND.IMXP.#000145.PBL
// DD DISP=SHR,DSN=IMSP.BT.PSBLIB
// DD DISP=SHR,DSN=IMSP.OL.PSBLIB
//*
//DFSVSAMP DD DSN=IMSVS.PROCLIB(DFSVSAMP),DISP=SHR
//*
//DFSRESLB DD DSN=TIMSVS.RESLIB,DISP=SHR
//*
//IMSLOGR DD DUMMY,DISP=SHR
//*
//IEFRDER DD DUMMY,DISP=SHR
//*
//IMBIFILE DD DSN=IMBT.USTRI.UT.IMXPOLD.I#01,
// DISP=SHR
//*
//IMBOFIL1 DD DSN=IMBT.USTRI.UT.IMXPOLD.O#01,
// DISP=(MOD,CATLG,DELETE),
// UNIT=TESTDA,
// SPACE=(TRK,(5,5),RLSE),
// DCB=(MDLDSCB,RECFM=FB,LRECL=30142,BLKSIZE=30142)
//IMBOFIL2 DD DSN=IMBT.USTRI.UT.IMXPOLD.O#02,
// DISP=(MOD,CATLG,DELETE),
// UNIT=TESTDA,
// SPACE=(TRK,(5,5),RLSE),
// DCB=(MDLDSCB,RECFM=FB,LRECL=31076,BLKSIZE=31076)
//IMBOFIL3 DD DSN=IMBT.USTRI.UT.IMXPOLD.O#03,
// DISP=(MOD,CATLG,DELETE),
// UNIT=TESTDA,
// SPACE=(TRK,(5,5),RLSE),
// DCB=(MDLDSCB,RECFM=FB,LRECL=28800,BLKSIZE=28800)
//*
Back to top
View user's profile Send private message

radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Wed Apr 05, 2006 1:50 pm    Post subject:
Reply with quote

The pgm should be invoked under DSN command.
THE LANGRAGE INTERFACE WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED.
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Wed Apr 05, 2006 1:54 pm    Post subject:
Reply with quote

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)

martin9
Back to top
View user's profile Send private message
gowtham_1982
Warnings : 1

Active User


Joined: 02 Dec 2005
Posts: 109

PostPosted: Wed Apr 05, 2006 6:52 pm    Post subject:
Reply with quote

martin9 wrote:
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)

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.

kindly suggest me ideas.
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Wed Apr 05, 2006 7:23 pm    Post subject:
Reply with quote

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?

martin9
Back to top
View user's profile Send private message
gowtham_1982
Warnings : 1

Active User


Joined: 02 Dec 2005
Posts: 109

PostPosted: Thu Apr 06, 2006 9:58 am    Post subject:
Reply with quote

martin9 wrote:
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?

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.

thanks in advance..

gowtham
Back to top
View user's profile Send private message
gowtham_1982
Warnings : 1

Active User


Joined: 02 Dec 2005
Posts: 109

PostPosted: Thu Apr 06, 2006 12:11 pm    Post subject:
Reply with quote

martin9 wrote:
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?

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.

thanks in advance.......

gowtham
Back to top
View user's profile Send private message
RAJ1965

New User


Joined: 07 Aug 2006
Posts: 6

PostPosted: Fri Sep 22, 2006 4:47 pm    Post subject: Re: -927 issue
Reply with quote

Hi,
At link edit step ensure that DFSLI000 is picked from IMS Libraries not from DSN library.

Your prolem will be resolved
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SIGNAL ON HALT issue packerm CLIST & REXX 0 Fri Oct 20, 2017 6:56 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us