サポートと今すぐチャット
サポートとのチャット

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright

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:

Functions Description

Optimize SQL Statement

SQL Optimizer uses an Artificial Intelligence engine to execute SQL syntax rules that produce semantically equivalent SQL statement alternatives.

Test Run SQL Alternatives

SQL Optimizer executes statement alternatives to view their execution statistics. This provides execution times for identifying the best SQL statement for your database environment. Test Run SQL Alternatives

 

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:

Functions Description

Optimize SQL Statement

SQL Optimizer uses an Artificial Intelligence engine to execute SQL syntax rules that produce semantically equivalent SQL statement alternatives.

Test Run SQL Alternatives

SQL Optimizer executes statement alternatives to view their execution statistics. This provides execution times for identifying the best SQL statement for your database environment. Test Run SQL Alternatives

 

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

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.

  

セルフ・サービス・ツール
ナレッジベース
通知および警告
製品別サポート
ソフトウェアのダウンロード
技術文書
ユーザーフォーラム
ビデオチュートリアル
RSSフィード
お問い合わせ
ライセンスアシスタンス の取得
Technical Support
すべて表示
関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択