When you start SQL Optimizer, a User Logon dialog box is displayed to allow connection to the DB2 database.
To logon to DB2 LUW
In the Login Name box, enter the user name required to connect to the database.
In the Password box, enter the password associated with the user name.
In the Database Alias box, enter the name of the database to which you want to connect. Database aliases can be defined in DB2 Client Configuration Assistant.
Click Connect to connect to the database server. After the database is successfully connected, information from the data dictionary is loaded into memory.
In DB2 LUW version 7 or earlier, if the current logon user does not satisfy all of the logon privileges, an icon will appear on the bottom status bar and the Connection Information dialog box will be displayed. Full details of what database privileges are required and their workaround are displayed on the Connection Information dialog box.
To view the Connection Information dialog box
Select Database | View Connection Information.
When SQL Optimizer connects to the database, it determines whether the access plan tables exist. DB2 requires access plan tables to provide access plan detail. If these tables do not exist in the current schema, SQL Optimizer attempts to create the following tables according to the table definitions in the SQL script, C:\Program Files\SQLLIB\misc\EXPLAIN.DDL, provided by DB2 LUW.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center