SQL Optimizer for DB2 LUW 4.4.1 - Installation Guide

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Installation Requirements Install or Upgrade SQL Optimizer Silent Install of SQL Optimizer Uninstall SQL Optimizer Register SQL Optimizer

Configuration

Access SQL Optimizer Configure SQL Optimizer

Troubleshoot SQL Optimizer

"Failed to Connect to IBM DB2 LUW" No Index Recommendations from IBM DB2 LUW "Failed to initialize the application"

Preference Settings for Handling Temporary Tables

Under the Options window, the SQL Scanner and Optimization tabs contain several settings that control the use of temp tables in the SQL Scanner and SQL Optimizer modules.

SQL Scanner Tab - Options Button

Create Scanner Temp Table

Include data

Override previous Scanner Temp Table

Optimization Tab - Optimization Button

Temp table generation

Apply selected SQL Options to temp table SQL

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SQL Optimizer for DB2 LUW 4.4.1 - Installation Guide

Preference Settings for Handling Temporary Tables

SQL Scanner Tab - Options Button

Optimization Tab - Optimization Button