MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

IMS to DB2 connectivity...

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS
View previous topic :: View next topic  
Author Message
dsonsamuel
Beginner


Joined: 25 Mar 2004
Posts: 26
Topics: 16
PostPosted: Thu Aug 11, 2005 10:04 am    Post subject: IMS to DB2 connectivity... Reply with quote
Hi all,
I have initroduced a DB2 query in an existing IMS program. I have compiled and link edited the same. While running I am getting an abend U3057. The problem is with the DB2 connectivity. The existing parm in the run jcl is PARM=(DLI,&mem,&psb,,,,,,N,,,,,N)

Kindly let me know whether I shud change this parm bcoz i have intoduced DB2. If this parm is o.k...pls let me know what else could be wrong.....
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Thu Aug 11, 2005 10:25 am    Post subject: Reply with quote
Quote:

Kindly let me know whether I shud change this parm bcoz i have intoduced DB2. If this parm is o.k...pls let me know what else could be wrong.....

dsonsamuel,

Was their established connection between your IMS region and the DB2 Subsytem ?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA
PostPosted: Thu Aug 11, 2005 10:36 am    Post subject: Reply with quote
You need to set &mem to DSNMTV01 and you will need to code a //DDIVD02 card. See the DB2 Application Programming guide for details.
Back to top
View user's profile Send private message
dsonsamuel
Beginner


Joined: 25 Mar 2004
Posts: 26
Topics: 16
PostPosted: Thu Aug 11, 2005 10:44 am    Post subject: Reply with quote
Kolusu,
Yes there is an established connection between DB2 and my IMS region...

There are some developments now..
I changed the parm to ...
PARM=(BMP,&mem,&PSB,,,N00000,,,,1,15,70,20,
IMS6,,,,,,)

Its now giving U0437... I think the AGN is missing. What is AGN and where should i find it? Please let me know...
Back to top
View user's profile Send private message
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA
PostPosted: Thu Aug 11, 2005 11:03 am    Post subject: Reply with quote
Personally, I would ask someone. Try the DBA.
Back to top
View user's profile Send private message
dsonsamuel
Beginner


Joined: 25 Mar 2004
Posts: 26
Topics: 16
PostPosted: Fri Aug 12, 2005 4:06 am    Post subject: Reply with quote
Thanks a lot Bithead!!!! Ur soulution worked!!!!

Quote:

You need to set &mem to DSNMTV01 and you will need to code a //DDIVD02 card. See the DB2 Application Programming guide for details.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group