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
 
Retrieving DB2 data across multiple mainframe machines.

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

New User


Joined: 09 Apr 2008
Posts: 83
Location: Chennai

PostPosted: Tue Jul 20, 2010 1:32 am    Post subject: Retrieving DB2 data across multiple mainframe machines.
Reply with quote

Hi,
We have 3 mainframe machines A, B and C in our system. The DB2 database resides in the mainframe machine A and it is where the DB2 tables get updated through different transactions. We need to retrieve the data from this DB2 database,on machine A, from Machine B and C.
One of the approach would be to replicate the DB2 database in Machine B and C as same as in Machine A.
I wanted to know if there is any other approach by which we can retrieve the data.
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 20, 2010 2:36 am    Post subject:
Reply with quote

Hello,

If you replicate the data on the B and C machines, there should be less impact on the transaction processing on machine A.

To do this in real time, suggest you read about DRDA ( distributed relational database access ). There are sometmes significant performance issues. . .
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Tue Jul 20, 2010 8:02 pm    Post subject:
Reply with quote

From my little knowledge, but not very sure, but i think such programs have CONNECT TO ... statement

And the DBPROTOCOL is DRDA in the BIND Card.
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Tue Jul 20, 2010 8:36 pm    Post subject: Reply to: Retrieving DB2 data across multiple mainframe mach
Reply with quote

Hello,

Sometime before we did some comparison study with the DRDA protocol.

Suggest You start from here to setup DRDA

For us the results were not looking good as the DRDA protocol was heavy on the CPU consumption time.....


And the BIND Control Card goes something like this.......


Code:
//SYSTSIN  DD *                                                         
DSN SYSTEM(DA21)                                                       
BIND PLAN(YOURPGM) MEMBER(YOURPGM) -                                   
     LIBRARY ('YOUR.LIB.DBR') -                       
     ACTION (REPLACE), VALIDATE(BIND), ISOLATION (CS) , FLAG (I), -     
     ACQUIRE (USE) , RELEASE (COMMIT)  , EXPLAIN (NO), RETAIN, -       
     OWNER(XXXXXX) , QUALIFIER(XXXXXX) , DBPROTOCOL(DRDA)               
END                                                                     



And to Connect to the Database

Code:
EXEC SQL CONNECT TO
         DB01
END-EXEC



Syam
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jul 21, 2010 4:55 pm    Post subject:
Reply with quote

rahuindo,

You need to go for CDC( Change Data Capture ). Like capturing data from Daily Prod sub-system to warehousing sub-system.

Do you have any DB2 Tools like Log Analyzer, but using tools like that you get any DML activities against a table. It can generate DELETE , INSERT & UPDATE statements, which you can run on other sub-system with a little manipulations.

Also look into CURRENTSERVER option in BIND PLAN.

Thanks,
Sushanth
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 File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 1 Tue Sep 26, 2017 3:35 am
No new posts ejck thru rexx to multiple jobs insid... Susanta All Other Mainframe Topics 5 Tue Sep 19, 2017 1:39 pm
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am

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