Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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.

  1. Click the start menu icon or press the Windows key on your keyboard to open the Start Menu:

  2. Click the small arrow in the bottom left-hand corner of the Start Menu to show the installed application:

  3. 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 access:


  4. At 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



  5. Once the application has started click the New Connection to a Database icon:

  6. Select DB2 for Linux, UNIX, and Windows from the list of database types in the left panel:


  7. 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 sessions

  8. Click Test Connection to confirm your values are correct then click Finish

  9. From the Task Launcher window click Develop

  10. On the next screen click Create and run SQL or XQuery statements

  11. Click Finish on the New SQL or XQuery Script dialog

  12. 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

  • No labels