Dell™ 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. See Test Run SQL Alternatives for more information. |
Dell™ 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. See Test Run SQL Alternatives for more information. |
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. |
| Installed Database Clients | Description |
|
Connect using |
Select the appropriate database client or click  to browse. |
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.
The SQL optimization workflow ensures that your SQL statements perform optimally in your database environment.
| Procedure | Description |
|---|---|
| Optimize SQL Statements |
The SQL Optimizer uses artificial intelligence to generate alternatives with unique execution plans for problematic SQL statements. SQL Optimizer generates the alternatives by analyzing SQL statement syntax and database structure. See Optimize SQL Statements for more information. |
| Test Run SQL |
The Test Run SQL function tests the performance of each alternative SQL Optimizer generates. This provides execution times for each alternative to determine the best statement for your database environment. See Test Run SQL Alternatives for more information. |
| Compare SQL Alternatives |
The Compare feature displays details for two SQL statements side-by-side. You can compare an alternative to the original SQL statement or compare two alternatives. |
| Generate Reports |
The Report feature creates a SQL resolution report after you complete the optimization process. |
