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 

Doubt in running DB2 from IMS

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


Joined: 10 Apr 2005
Posts: 12
Topics: 5
Location: India

PostPosted: Wed Jul 13, 2005 11:24 pm    Post subject: Doubt in running DB2 from IMS Reply with quote

Hi
I have a question while executing DB2 via IMS.
It is clear that we have to use DFSRRC00 to invoke DB2. Also in the parm card we give many details. But the question is what does the last Y (the one in blue) stand for.
Because some people say that if we change the Y to N it will point to the test region. If it is Y it points to the production region.
Is it true and if which region of which database does it point to.

//STEP02 EXEC PGM=DFSRRC00,REGION=0K,
// PARM='DLI,DSNMTV01,M677367B,40,0000,,0,,N,0,T,,,Y'

Thanks in advance
Gautham
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 Jul 14, 2005 7:46 am    Post subject: Reply with quote

In this DLI example, PGM=DFSRRC00 indicates that you are executing IMS. You use the second parameter set to DSNMTV01 to connect to DB2. The last parameter in your list indicates whether or not to use the IRLM (lock manager) which has nothing to do with test or production.

Check the DFSRESLB DD card for the IMS system load library. The database dataset names should also be included in the JCL.

The DB2IN DD card indicates the DB2 sub-system name as well as plan name.
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 -> Database 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