Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Single package bind with two different DB2 Databases

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

New User


Joined: 07 Apr 2005
Posts: 56

PostPosted: Tue Jul 19, 2011 5:36 am    Post subject: Single package bind with two different DB2 Databases
Reply with quote

Hi,
I have a requirement where i need to write one cobol db2 program which need to access two different db2 databases on two different DB2 sub system.
That means, i have 2 select sql queries in a single cobol program to read 2 different tables lying in 2 different databses.

Can anybody tell me if it will create any issue during bind? Since, i will have one package i am not sure if it is possible to bind one single package accessing 2 different tables in 2 different databses. I need you expert thoughts on this as quick as possible.

Thanks
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jul 19, 2011 9:03 am    Post subject:
Reply with quote

Hello,

Suggest you do nothing until you talk with your dba and/or other database support people. Many (Most) organizations will not even entertain the concept. . . Maybe yours will.

Also suggest you consider extracting the needed data from one subsystem and then using this extracted (sequential) data to "drive" a process to read the other
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Tue Jul 19, 2011 9:56 am    Post subject: Reply to: Single package bind with two different DB2 Databas
Reply with quote

Quote:
I need you expert thoughts on this as quick as possible.


since we reply on voluntary basis and free of charge,
we do not do as quick as possible, we reply when and if we feel like,
if You/Your organization have time constraints the best thing to do is hire a paid consultant icon_evil.gif

as far as accessing two different DB2 subsystems the answer is the same as the one You got for Your oracle topic,
DRDA
but it looks like You did not care to read and understand the replies given to You!

Quote:
Can anybody tell me if it will create any issue during bind?

why should it ?

the manuals have all the info and the examples needed to implement it,
nothing overly complicated, but not very quick either!

but your support will have to setup the proper infrastructure


BUT ...
Quote:
I have a requirement where i need to write one cobol db2 program which need to access two different db2 databases on two different DB2 sub system.


that' s what I find disturbing, in these organization managed by incompetents , the poor planning,
it is not enough to tell a programmer what tables to use,
some idiot should have cared beforehand to plan for the proper setup
and not put the whole load on the last unfortunate wheel of the carriage icon_biggrin.gif
Back to top
View user's profile Send private message
vinit_infy
Warnings : 1

New User


Joined: 07 Apr 2005
Posts: 56

PostPosted: Tue Jul 19, 2011 5:51 pm    Post subject:
Reply with quote

Thank enrico, i just requested if someone can help me asap. nothing else.

Oracle is now out of picture, because i got dump in db2 tables itself but the database is different. Anyways thanks for your comments.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 20, 2011 9:07 am    Post subject:
Reply with quote

Hello,

Quote:
i just requested if someone can help me asap. nothing else.
You have been here 6 years and seen many topics & replies.

Whi might you believe it appropriate to request anything asap icon_sad.gif

If you really need something in a hurry, hire someone who can provide the answer immediately. Your sense of urgency is not shared by anyone here. . .
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 More than 1 Include criteria for sing... Roy Ware SYNCSORT 6 Wed Sep 13, 2017 11:45 pm
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Full health checks of IMS databases ashek15 IMS DB/DC 1 Sat Apr 01, 2017 8:34 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us