SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome

Quest SQL Optimizer for IBM DB2 z/OS ensures optimal SQL performance by generating alternatives and testing SQL for maximum application performance.

Optimize SQL

SQL Optimizer analyzes your SQL statements and generates alternatives for improving performance. It can test these alternatives to identify the best SQL statement for your database environment. Optimizing SQL consists of the following functions:

About SQL Optimizer

Quest SQL Optimizer for IBM DB2 z/OS ensures optimal SQL performance by generating alternatives and testing SQL for maximum application performance.

Optimize SQL

SQL Optimizer analyzes your SQL statements and generates alternatives for improving performance. It can test these alternatives to identify the best SQL statement for your database environment. Optimizing SQL consists of the following functions:

Connections

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

To select a connection

1. Select the SQL Details tab in the main window.

2. Click

3. Review the following for additional information:

   Select Connection	Description
   Connection	Click to select a previously created connection. Tip: Click to open the Connection Manager to create a new connection. Connect to the Database
   Select Schema and SQLID	Description
   Schema	Click to select a schema for the connection.
   SQLID	Click to select your SQLID.

Related Topics

Create Optimize SQL Sessions

About Quest SQL Optimizer for IBM DB2 z/OS

Open Optimizer SQL Sessions

Connect to the Database

Select Connection

Tutorial: SQL Optimizer

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.