DB2 Administration Client Download
Note: The following instructions are for Windows 7 or earlier.
For Windows 10 download the Windows Data Studio Client
For Linux download the Linux Data Studio Client
Installation instructions for the Data Studio Client can be found here
Windows XP Professional, Vista Business/Enterprise/Ultimate, Windows 7 Professional/Enterprise/Ultimate
Minimum: 512 MB (1 GB recommended)
Approximately 500 MB
2. Get the client:
Download the DB2 9.7 Administration Client 32 bit or 64 bit. It is approximately 350 MB in size.
Unzip the files to a directory and run setup.exe (note: in Windows Vista and 7 run as administrator). Select Install Products from the menu.
Select Install a Product
Under IBM Data Server Client Version 9.7 click Install New
Accept the license terms after reading them.
Typical install is fine, otherwise pick custom
You can elect to create an install file but it is not necessary. Click next
The default directory will work, or you can install it somewhere else
If you are not running as an administrator you should enable Operating System Security
finish, wait while it installs
Add databases to the client:
repeat if you wish to configure another database
- start the Configuration Assistant (Start - Programs - IBM DB2 - Set-up tools - Configuration Assistant).
- Select Add Database Using Wizard from the Selected menu
- select "manually configure a connection to a database". Click next.
- select TCP/IP protocol. Click next.
- host name is neptunium.cs.umanitoba.ca, port number is 50000, service name is blank. Click next.
- enter the database name. Click next.
- register the database for ODBC should be checked if you're using ODBC for database connections. Click next.
- operating system is Windows, instance name is DB2. Click next.
- system name is neptunium, host name is neptunium.cs.umanitoba.ca, Operating system is Windows. Click next.
- select "use authentication value in server's DBM configuration". Click finish.
If you have comments or questions about this page,
please direct them to Jeff Durston or Ken Drewniak