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 

DB2 Entries for CICS

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> CICS and Middleware
View previous topic :: View next topic  
Author Message
Manas Biswal
Intermediate


Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India

PostPosted: Fri Jun 20, 2003 4:37 pm    Post subject: DB2 Entries for CICS Reply with quote

Hi,

As per my present understanding, if you want a particular transaction to access a particular plan, you define a set of DB2T/DB2E entries for the same which basically map the transaction to the plan. Today, to my surprise, I saw that the transaction even runs and accesses the DB2 data perfectly without a DB2T/DB2E entry. How is that possible?.
I saw the DB2CONN definition for the CICS region. It also contains the plan name as one of its parameters. Does it so happen that all the transactions by default access the plan name mentioned in the DB2CONN definition?. If that is so, then how do we specify different plan names for different transactions for there is only a single DB2CONN definition for one CICS region?. Do DB2T/DB2E definition override the DB2CONN plan name?.
I thought that DB2CONN entry basically creates a connection between the CICS region and the DB2 subsystem. I did not know that it also creates the mapping between the transactions and the plans.
Any help in this regard will be appreciated.

Thanks and Regards,
Manas
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Himesh
CICS Forum Moderator
CICS Forum Moderator


Joined: 20 Dec 2002
Posts: 80
Topics: 21
Location: Chicago

PostPosted: Wed Jul 16, 2003 2:16 am    Post subject: Reply with quote

Hi Manas,

Came across the following articles explaining the concepts of DB2CONN, and also the neccessity of DB2CONN, DB2E/DB2T starting from scratch.

An excerpt from one of them :
Quote:


Since all transactions that do not have a DB2ENTRY definition default to the Pool, having enough Pool threads is vital to make sure your transactions are not waiting for resources.



CICS-RDO DB2 Interface

Here's another quote from the below article:
Quote:


Here's a tip for getting started with a CICS-DB2 interface definition
(or regrouping if you want to scrap a previous RCT/RDO setup):
let everything run out of the pool. Before rejecting this suggestion,
thinking, "Nothing that simple can be a good idea," ..............



CICS DB2 Performance

regds,
himesh
Back to top
View user's profile Send private message Yahoo Messenger
Manas Biswal
Intermediate


Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India

PostPosted: Wed Jul 16, 2003 4:25 pm    Post subject: Reply with quote

Thanks for the links Himesh.

Regards,
Manas
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> CICS and Middleware 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