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
 

 

Using DB2 on mainframe from distributed systems (LUW)

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

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Tue Oct 27, 2009 4:38 am    Post subject: Using DB2 on mainframe from distributed systems (LUW)
Reply with quote

Hi,

Can someone tell me how to connect and use DB2 data stored on mainframe from AIX system using C lanaguage.
My application is written in C and uses other database management system. Its running on IBM aix. Now, we have to migrate our database on DB2 running on Mainframe.

I think, I have to use db2 connect. But anyone knows how to use db2 connect , what APIs are available for C ?
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 Oct 27, 2009 7:44 pm    Post subject:
Reply with quote

Hello,

Suggest you talk with the mainframe dba(s). They may have already established the way to do this on your system.

Even if it has not already been set up, they will have to be involved.
Back to top
View user's profile Send private message
parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Wed Oct 28, 2009 1:10 am    Post subject:
Reply with quote

Yeah. You are right.

Can MTK from IBM be useful?
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 Oct 28, 2009 1:29 am    Post subject:
Reply with quote

Hello,

Probably not. . . Did you do any review about what MTK is?

http://www-01.ibm.com/software/data/db2/migration/mtk/

http://www-01.ibm.com/support/docview.wss?rs=203&uid=swg27009230#freakquest__whatmtk

were the first 2 hits. . .
Back to top
View user's profile Send private message
parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Wed Oct 28, 2009 9:32 pm    Post subject:
Reply with quote

Well, I had some review of MTK.

I am planning to use MTK to convert the source ( ORACLE) database objects into target ( DB2) counterparts.

However, I understand that application will have to be manually converted.

MTK seems to be origionally planned for DB2 running on LUW. But seems like they have extended suppport for DB2 on Z / OS ( mainframe) as well.
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 Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm
No new posts Interface from Mainframe to Confluenc... hblun CLIST & REXX 4 Tue Sep 20, 2016 5:47 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Admin Openings with CTS enikhilk Mainframe Jobs 0 Tue Sep 13, 2016 10:13 am


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