Joined: 29 Nov 2002 Posts: 382 Topics: 27 Location: Chennai, India
Posted: Fri Jun 20, 2003 4:37 pm Post subject: DB2 Entries for CICS
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.
Joined: 20 Dec 2002 Posts: 80 Topics: 21 Location: Chicago
Posted: Wed Jul 16, 2003 2:16 am Post subject:
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.
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," ..............
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