Unanswered: Connect to remote database returns SQL30061N
Setup is as follows :
Client Win/XP with CONPE v.9.5.100
Database server W2K3 MSCS with WSE v.9.1.200.
My problem is that i have created a database in an instance named DA2300 and when i try to make a connection, I get the following error message :
SQL30061N The database alias or database name HJDBW999 was not found at the remote node.
At the client i have made the following :
Catalog tcpip node HJDBW999 remote <name> server 50000 remote_instance DA2300 ostype WIN (have tried with and without param remote_instance)
Catalog db HJDBW999 at node HJDBW999 authentication SERVER
Catalog system odbc data source HJDBW999
At the server i have made the following :
Update dbm cfg using SVCENAME db2c_DB2
Db2set -g DB2INSTDEF=DA2300
If i create a database in the default instance (DB2) on the server, i can make a connection to that database.
in server : list db directory to see the name
db2c_DB2 should be in etc/services being 50000
db2set -all should also display db2comm=tcpip
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be