I just installed Toad for DB2 LUW on a trial. I have no connections. I want to connect to use a couple of test databases on the same machine as Toad.
When looking at IBM Data Studio, it easily found my local DB directory and the databases easily connected to Data Studio.
With Toad, it seems to have no knowledge of my machine.
My local information is as follows:
C:\Program Files (x86)\IBM\SQLLIB\BIN>db2 connect to dw
Database Connection Information
Database server = DB2/NT 10.1.1
SQL authorization ID = DB2ADMIN
Local database alias = DW
C:\Program Files (x86)\IBM\SQLLIB\BIN>db2 “SELECT INST_NAME FROM TABLE(SYSPROC.ENV_GET_INST_INFO()) AS SYSTEMINFO”
1 record(s) selected.
In reading the documentation, and running the wizard, I find that Toad wants to the following:
CATALOG TCPIP NODE MART
CATALOG DATABASE DW
AT NODE MART
Is this truly necessary? What did I do wrong?