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
 

 

SQLCODE Code -927

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

New User


Joined: 23 Dec 2005
Posts: 61
Location: Providence , US

PostPosted: Thu Jul 12, 2007 11:18 pm    Post subject: SQLCODE Code -927
Reply with quote

Hi Guys
I am running a DB2 Program in the IMS environment. The sample JCL is attached
Code:

//LCJ31803 EXEC PGM=&IKJEFT1,DYNAMNBR=20,                         
//         PARM='%OPA269 DB2(&SYSTEM) PGM(&CLP522) PLAN(&CLP522)',
//         ACCT='FILL DB2 CARD',                                 
//         COND=((03,LT,LCJ31801),(03,GT,LCJ31802))               
//SYSTSPRT DD SYSOUT=&PRTU                                       
//SYSPROC  DD DSN=SYS2.CTLCDS,DISP=SHR                           
//CARDOUT  DD DSN=&INDB2,                                         
//         DISP=(NEW,CATLG,DELETE),                               
//         SPACE=(TRK,1),                                         
//         DCB=(LRECL=80,BLKSIZE=800,RECFM=FB)                   
//SYSTSIN  DD DUMMY                                               
//SYSUDUMP DD SYSOUT=&PRTU                                       
//LCJ31804 EXEC PGM=&DFSRRC0,TIME=&P522TIM,       
//         ACCT='MTS EXTRACT ADV TERM',           
//         PARM='DLI,DSNMTV01,&PSB,,,,,,&CLP522M',
//         COND=((04,LT,LCJ31801),(04,GT,LCJ31802))
//STEPLIB  DD DSN=&RESLIB,DISP=SHR                 
//         DD DSN=&CLP522A,DISP=SHR               
//         DD DSN=&CLP522S,DISP=SHR               
//         DD DSN=&CLP522L,DISP=SHR               
//         DD DSN=&LINKLB2,DISP=SHR               
//DFSRESLB DD DSN=&RESLIB,DISP=SHR                 
//DFSVSAMP DD DSN=&CLP522V,DISP=SHR               
//IMS      DD DSN=&TDBDLIB,DISP=SHR               
//         DD DSN=&DBDLIB,DISP=SHR                 
//         DD DSN=&TPSBLIB,DISP=SHR               
//         DD DSN=&PSBLIB,DISP=SHR                 
//DDITV02  DD DSN=&INDB2,DISP=&ODK                 
//DDOTV02  DD DSN=&OUTDB2,                         
//         DISP=(NEW,CATLG,DELETE),               
//         SPACE=(TRK,(1,1),RLSE),                 

The DB2 card is being built in Step 3 of the Proc. The 4th step is responsible for executing it in the DB2 environment. I have given the relevant DB2 libraries in this step. I also matched the CONTOKEN on the package with that on the DBRM. They are in sync. I am pasting the SQL error message
Code:

*     CRITICAL DB2 ERROR DETECTED     *                                         
* DB2  SQLCODE =       927-                                                     
* DB2 FUNCTION = CLAIMCSR OPEN ERROR                                           
* FORMATTED DB2 ERROR MESSAGE:                                                 
* DSNT408I SQLCODE = -927, ERROR:  THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN 
*          THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE
*          INVOKED UNDER THE DSN COMMAND                                       
* DSNT418I SQLSTATE   = 51006 SQLSTATE RETURN CODE                             
* DSNT415I SQLERRP    = DSNELI SQL PROCEDURE DETECTING ERROR                   

To me it seems that it is able to establish the connection to DB2 but failing while it trying to open the cursor as evident from the message "DB2 Function". Can someone tell me how I can rectify this error ?
Thanks in advance
Back to top
View user's profile Send private message

sudip_ghanvat

New User


Joined: 05 Apr 2007
Posts: 15
Location: pune

PostPosted: Mon Jul 16, 2007 11:40 am    Post subject:
Reply with quote

What a -927 says is the a user has tried to execute an application program without establishing the proper execution environment.

In the IMS environment check that the application was link-edited with or is dynamically allocating the correct language interface module. The language interface modules required in each environment are as follows:

IMS: DFSLI000
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 JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm


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