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
(b) Download IBM Data Studio client Install for Windows.
2. Installing IBM Data Studio.
(a) Extract the downloaded file << ibm_ds4120_win.zip >>
(b) Go to extracted folder and click launchpad.exe to start the IBM Data Studio Client launchpad.
(c) Select Administrative Installation or Update
(d) Click Install to install the package.
(e) In Install Packages window, select the check box and click Next.
(f) Read the terms in the license agreements. If you accept, select the check box and click Next.
(g) Confirm on the installation directory. Click Next.
(h) Select any other languages to be installed beside English (I'm leaving English as the only one checked). Click Next.
(i) Select the feature. In this installation, I also check 'Simplified product option' and 'SQL execution' which are not checked by default. Click Next.
(j) Review the installation summary and click 'Install' to start the installation.
(k) Package is installed successfully.
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.
(b) Choose the workspace and click OK.
(c) An overview of IBM Data Studio
(d) Right Click 'All Database' and click 'New Connection to a Database'.
(e) Select 'DB2 for Linux, UNIX and Windows' and fill in database connection details.
(f) Test Connection and click Finish if connection succeeded.
(g) You can see the list of Maximo's tables now.
(h) Filter for 'ticket' and right click on 'TICKET' table -> Data -> New Select Script
(i) Run a simple Select statement.
(h) You can see the result under SQL Results -> Result panel.
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?