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

[Larry]

On 9/19/2012 11:34 AM, simo...@gmail.com wrote:
> 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
>
First of all, you need to install and use DB2 Connect. Secondly, there
is a process that must be followed on the i-series side to enable the
DDM. Check here:
https://www-304.ibm.com/support/entdocview.wss?rs=0&q1=db2%20and%20iseries%20and%20os%2f400&q2=DB2%20Connect&uid=nas1668cd00d774c2504862572020052188b&loc=en_US&cs=utf-8&cc=us&lang=en
and here: http://www-01.ibm.com/support/docview.wss?uid=swg21593101 .
You'll need an IBM id to access the first link.

Good luck.

--
Larry E.

--- news://freenews.netfront.net/ - complaints: ne...@netfront.net ---

[simo...@gmail.com]

Thanks Larry. I've got it working after enabling DDM on as/400.
Simon