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
 
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 How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm

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