CICS DB2 connection to multiple databases

gosia · New User Joined: 19 Apr 2006 Posts: 10

Can anyone help me to resolve my issue.
My CICS program has to connect to two different BD2 databases.
I know I have to have an RCT entry for my CICS pgm and
I need a Plan. How can I create Bind card to include 2 different owners
and qualifiers in one bind?

Gosia

Here is my card for one plan: CPSTBL01

BIND PLAN (CPSTBL01) +
PKLIST (PEDBL@00.* +
, PEDBLR00.* +
, PEDBLW00.*) +
OWNER (DBPNY01) +
QUALIFIER (DB2PEDB) +
ACTION (REPLACE) +
VALIDATE (BIND) +
ISOLATION (CS) +
RELEASE (COMMIT) +
EXPLAIN (YES) +
RETAIN
END

rajandhla · Posted: Fri Jun 30, 2006 7:31 pm

why can't we think of creating alias to other database

it's just a thought..

Regards
jai

gosia · New User Joined: 19 Apr 2006 Posts: 10

I should be more specific on this issue.
My CICS pgm links to DB2 pgm - own1.dbase and it calls API (which accesses own2.dbase). Db2 pgm and API pgm are already included in packages. In bind card I included above, I only refer to package list for API. Now I have to modified this card to include another packages for second DB2 application. Both programs access different databases
with different qualifiers and different owners.

And this is where I do not know, how can I combine them both in one PLAN?

Gosia

rashmi.ranjan75 · New User Joined: 20 Feb 2006 Posts: 34

i don't think it is possible to use different owners in your case. you need to bind the plan with same owner. you keep the same owner for the plan in two databases and i am sure it will solve ur purpose.

Regards
Rashmi