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
 

 

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 Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts SNMP trap from Mainframe bipinpeter Compuware & Other Tools 6 Wed Apr 26, 2017 3:05 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm


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