Prior to installing SQL Optimizer, a client/server system needs to be set up. Set up the host strings in DB2 Client Configuration Assistant to connect to the databases.
SQL Optimizer directly uses the DB2 Client Configuration Assistant to connect to the DB2 LUW database.
Information about the tables and indexes from the data dictionary needs to be loaded into the memory of the computer for every connection to a database. The Load data dictionary after database connection option determines whether information is loaded when the connection is made or whether the specific information needed from the database is loaded when a SQL statement is parsed for functions such as scanning, optimization, and index generation.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
