MVSFORUMS.com :: View topic - DB2 Entries for CICS

through

[^/[Print]\]

MVSFORUMS.com -> CICS and Middleware

#1: DB2 Entries for CICS Author: Manas Biswal, Location: Chennai, India

Posted: Fri Jun 20, 2003 4:37 pm
—
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

#2: Author: Himesh, Location: Chicago

Posted: Wed Jul 16, 2003 2:16 am
—
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

#3: Author: Manas Biswal, Location: Chennai, India

Posted: Wed Jul 16, 2003 4:25 pm
—
Thanks for the links Himesh.

Regards,
Manas

MVSFORUMS.com -> CICS and Middleware

output generated using printer-friendly topic mod. All times are GMT - 5 Hours

Page 1 of 1