Installing IBM Data Studio in Windows Server 2012 running IBM Control Desk 7.6

March 11, 2016 VincentLo

Now you have a Windows Server 2012 running IBM Control Desk 7.6 and somehow you can't find DB2 Control Center to access the DB2 database. Where do you find it?

IBM Control Desk 7.6 comes with DB2 v10.5 and in this version of DB2, the tool DB2 Control Center is no longer available. There is a new tool which is called IBM Data Studio but this is not installed by default.

 

In this blog, I will walk through on where to download, quick overview of installation in Windows Server 2012 and configuring the database connection to Maximo database in order to try out this IBM Data Studio.

 

1. Downloading IBM Data Studio from http://www.ibm.com/developerworks/downloads/im/data/

(a) Select IBM Data Studio Client

image

 

(b) Download IBM Data Studio client Install for Windows.

 

image

 

2. Installing IBM Data Studio.

(a) Extract the downloaded file << ibm_ds4120_win.zip >>

image

(b) Go to extracted folder and click launchpad.exe to start the IBM Data Studio Client launchpad.

image

(c) Select Administrative Installation or Update

image

(d) Click Install to install the package.

image

(e) In Install Packages window, select the check box and click Next.

image

(f) Read the terms in the license agreements. If you accept, select the check box and click Next.

image

(g) Confirm on the installation directory. Click Next.

image

(h) Select any other languages to be installed beside English (I'm leaving English as the only one checked). Click Next.

image

(i) Select the feature. In this installation, I also check 'Simplified product option' and 'SQL execution' which are not checked by default. Click Next.

image

(j) Review the installation summary and click 'Install' to start the installation.

image

(k) Package is installed successfully.

image

 

3. Configuring the database connection to Maximo database

(a) From Windows start menu, find e.g. ''Data Studio 4.1.2 Client' and click to launch the application.

image

(b) Choose the workspace and click OK.

image

(c) An overview of IBM Data Studio

image

(d) Right Click 'All Database' and click 'New Connection to a Database'.

image

(e) Select 'DB2 for Linux, UNIX and Windows' and fill in database connection details.

image

(f) Test Connection and click Finish if connection succeeded.

image

(g) You can see the list of Maximo's tables now.

image

(h) Filter for 'ticket' and right click on 'TICKET' table -> Data -> New Select Script

image

(i) Run a simple Select statement.

image

(h) You can see the result under SQL Results -> Result panel.

image

 

Well, that's a quick walk through in getting IBM Data Studio to install in Windows Server 2012. What do you think of this new IBM Data Studio compared to the old DB2 Control Center?

 

 

Previous Article
IBM Control Desk 7.6.0.1 fix pack has been released on 19 Feb 2016
IBM Control Desk 7.6.0.1 fix pack has been released on 19 Feb 2016

The new IBM Control Desk 7.6.0.1 fix pack has been released on 19 Feb 2016. It runs on Tivoli process autom...

Next Article
Maximo 7.6 - Release long running database connections feature

Maximo 7.6 - Release long running database connections feature : Turning on and setting up the feature to c...

×

Want our latest news? Subscribe to our blog!

Last Name
First Name
Thank you!
Error - something went wrong!