Connect to the Database

SQL Optimizer for IBM DB2 z/OS

Connect to the Database

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create a connection

  1. Click .
  2. Review the following for additional information:

    Connection Manager Description

    Database alias

    Select name of the database to which you want to connect.

    User

    Enter the user name required to connect to the database.

    Password

    Enter the password associated with the user name. Click Save password to remember the password.
    Connection Details Description

    Catalog node

    Displays the local catalog node name.
    Database name Displays the local database name or DCS Alias.
    Subsystem Displays the name of the subsystem.
    System Displays system IP address and port number.
    Comment Displays comments.
    Installed Database Clients Description

    Connect using

    Select the appropriate database client or click to browse.
  3. Click Connect or Close.

To display connection information about a z/OS database in Toad.

  1. Connect to a z/OS DB2 database.
  2. Open Editor, type: "-DIS DDF" and execute.

Note: Consult the IBM DB2 documentation for more information on z/OS DB2 databases.

Note: If you use a non-administrator windows account to run SQL Optimizer for IBM DB2 z/OS, the login account must belong to the "DB2ADMIN" or "DB2USER" user group. You may also need to add "DB2ADMIN" or "DB2USER" if the user login belongs to the Administrator user group.