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
 

 

problem in running IMS DB2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
krishna_mf

New User


Joined: 31 Jan 2007
Posts: 56
Location: banglore

PostPosted: Sat Aug 11, 2007 4:00 pm    Post subject: problem in running IMS DB2 program
Reply with quote

hi,
I am using the below JCL for running a BMP program which contains both DB2 and IMS calls. In output the IMS calls are running successfully but for DB2 I am getting SQL code -927. (description of -927 :THE LANGRAGE INTERFACE WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND). I specified correct subsystem name DSN3 in SSM parameter. I am not able to get where the problem is. Can anyone please help me.


//IMSRUN JOB 1,IMS,MSGLEVEL=1,PRTY=11,CLASS=T,MSGCLASS=A,REGION=512K

// SET MBR=SN0200,PSB=,IN=,OUT=SN040,

// OPT=N,SPIE=0,TEST=0,DIRCA=000,

// PRLD=,STIMER=,CKPTID=,PARDLI=,

// CPUTIME=,NBA=,OBA=,IMSID=IMS1, AGN=IVP,

// SSM=DSN3,PREINIT=,RGN=512K,SOUT=A,

// SYS2=,ALTID=,APARM=,LOCKMAX=

//G EXEC PGM=DFSRRC00,REGION=&RGN,

// PARM=(BMP,&MBR,&PSB,&IN,&OUT,

// &OPT&SPIE&TEST&DIRCA,&PRLD,

// &STIMER,&CKPTID,&PARDLI,&CPUTIME,

// &NBA,&OBA,&IMSID,&AGN,&SSM,

// &PREINIT,&ALTID,

// '&APARM',&LOCKMAX)

//STEPLIB DD DSN=IMS810.&SYS2.SDFSRESL,DISP=SHR

// DD DSN=IMS810.&SYS2.PGMLIB,DISP=SHR

//PROCLIB DD DSN=IMS810.&SYS2.PROCLIB,DISP=SHR

//SYSUDUMP DD SYSOUT=&SOUT,

// DCB=(LRECL=121,RECFM=VBA,BLKSIZE=3129),

// SPACE=(125,(2500,100),RLSE,,ROUND)

//SYSPRINT DD SYSOUT=*


Also output of /DIS subsys dsn3 is showing status is connected
Back to top
View user's profile Send private message

0d311

Guest





PostPosted: Sat Aug 11, 2007 8:23 pm    Post subject:
Reply with quote

Hi,

I'm not sure but have you included the DB2 libraries in the PGMLIB? Also, in our shop, we run DB2 programs using IKJEFT01.

BTW, here's a similar post..

http://ibmmainframes.com/about6073.html
Back to top
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm


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