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 Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm


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