After installing and launching Toad for DB2, the New Connection dialog window appears and the SQL1027N error message appears in the connection details window; no definitions for connections can be made.
Missing Node and Database catalog.
RESOLUTION 1:
Create Catalog Node and database:
Example commands on how to create Catalog Node and Database:
CATALOG TCPIP NODE linunod1
REMOTE hostname
SERVER 50000
REMOTE_INSTANCE linunod1;
CATALOG DATABASE databnam
AS databnam
AT NODE linunod1;
RESOLUTION 2:
If user had a Toad for DB2 beta version installed previously, follow these steps.
0. Close Toad
1. Make a backup of this file
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config
2. Open this file in notepad
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config
3. Look for tag <runtime> delete everything from here to </runtime> (including <runtime> and </runtime>)
4. Save file
5. Start toad
