IBM Db2 is one of the largest and most sophisticated enterprise DBMS packages ever created. Db2 is a product of IBM, the company that invented SQL. This topic is the fourth step in a five topic sequence showing a complete installation, and then utilization, of Db2 for Developers from the very beginning. Please see Install Db2 topic for basic info on Db2.
Disclaimer: These topics were accurate when written, using the versions of installation software indicated. Third party packages can and do change, so this topic may be out-of-date. It is provided as an example of how such installations can be approached.
Installing Db2 and readying it for use in typical installations involves five steps:
Install Db2 Client
This is the fourth topic in the above sequence of steps.
So far, we have installed Db2 on our target machine. We enabled use of Db2 through networks. We have created a database within Db2 called gisdb. Now, we will install IBM client software on a desktop machine, so we can connect from that remote machine to the server machine that hosts our Db2 installation.
We are using a 64-bit Windows 10 desktop system on which we have installed Manifold. We will install Db2 Client software on that machine, so we can connect to the server machine on which we installed Db2.
Every machine running Manifold which will be used to connect to Db2 must have IBM's Db2 Client software installed. If we want to connect to our Db2 installation from a remote machine running Manifold, we must install Db2 Client software on that remote machine. That is easy to do. The following procedure is done on the desktop machine we will use as our remote, client machine.
IBM packages client software for Db2 within what is called an IBM Data Server Client Package. The best way to get the latest version of the client software is to download the latest Fix Pack for the current IBM Data Server Client Package. In IBM support nomenclature, an iFix is an interim Fix that is issued between cumulative fixes. A Fix Pack is issued about every 4 months and contains a cumulative collection of all interim fixes and fix packs since the last release.
After the package downloads, right-click on it and choose Run as administrator.
These topics use a file called v11.1.4fp4_ntx64_dsdriver_EN.exe (73.44 MB), which is Fix Pack 4, English only.
Press Next.
Check I accept.. and press Next.
Accept defaults and press Next.
Press Install.
Press Finish.
The installation may raise a concluding dialog. Click No.
We have now installed client software on our desktop machine. We can launch Manifold and Manifold will be able to connect to Db2 using IBM's own native client software. In the next topic, we look at an example of connecting to our Db2 installation and using the gisdb database we have created.
Continue this case study on installing Db2 with the Connect to Db2 topic.
See the preceding topic: Create a Database in Db2
Jump to the beginning of the case study: Install Db2
File - Create - New Data Source
Big List of Formats and Data Sources
Example: Switching between Manifold and Native Query Engines