Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Facing SQLCODE -927 issue

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Mon May 27, 2013 3:44 pm    Post subject: Facing SQLCODE -927 issue
Reply with quote

Hi,

When I was trying to recreate a scenario in test env which is repeating in production , I faced this issue .

A cobol Db2 program is abeding in production with Sqlcode -927 while When I compile it in my test library and run it goes fine .. I have tried it with bad input data and good data as well but it is not abendiing in test .. I think the problem is with PARMS are passed to DSNHPC when precompiling or to the IGYCRCTL but not yet sure about it .. I took the compile listing from production of the program and tried to math the compile option used with test but no luck..

When I run my job with production library it gets abend with SQLCODE -927 and when i compile -bind the same code in my test library it is going
fine . I have checked the DYNAM and NODYNAM option for compile they too looks fine since the program is compiled with NODYNAM option in production..

PLease suggest , Below is the definition of -927 code.

SQLCODE -927:

THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS
NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND

Explanation

In the TSO environment, the user has attempted to execute an application
program without first establishing the correct execution environment by
issuing the DSN command. In the IMS, CICS, or call attachment facility
(CAF) environment, the user has attempted to execute an application program
that is not using the correct language interface module.


Thanks
Sumit
Back to top
View user's profile Send private message

don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Mon May 27, 2013 5:32 pm    Post subject:
Reply with quote

If compiled with NODYNAM in production, check to see which flavour of DSNHLI was picked up at link edit time. Chances are that the wrong attachment facility (IMS, CICS, Call Attach, RRSAF and TSO are the usual choices) was used to link your program.
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Mon May 27, 2013 6:59 pm    Post subject: Facing Sqlcode -927 Issue
Reply with quote

Thanks for your reply .. I just found in the Load Listing of the program is that the compiler option was used as NODYNM but if I see the link edit parm it says DYNAM in the dafault values for CICS release level ..

* ------Default CICS Release level------
CICSRLSE = '4.1' ;
CB2#PRM3 = ',OFFSET,MAP,DYNAM' ;

Is this the problem causing -927?

My program is not using CICS.

Thanks
Sumit
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Mon May 27, 2013 7:17 pm    Post subject:
Reply with quote

I dont know how I can check the flavour of DSNHLI but here is the info about DSNHLI which I found in load listing

EXTERNAL DSNHLI

NAME TYPE LENGTH DDNAME SEQ MEMBER
DSNAA * CSECT 108 SYSLIB 32 DSNHLI

DSNELI * CSECT 296 SYSLIB 32 DSNHLI

DSNWLI LABEL
DSNHLI LABEL

Please suggest how can I check the flavour of DSNHLI

Thanks
Sumit
Back to top
View user's profile Send private message
Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Tue May 28, 2013 11:14 am    Post subject: Reply to: Facing SQLCODE -927 issue
Reply with quote

Are you using CAF, -927 says you should run it under the DSN interface

-927 has been discussed umpteen times, here is the link to one such discussion.


http://ibmmainframes.com/viewtopic.php?t=23571&highlight=927
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Tue May 28, 2013 11:38 am    Post subject:
Reply with quote

Hi Dave,

Thanks for the information !!

Actually I did see most of the posts related to -927 before posting mine one but the thing is that My scenario is bit diffrent where I am facing this issue only in production and not in TEST.I tried to map all the BIND options for test and prod but no luck however few option were diffrent in test but changing them couldnt rectify the problem , Load listing says that the program was compiled with NODYN option of Cobol in 2009 .One thing to consider here is that we migrated to extended version of DB2 after 2009 , I dont know if that can cause a problem?

I see in production and number of programs are runing as "PGM=DB2PGMNAME" so Should that be a problem when I am runing in same manner in test and getting RC=00?


Thanks
Sumit
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Tue May 28, 2013 1:22 pm    Post subject:
Reply with quote

Can you post the JCL?
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Tue May 28, 2013 2:51 pm    Post subject:
Reply with quote

//JOBLIB DD DSN=TESTLT.LTC248A0.PROD.LOAD,DISP=SHR
// DD DSN=SYS7.DBATTACH.LOAD,DISP=SHR
// DD DSN=PRODLW.LOADLIB.CICS,DISP=SHR
// DD DSN=PRODLW.LOADLIB.BATCH,DISP=SHR
// DD DSN=D2D6.DB2.DSNEXIT,DISP=SHR
// DD DSN=SYS7.D2DG.SDSNLOAD,DISP=SHR
// DD DSN=SYS7.D2DG.RUNLIB.LOAD,DISP=SHR
//*JOBINCL INCLUDE MEMBER=DGIC&DB2SYS
//*
//PS130 EXEC PGM=LTC248A0
//*********************************************************************
//DBAIN DD DSN=TESTLT.CNTLCARD(LT248APN),DISP=SHR
//*LTRVALD DD DSN=TESTLT.SB740P00.SRTVALD.LT740740,DISP=SHR
//LTRVALD DD DSN=TESTLT.SB740P00.SRTVALD.LT740740.BKP,DISP=SHR
//COMPINDX DD DSN=TESTLT.SB240P00.COMPIND1.LT740740.D0521,DISP=SHR
// DD DSN=TESTLT.SB240P00.COMPIND2.LT740740(0),DISP=SHR
// DD DSN=TESTLT.SB240P00.COMPIND3.LT740740(0),DISP=SHR
// DD DSN=TESTLT.SB240P00.COMPIND4.LT740740(0),DISP=SHR
// DD DSN=TESTLT.SB240P00.COMPIND5.LT740740(0),DISP=SHR
// DD DSN=TESTLT.SB240P00.COMPIND6.LT740740(0),DISP=SHR
//ERFILE DD DSN=TESTLT.ERROR.FILE.OUT(+1),DISP=(NEW,CATLG,DELETE),
// DCB=(LRECL=44,RECFM=FB,DSORG=PS,BLKSIZE=0),
// SPACE=(CYL,(10,1),RLSE),UNIT=SYSDA
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSABOUT DD SYSOUT=*
//SYSDBOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1218
Location: Israel

PostPosted: Tue May 28, 2013 3:01 pm    Post subject: Reply to: Facing SQLCODE -927 issue
Reply with quote

A wild guess:
maybe you have to add to the JOBLIB:
Code:
// DD DSN=SYS7.D2DG.DSNWLM,DISP=SHR
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Tue May 28, 2013 3:56 pm    Post subject:
Reply with quote

Thanks !!

But I do not have this lib in my system. no WLM libraries
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Tue May 28, 2013 4:45 pm    Post subject:
Reply with quote

In Addition to my last post

What I found today is that If the LInk Edit step contains below
//SYSIN DD *
INCLUDE SYSLIB(DSNELI)

then it blows down by -927
and if it contains
//SYSIN DD *
INCLUDE SYSLIB(IGZEBST)

then it is going fine

Any body have any idea about it pls? why it is like this?

Thanks
Sumit
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Tue May 28, 2013 6:34 pm    Post subject:
Reply with quote

DSNELI is the TSO attach facility. If you link DSNELI, then your program has to run under TSO.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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
This topic is locked: you cannot edit posts or make replies. Facing Error IGYPS2072-S murugan_mf COBOL Programming 2 Wed Jun 01, 2016 7:12 pm
No new posts Facing error IGYPS0037-S murugan_mf COBOL Programming 9 Wed Jun 01, 2016 4:36 pm
No new posts REXX Screen not working due to LINKED... sundarkudos CLIST & REXX 1 Mon May 09, 2016 1:44 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us