Connectivity to your database is provided using IBM Data Studio. This section describes how to setup a connection to your database but does not provide general information on how to use the product.
Note:
Be sure you have received database connection information and credentials via email or case before proceeding. These are required for step 7 below.
Click the start menu icon or press the Windows key on your keyboard to open the Start Menu:
Click the small arrow in the bottom left-hand corner of the Start Menu to show the installed application:
Locate the IBM Data Studio group and launch Data Studio 4.1.1 Client
Optional: You can right-click the icon for Data Studio 4.1.1 Client and pin it to your Start Menu or Taskbar for easy accessAt the Workspace Launcher screen click OK. If you receive an error that the workspace is in use, please ensure that the path matches your username. For example, the path should be
C:\Users\RDC username\IBM\rationalsdp\workspace
Once the application has started click the New Connection to a Database icon:
Select DB2 for Linux, UNIX, and Windows from the list of database types in the left panel:
Fill in the form with the following details:
Database: DB name
Host: DB URL
Port number: DB port
User name: DB username
Password: DB password
Default schema: DB schema
Optional:
Choose Save password to store the password for future sessionsClick Test Connection to confirm your values are correct then click Finish
From the Task Launcher window click Develop
On the next screen click Create and run SQL or XQuery statements
Click Finish on the New SQL or XQuery Script dialog
You can now begin to run SQL statements against your database
For further information and help using IBM Data Studio, please see refer to the IBM Knowledge Center:
https://www.ibm.com/support/knowledgecenter/SS62YD_4.1.1/com.ibm.datatools.ds.nav.doc/topics/ds_landing.html