Quest SQL Optimizer for IBM DB2 z/OS ensures optimal SQL performance by generating alternatives and testing SQL for maximum application performance.
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 |
Quest SQL Optimizer for IBM DB2 z/OS ensures optimal SQL performance by generating alternatives and testing SQL for maximum application performance.
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 |
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
Click
Review the following for additional information:
Select Connection | Description |
Connection |
Click Tip: Click |
Select Schema and SQLID | Description |
Schema |
Click |
SQLID |
Click |
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
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 display connection information about a z/OS database in Toad.
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center