On which port is DB2/400 listening?
Juan Riera
Maybe this seems too obvious, but we are not experts on AS/400, and our
systems people have just installed TCP/IP access. I want to connect QMF on
W98 with DB2/400 using TCP/IP, but my systems people can not tell me which
port should I use to connect, I mean on which port is DB2/400 listening (I
know RDB name and IP server address). Where can they look for DB2/400 port
configuration?
Thank you very much,
Juan Riera
Johan Hellström
Johan
Leonard Weincier
The following ports are open on the machine :
>> begin <<
Starting nmap V. 2.01
Interesting ports on as400.host (10.0.0.1):
Port State Protocol Service
21 open tcp ftp
23 open tcp telnet
110 open tcp pop-3
137 open tcp netbios-ns
139 open tcp netbios-ssn
397 open tcp unknown
446 open tcp unknown
447 open tcp unknown
448 open tcp unknown
449 open tcp unknown
515 open tcp printer
Nmap run completed -- 1 IP address (1 host up) scanned in 1 second
>> end <<
447 is the ddm port.
448 is ddm-ssl
446 is drda
449 is as-svrmap which looks like an rpc name service.
HTH
Len
Juan Riera <jri...@retemail.es> wrote in message
news:827qvf$2u...@SGI3651ef0.iddeo.es...
> Hello,
> Maybe this seems too obvious, but we are not experts on AS/400, and our
> systems people have just installed TCP/IP access. I want to connect QMF on
> W98 with DB2/400 using TCP/IP, but my systems people can not tell me which
> port should I use to connect, I mean on which port is DB2/400 listening (I
> know RDB name and IP server address). Where can they look for DB2/400 port
> configuration?
>
John
On the command line of the AS/400, type WRKSRVTBLE and you'll see the port
numbers for all the protocols.
Regards
John.
Paul Nicolay
It depends what you exactly mean...
DRDA 446
DDM 447
AS-DATABASE 8471
EDRSQL 4402
For more info see WRKSRVTBL, and check if the services are started with
NETSTAT, option 3.
BTW, what is QMF ?
Regards,
Paul
---------------------
Juan Riera wrote in message <827qvf$2u...@SGI3651ef0.iddeo.es>...
Hello,
Maybe this seems too obvious, but we are not experts on AS/400, and our
systems people have just installed TCP/IP access. I want to connect QMF on
W98 with DB2/400 using TCP/IP, but my systems people can not tell me which
port should I use to connect, I mean on which port is DB2/400 listening (I
know RDB name and IP server address). Where can they look for DB2/400 port
configuration?
Thank you very much,
Juan Riera
The contents of this message express only the sender's opinion.
This message does not necessarily reflect the policy or views of
my employer, Merck & Co., Inc. All responsibility for the statements
made in this Usenet posting resides solely and completely with the
sender.
Kent Milligan
Rocket Software or IBM Software.
--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, AS/400
km...@us.removethis.ibm.com GO HAWKEYES!!
(opinions stated are not necessarily those of my employer)
Juan Riera
Juan
John <jfi...@omnia.nospam.co.za> escribió en el mensaje de noticias
3847a6c6$0$2...@hades.is.co.za...
> Hi Juan
> On the command line of the AS/400, type WRKSRVTBLE and you'll see the port
> numbers for all the protocols.
>
> Regards
> John.
>
>
> Juan Riera <jri...@retemail.es> wrote in message
> news:827qvf$2u...@SGI3651ef0.iddeo.es...
Juan Riera
Yes it does- you can connect using DRDA or CLI. Rocket people prefers to use
TCP/IP, and so I am trying to setup DRDA, what our systems people does not
know how to do.
I have contacted with Rocket Software and we are trying to setup the
connection using DRDA on TCP/IP. But I just don't get it!
Thank you anyway for your mail,
Juan
Kent Milligan <km...@us.ibm.com> escribió en el mensaje de noticias
3847D26E...@us.ibm.com...
Juan Riera
I have several tables on an AS/400.
I am trying to connect with those tables on two ways:
a) from DB2 6.1 PDE Client Configuration Assistant on my PC (W98), using
TCP/IP to circumvent Client Access.
b) from QMF (Query Management Facility from www.rocketsoftware.com )
To make both connections I am asked to give TCP/IP address and DRDA port on
AS/400.
( I don't want to connect using Client Access - BTW, CA is working asd I can
connect with my table using ODBC)
I usually connect with my AS/400 host using the address 192.168.133.9 to
work on Company application, so TCP/IP is working ok. What I don't know is
what port must I use to get access to my table; I suppose the server TCP/IP
address is OK as I am connecting to it; but I don't know if DRDA service is
working, and if not, how to set it up. If it is working, I need to know if
for any reason is not port 446 where I must look for.
My AS/400 system people are new to TCP/IP, and I think it was people from
IBM who had setup TCI/IP on our AS/400. Result, my systems people does not
know if DRDA is working and where to look for it. I have done a long search
on IBM site looking for references on Redbooks and libary, I have found a
reference for DRDA setup on OS/390 and DB2 connectivity on AIX, NT and
OS390, but nothing about AS/400 and DRDA setup.
Please, excuse this long mail, I am trying to explain myself a little bit
better.
Thank you,
Juan Riera
Paul Nicolay <removethis....@merck.com> escribió en el mensaje de
noticias 828i41$5a$1...@merck.com...
> Hi Juan,
>
> It depends what you exactly mean...
>
> DRDA 446
> DDM 447
> AS-DATABASE 8471
> EDRSQL 4402
>
> For more info see WRKSRVTBL, and check if the services are started with
> NETSTAT, option 3.
>
> BTW, what is QMF ?
>
> Regards,
> Paul
> ---------------------
> Juan Riera wrote in message <827qvf$2u...@SGI3651ef0.iddeo.es>...
> Hello,
> Maybe this seems too obvious, but we are not experts on AS/400, and our
> systems people have just installed TCP/IP access. I want to connect QMF on
> W98 with DB2/400 using TCP/IP, but my systems people can not tell me which
> port should I use to connect, I mean on which port is DB2/400 listening (I
> know RDB name and IP server address). Where can they look for DB2/400 port
> configuration?
>
> Thank you very much,
>
> Juan Riera
>
>
>
>
>
>
Kent Milligan
has a section on DRDA over TCP/IP configuration (this requires V4R2 on the
AS/400)
Karl Hanson
See the Distributed Database Programming manual. The V4R4 English
online versions are:
HTML:
http://publib.boulder.ibm.com/pubs/html/as400/v4r4/ic2924/info/db2/rbal1mst02.htm
PDF:
http://publib.boulder.ibm.com/pubs/html/as400/v4r4/ic2924/info/db2/rbal1mst.pdf
This manual has information about setup/config of DRDA on AS/400.
If TCP is otherwise working ok, check these things:
1) The DRDA server must be running. This command will start it:
===> STRTCPSVR SERVER(*DDM)
2) You need a *LOCAL entry in the RDB directory. To check this:
===> WRKRDBDIRE
3) Ensure user ID/password security matches between the DRDA client and
the AS/400 server. For example if the client does not require/send a
password, you could configure the AS/400 like this:
===> CHGDDMTCPA PWDRQD(*NO)
--
Karl Hanson