Using Toad 3.0.0 and 3.0.1 Profession Edition, the following error occurs when performing a cross-connection query using DB2 ZOS connections and any other connection such Access or Excel:
“Quest.Toad.Exceptions.ProcessedExecutionException: Got error 4206 'Invalid data source definition: SQL30061N The database alias or database name "DCSDBCE9 " was not found at the remote node. SQLSTATE=08004
' from HUB”
WORKAROUND:
Create an ODBC connection to DB2 server.
STATUS:
Issue fixed in version 3.1. The latest version can be downloaded from the Support Portal
