Connect to mainframe DB2

Posted on 2010-01-09
Medium Priority
Last Modified: 2012-05-08
How can we connect to a DB2 database in mainframe using  DB Artisan (or) RapidSQL ?
 Pls provide me both Solution DB Artisan and  RapidSQ

Thanks, Oramcle
Question by:Oramcle
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 57

Accepted Solution

giltjr earned 1200 total points
ID: 26276034
According to Rapid SQL you need either a DB2 Gateway or DB2 Client:


And according to DB Artisan site:


They support DB2 also, I would assume using either a DB2 Gateway or DB2 Client.

Now some products, such a Toad, include a limited use license of DB2 Client.  Since both products you mention say they support DB2, for z/OS you could check their documentation or use the support services provided by the companies.

These days normally TCP/IP is used to connect to DB2 on z/OS, so you do need to make sure that DB2 on z/OS is setup  for TCP/IP.  If it is not then either it needs to be setup to use TCP/IP or you need to figure out how to get connected to the mainframe using SNA.
LVL 37

Assisted Solution

momi_sabag earned 400 total points
ID: 26276230
you will need to install a db2 gateway such as db2 connect, or if these tools use jdbc to connect to the database you will need to get the universal jdbc driver with the proper licensce (and in this case, no db2 gateway is required)
LVL 13

Assisted Solution

sameer2010 earned 400 total points
ID: 26305515
Yes, DB2 connect is a good feature. You can then connect XLS or desktop application with DB2 residing on mainframe.

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question