User attempts to run SQL Analysis but gets the error "SQC03040E - ScAdmin - Unable to locate a DB2 instance entry matching port number (52118) in the instance configuration file (quest.conf)." Upon opening the file quest.conf the connection information for the target database is not listed. It seems SQL Analysis not importing all DB2 connections. Also it seems that SQL Analysis is importing old or invalid connections. The connection is valid and works when manually added to quest.conf file.
If multiple DB2 Copy or DB2 Clients are installed, SQL Analysis could be importing from the wrong directory.
WORKAROUND:
Open the quest.conf file in a text editor and add the database information manually.
STATUS:
Waiting for fix in a future release of Toad for DB2.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center