Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

CICS DB2 connection to multiple databases

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gosia

New User


Joined: 19 Apr 2006
Posts: 10

PostPosted: Fri Jun 30, 2006 7:12 pm    Post subject: CICS DB2 connection to multiple databases
Reply with quote

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
Back to top
View user's profile Send private message

rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Fri Jun 30, 2006 7:31 pm    Post subject:
Reply with quote

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

it's just a thought..

Regards
jai
Back to top
View user's profile Send private message
gosia

New User


Joined: 19 Apr 2006
Posts: 10

PostPosted: Fri Jun 30, 2006 7:44 pm    Post subject: Re: CICS DB2 connection to multiple databases
Reply with quote

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
Back to top
View user's profile Send private message
rashmi.ranjan75

New User


Joined: 20 Feb 2006
Posts: 34

PostPosted: Tue Jul 04, 2006 7:48 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us