SQL Optimizer for DB2 ZOS 5.6.1 - Installation Guide

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.