I'm trying to create a federation.. And I'm so new to DB2 it's not funny...
I've been looking on the web and I see about 10 different sets of instructions but being there are so many flavours of DB2 some just don't make sense..
Federations are enabled on windows.. (do I need to do it something on the iSeries?)
on the Windows side
I do a catalog TCPIP to create the Server
I catalog the DB as being in that Server
I stop and start the server to ensure the catalog is up to date..
and when I try to connect
I give a password and I get a connection refused...
DB2 CATALOG TCPIP NODE FNODE REMOTE 10.27.94.xxx SERVER 446
DB2 CATALOG DB HOSTDB AS FDB AT NODE FNODE AUTHENTICATION SERVER
DB2STOP
DB2START
CONNECT TO FDB USER BSTEPHENS
Enter current password for BSTEPHENS:
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "10.27.94.1 14". Communication function
detecting the error: "connect". Protocol specific error code(s): "10061", "*",
"*". SQLSTATE=08001
Is the port supposed to be DRDA (446?)
Do I need a wrapper? where does it come into play?
I've been looking on the web and I see about 10 different sets of instructions but being there are so many flavours of DB2 some just don't make sense..
Federations are enabled on windows.. (do I need to do it something on the iSeries?)
on the Windows side
I do a catalog TCPIP to create the Server
I catalog the DB as being in that Server
I stop and start the server to ensure the catalog is up to date..
and when I try to connect
I give a password and I get a connection refused...
DB2 CATALOG TCPIP NODE FNODE REMOTE 10.27.94.xxx SERVER 446
DB2 CATALOG DB HOSTDB AS FDB AT NODE FNODE AUTHENTICATION SERVER
DB2STOP
DB2START
CONNECT TO FDB USER BSTEPHENS
Enter current password for BSTEPHENS:
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "10.27.94.1 14". Communication function
detecting the error: "connect". Protocol specific error code(s): "10061", "*",
"*". SQLSTATE=08001
Is the port supposed to be DRDA (446?)
Do I need a wrapper? where does it come into play?