Connecting to AS/400 on iseries system from DB2 on Windows

[s***@gmail.com]

Hello folks,

I'm a Windows DBA and have been asked to setup DB2 federation to query AS/400 data from DB2 on Windows. I have got federation feature turned on on DB2 Windows server and got the below catalog commands executed successfully:

DB2 CATALOG TCPIP NODE ASNODE REMOTE ASSERV SERVER 8479
DB2 CATALOG DB PROD AS ASDB AT NODE ASNODE AUTHENTICATION DCS
DB2 CATALOG DCS DB ASDB AS PROD

However, when trying to connect to the database or trying to create server definition in DB2 Control Center, the connection hungs forever. In the mean time, if I do NETSTAT -a, I could see the connection is established to as400 system with the correct port number.

I wonder if something needs to be enabled in AS/400 system for this to work, as I have no problem to use Client Access ODBC connection from MS Access.

Any help would be appreciated.

Thanks
Simon

[Marc Rauzier]

Post by s***@gmail.com
Hello folks,

Hello

Post by s***@gmail.com
I'm a Windows DBA and have been asked to setup DB2 federation to
query AS/400 data from DB2 on Windows. I have got federation
feature turned on on DB2 Windows server and got the below catalog
DB2 CATALOG TCPIP NODE ASNODE REMOTE ASSERV SERVER 8479

You may want to try to use drda service on port 443. As far as I know
for connecting from a DB2 machine, drda should be used.
Make also sure that drda service is started on AS400 side (STRTCPSVR
*DDM) if you try to connect to port 443.

Post by s***@gmail.com
DB2 CATALOG DB PROD AS ASDB AT NODE ASNODE AUTHENTICATION DCS
DB2 CATALOG DCS DB ASDB AS PROD
However, when trying to connect to the database or trying to
create server definition in DB2 Control Center, the connection
hungs forever. In the mean time, if I do NETSTAT -a, I could see
the connection is established to as400 system with the correct
port number.
I wonder if something needs to be enabled in AS/400 system for
this to work, as I have no problem to use Client Access ODBC
connection from MS Access.

Client Access ODBC uses as-file service (on port 8479) as you noted.

Post by s***@gmail.com
Any help would be appreciated.
Thanks
Simon

[s***@gmail.com]

Thank you Marc. I'll give that a try. Btw, do you know if DB2 Connect is also required on both systems, or federation feature and drda should be enough to make connections?
Thanks

[s***@gmail.com]

Hi there Marc again:

Thank you very much for the advice. I now got federation going on to as400 system and Nicknames are working great without the need to install DB2 Connect. Basically the DRDA service just needed to be turned on in as400 system and then I used the correct port number of the DRDA service in the catalog command, in my case it is 446

Have a great day!
Simon

[Marc Rauzier]

Post by s***@gmail.com
Thank you very much for the advice. I now got federation going on
to as400 system and Nicknames are working great without the need
to install DB2 Connect. Basically the DRDA service just needed to
be turned on in as400 system and then I used the correct port
number of the DRDA service in the catalog command, in my case it
is 446

For sure, it is 446. I made a mistake with my 443 :-) I don't know what
happened with my fingers !

Happy to see it works fine for you.

Post by s***@gmail.com
Have a great day!
Simon