---
title: "DB2 Connect: How DB2 to Use as Distributed"
description: "DB2 Connect's purpose in life is to connect applications to data, not one database to another database. Read more."
url: https://srinimf.com/2013/04/06/db2-connect-interfacing-with-distriuted-systems/
date: 2013-04-06
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2013/04/db2-connect.jpg?fit=1200%2C700&ssl=1
categories: ["DB2"]
tags: ["DB2 Tips and Solutions"]
type: post
lang: en
---

# DB2 Connect: How DB2 to Use as Distributed

In 1993, pundits in the computer industry predicted the imminent demise of the mainframe. The computing infrastructure of the future, they pronounced, would be a highly [distributed](https://www.forbes.com/sites/oreillymedia/2014/05/25/everything-is-distributed/#24bbb0801c80)and loosely connected collection of personal computers and client-server systems.

Related[Hadoop: 3 Top Real Time Applications](https://srinimf.com/2018/04/15/hadoop-real-time-applications-examples/)

---

IBM was all but written off as a relevant player in the industry. As IBM tried to re-invent itself through the following ways:

- IBM reduced mainframe prices
- Started giving support to distributed client-server Windows,Linux,Unix
- Earlier DB2 was Mainframe database. Now it is changed to available to Windows, UNIX and Linux
- IBM introduced DB2 connect

**DB2 Connect:**Many people have misunderstanding that DB2 connect only connects distributed applications(DA) to DB2. But this is wrong.

> DB2 Connect’s purpose in life is [to connect](https://srinimf.com/2018/08/06/connect-db2-using-php-engine/) applications to data, not one database to another database

[DB2 Connect](https://www.toadworld.com/platforms/ibmdb2/b/weblog/archive/2015/02/24/a-short-overview-of-db2-connect) simply delivers the SQL from the application to the DB2 database for processing. It does not rewrite it or alter it in any way

[![DB2 connect](https://i0.wp.com/srinimf.com/wp-content/uploads/2013/04/db2-connect.png?resize=620%2C410&ssl=1)](https://i0.wp.com/srinimf.com/wp-content/uploads/2013/04/db2-connect.png?ssl=1)

**What is an application? **

we can say an application means code which issues SQl queries.

It allows access to DB2 servers running under the control of OS/390®, z/OS, i5/OS™, OS/400®, VSE and VM from computer code that is running on other platforms (Linux, UNIX, and Windows).

While DB2 Connect can connect to database servers on all of these platforms, we will be talking mostly about connecting applications to DB2 running under control of z/OS.

DB2 Connect implements this intuitively simple access methodology in one of three different mechanisms:

- Federated databases
- Stored procedures
- SQL functions

Refer more on Db2 Connect:

- [Part-1](http://www.ibm.com/developerworks/data/library/techarticle/dm-0503katsnelson/) and [Part-2](http://www.ibm.com/developerworks/data/library/techarticle/dm-0504zikopoulos/)

Related Posts

- [DB2 Distributed Systems in Zo/S](https://srinimf.com/2014/11/02/db2-zos-distributed-systems/)DateNovember 2, 2014
- [DB2 Distributed Computing – How it Works](https://srinimf.com/2015/11/30/everything-you-need-to-know-about-db2-distributed-computing/)DateNovember 30, 2015
- [DB2: DBA Skills ZO/s Vs UDB](https://srinimf.com/2014/01/13/db2-dba-for-zos-db2-udb-dba/)DateJanuary 13, 2014

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2013%2F04%2F06%2Fdb2-connect-interfacing-with-distriuted-systems%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2013%2F04%2Fdb2-connect.jpg%3Ffit%3D1200%252C700%26ssl%3D1&description=DB2%20Connect%3A%20How%20DB2%20to%20Use%20as%20Distributed)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2013/04/06/db2-connect-interfacing-with-distriuted-systems/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2013/04/06/db2-connect-interfacing-with-distriuted-systems/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2013/04/06/db2-connect-interfacing-with-distriuted-systems/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2013/04/06/db2-connect-interfacing-with-distriuted-systems/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20Connect%3A%20How%20DB2%20to%20Use%20as%20Distributed&body=https%3A%2F%2Fsrinimf.com%2F2013%2F04%2F06%2Fdb2-connect-interfacing-with-distriuted-systems%2F&share=email)
-

### Like this:

Like Loading…