TCP/IP Address: How to get?

Richard Arnold

TCP/IP Address: How to get?
Hello list:

Would someone please tell me the easiest way to get a subsystem's TCP/IP
address?

Thanks in advance for your help.

Richard Arnold
JPMorganChase

PS: This message is for list serve purposes ONLY, and MUST NOT be quoted
by
any VENDORS, such as BMC and CDB !!!!!



Edward Vassie

Re: TCP/IP Address: How to get?
(in response to Linda Billings)
If TCP/IP is working, look in the JES log of the MSTR address space. During
DB2 startup the TCP/IP addresses are displayed.

From Edward Vassie...


-----Original Message-----
From: Richard Arnold [mailto:[login to unmask email]
Sent: 03 January 2001 16:42
To: [login to unmask email]
Subject: TCP/IP Address: How to get?


Hello list:

Would someone please tell me the easiest way to get a subsystem's TCP/IP
address?

Thanks in advance for your help.

Richard Arnold
JPMorganChase

PS: This message is for list serve purposes ONLY, and MUST NOT be quoted
by
any VENDORS, such as BMC and CDB !!!!!








Linda Billings

Re: TCP/IP Address: How to get?
(in response to Richard Arnold)
Hi, Richard,

You could execute DSNJU003 to get the port number from the BSDS.
See the IBM DB2 Utility Guide and Reference for details, chapter 3.

Linda Billings
Enterprise Systems Programmer
Info-Tech Services
Department of Administration
State of Wisconsin

"The basis of optimism is sheer terror." - Oscar Wilde




-----Original Message-----
From: Richard Arnold [mailto:[login to unmask email]
Sent: Wednesday, January 03, 2001 10:42 AM
To: [login to unmask email]
Subject: TCP/IP Address: How to get?


Hello list:

Would someone please tell me the easiest way to get a subsystem's TCP/IP
address?

Thanks in advance for your help.

Richard Arnold
JPMorganChase

PS: This message is for list serve purposes ONLY, and MUST NOT be quoted
by
any VENDORS, such as BMC and CDB !!!!!








Jeff Faughn

Re: TCP/IP Address: How to get?
(in response to Edward Vassie)
Browse the MASTER Task under SDSF ( ie SSIDMSTR)... : )




Richard Arnold
<Richard.Arnold@ To: [login to unmask email]
CHASE.COM> cc:
Sent by: DB2 Subject: TCP/IP Address: How to get?
Data Base
Discussion List
<[login to unmask email]>


01/03/01 10:41
AM
Please respond
to DB2 Data Base
Discussion List






Hello list:

Would someone please tell me the easiest way to get a subsystem's TCP/IP
address?

Thanks in advance for your help.

Richard Arnold
JPMorganChase

PS: This message is for list serve purposes ONLY, and MUST NOT be quoted
by
any VENDORS, such as BMC and CDB !!!!!








Carlos Olson

Re: TCP/IP Address: How to get?
(in response to Jeff Faughn)
Try the command:

TSO NETSTAT HOME

Carlos Olson
Database Administrator

QRS Corporation
1400 Marina Way South
Richmond, California 94804

510.215.3873 voice
510.621.3873 fax
[login to unmask email]


-----Original Message-----
From: Richard Arnold [mailto:[login to unmask email]
Sent: Wednesday, January 03, 2001 8:42 AM
To: [login to unmask email]
Subject: TCP/IP Address: How to get?


Hello list:

Would someone please tell me the easiest way to get a subsystem's TCP/IP
address?

Thanks in advance for your help.

Richard Arnold
JPMorganChase

PS: This message is for list serve purposes ONLY, and MUST NOT be quoted
by
any VENDORS, such as BMC and CDB !!!!!








Linda Billings

Re: TCP/IP Address: How to get?
(in response to Carlos Olson)
Oooooops! That should have read DSNJU003 not DSNJU004. Sorry. Also, upon
further reflection it will only list the port number that DB2 will use. The
location name that is listed may not be a TCP/IP address. That address is
for the machine or LPAR in general. The port numbers identify the
application, in this case, DB2. I looked in our STC for a MSTR and couldn't
find any address, only the location name that I think is resolved by a
domain name server.

Linda

-----Original Message-----
From: Billings, Linda
Sent: Wednesday, January 03, 2001 10:55 AM
To: 'DB2 Data Base Discussion List'
Subject: RE: TCP/IP Address: How to get?


Hi, Richard,

You could execute DSNJU003 to get the port number from the BSDS.
See the IBM DB2 Utility Guide and Reference for details, chapter 3.

Linda Billings
Enterprise Systems Programmer
Info-Tech Services
Department of Administration
State of Wisconsin

"The basis of optimism is sheer terror." - Oscar Wilde

-----Original Message-----
From: Richard Arnold [mailto:[login to unmask email]
Sent: Wednesday, January 03, 2001 10:42 AM
To: [login to unmask email]
Subject: TCP/IP Address: How to get?


Hello list:

Would someone please tell me the easiest way to get a subsystem's TCP/IP
address?

Thanks in advance for your help.

Richard Arnold
JPMorganChase

PS: This message is for list serve purposes ONLY, and MUST NOT be quoted
by
any VENDORS, such as BMC and CDB !!!!!








Jose' Gomez

Re: TCP/IP Address: How to get?
(in response to Linda Billings)
If you have TSO you can issue a TSO PING command to the DB2 Sub-system.
TSO PING subsystem name. If your network folks have added the DB2 host
name to the Host name definition table you can ping it from a MS-DOS
prompt also. Your DB2 system programmer can get you the IP address and
the port#...

TSO PING DB2A

Ping CS V2R7: Pinging host DB2A (299.87.123.123). Use ATTN to interrupt.

PING: Ping #1 response took 0.000 seconds. Successes so far 1.

Sanjeev (CTS) S

Re: TCP/IP Address: How to get?
(in response to Jose' Gomez)
Hi,
MSTR address space probably gives the information when message given below
is issued.

DSNL511I + DSNLIENO TCP/IP CONVERSATION FAILED
TO LOCATION 11.22.111.555
IPADDR=11.22.111.555 PORT=2222
SOCKET=READ RETURN CODE=1121 REASON CODE=00000000

Is this true ?

Regards,
Sanjeev
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------



teldb2kals

Re: TCP/IP Address: How to get?
(in response to Sanjeev (CTS) S)
Sanjeev,

I think that IP address is the address of a client machine which tried to
communicate with the host.

Cheers,
Kals
-----Original Message-----
From: S, Sanjeev (CTS) [SMTP:[login to unmask email]
Sent: Thursday, January 04, 2001 4:10 PM
To: [login to unmask email]
Subject: Re: TCP/IP Address: How to get?

Hi,
MSTR address space probably gives the information when message given below
is issued.

DSNL511I + DSNLIENO TCP/IP CONVERSATION FAILED
TO LOCATION 11.22.111.555
IPADDR=11.22.111.555 PORT=2222
SOCKET=READ RETURN CODE=1121 REASON CODE=00000000

Is this true ?

Regards,
Sanjeev
------------------------------------------------------------------------------
-----------------------------------------------------------
------------------------------------------------------------------------------
-----------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by reply
e-mail and
destroy all copies of the original message. Any unauthorised review, use,
disclosure,
dissemination, forwarding, printing or copying of this email or any action
taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
------------------------------------------------------------------------------
----------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------------------------------

---------------------------------
Powered by http://www.telstra.com



Sanjeev (CTS) S

Re: TCP/IP Address: How to get?
(in response to teldb2kals)
Kals,
Thanks for your comment. But is this not the address and with its
port(2222) DB2 subsystem is interacting ? I am not sure as i have no
concrete idea for this.

Regards,
Sanjeev

> -----Original Message-----
> From: teldb2kals [SMTP:[login to unmask email]
> Sent: Thursday, January 04, 2001 11:15 AM
> To: [login to unmask email]
> Subject: Re: TCP/IP Address: How to get?
>
> Sanjeev,
>
> I think that IP address is the address of a client machine which tried to
> communicate with the host.
>
> Cheers,
> Kals
> -----Original Message-----
> From: S, Sanjeev (CTS) [SMTP:[login to unmask email]
> Sent: Thursday, January 04, 2001 4:10 PM
> To: [login to unmask email]
> Subject: Re: TCP/IP Address: How to get?
>
> Hi,
> MSTR address space probably gives the information when message given
> below
> is issued.
>
> DSNL511I + DSNLIENO TCP/IP CONVERSATION FAILED
> TO LOCATION 11.22.111.555
> IPADDR=11.22.111.555 PORT=2222
> SOCKET=READ RETURN CODE=1121 REASON CODE=00000000
>
> Is this true ?
>
> Regards,
> Sanjeev
> --------------------------------------------------------------------------
> ----
> -----------------------------------------------------------
> --------------------------------------------------------------------------
> ----
> -----------------------------------------------------------
> This e-mail and any files transmitted with it are for the sole use
> of the intended recipient(s) and may contain confidential and privileged
> information.
> If you are not the intended recipient, please contact the sender by reply
> e-mail and
> destroy all copies of the original message. Any unauthorised review, use,
> disclosure,
> dissemination, forwarding, printing or copying of this email or any action
> taken in
> reliance on this e-mail is strictly prohibited and may be unlawful.
>
> Visit us at http://www.cognizant.com
> --------------------------------------------------------------------------
> ----
> ----------------------------------------------------------
> --------------------------------------------------------------------------
> ----
> ----------------------------------------------------------
>
> ---------------------------------
> Powered by http://www.telstra.com
>
>
>
>
>
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------



Kirk Hampton

Re: TCP/IP Address: How to get?
(in response to Sanjeev (CTS) S)
The IP address and port number listed in the DSNL511I message
is the DB2 Connect client or the gateway with which that DB2 OS/390
subsystem is communicating. The numeric IP address of the DB2 for
OS/390 subsystem itself does not appear in the MSTR log, (at least not
at our shop) but it does display its own port number when DDF starts.

DSNL004I DBP5 DDF START COMPLETE
LOCATION DB2PROD5
LU USTUSI01.DBP5DIST
GENERICLU -NONE
DOMAIN tumvsae0.tu.com
TCPPORT 5571
RESPORT 5572

According to the message manual for DSNL004I, the DOMAIN name shown
should be used by DB2 Connect requesters in their CATALOG TCPIP NODE
configuration command. We use another DNS name here for all DB2 Connect
requesters, but it evidently resolves to the same IP address.






"S, Sanjeev (CTS)" <[login to unmask email]> on 01/03/2001 11:56:11 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Kirk Hampton/Texas Utilities)
Subject: Re: TCP/IP Address: How to get?



Kals,
Thanks for your comment. But is this not the address and with its
port(2222) DB2 subsystem is interacting ? I am not sure as i have no
concrete idea for this.

Regards,
Sanjeev

> -----Original Message-----
> From: teldb2kals [SMTP:[login to unmask email]
> Sent: Thursday, January 04, 2001 11:15 AM
> To: [login to unmask email]
> Subject: Re: TCP/IP Address: How to get?
>
> Sanjeev,
>
> I think that IP address is the address of a client machine which tried to
> communicate with the host.
>
> Cheers,
> Kals
> -----Original Message-----
> From: S, Sanjeev (CTS) [SMTP:[login to unmask email]
> Sent: Thursday, January 04, 2001 4:10 PM
> To: [login to unmask email]
> Subject: Re: TCP/IP Address: How to get?
>
> Hi,
> MSTR address space probably gives the information when message given
> below
> is issued.
>
> DSNL511I + DSNLIENO TCP/IP CONVERSATION FAILED
> TO LOCATION 11.22.111.555
> IPADDR=11.22.111.555 PORT=2222
> SOCKET=READ RETURN CODE=1121 REASON CODE=00000000
>
> Is this true ?
>
> Regards,
> Sanjeev
> --------------------------------------------------------------------------
> ----
> -----------------------------------------------------------
> --------------------------------------------------------------------------
> ----
> -----------------------------------------------------------
> This e-mail and any files transmitted with it are for the sole use
> of the intended recipient(s) and may contain confidential and privileged
> information.
> If you are not the intended recipient, please contact the sender by reply
> e-mail and
> destroy all copies of the original message. Any unauthorised review, use,
> disclosure,
> dissemination, forwarding, printing or copying of this email or any action
> taken in
> reliance on this e-mail is strictly prohibited and may be unlawful.
>
> Visit us at http://www.cognizant.com
> --------------------------------------------------------------------------
> ----
> ----------------------------------------------------------
> --------------------------------------------------------------------------
> ----
> ----------------------------------------------------------
>
> ---------------------------------
> Powered by http://www.telstra.com
>
>
>
>
>
-----------------------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------------------

This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by reply e-mail
and
destroy all copies of the original message. Any unauthorised review, use,
disclosure,
dissemination, forwarding, printing or copying of this email or any action taken
in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------------------------









[login to unmask email]

Re: TCP/IP Address: How to get?
(in response to Kirk Hampton)
--- Erhalten von BG1.KELLERC 6785-2761 04-01-01 17.50

-> [login to unmask email]

Hello,
right, and then as said ping the name under DOMAIN and you get the
IP-address.
Regards, Chris

Date: Thu, 4 Jan 2001 08:35:59 -0600
Subject: Re: TCP/IP Address: How to get?
From: [login to unmask email]
To: [login to unmask email]

The IP address and port number listed in the DSNL511I message
is the DB2 Connect client or the gateway with which that DB2 OS/390
subsystem is communicating. The numeric IP address of the DB2 for
OS/390 subsystem itself does not appear in the MSTR log, (at least
not at our shop) but it does display its own port number when DDF
starts.

DSNL004I DBP5 DDF START COMPLETE
LOCATION DB2PROD5
LU USTUSI01.DBP5DIST
GENERICLU -NONE
DOMAIN tumvsae0.tu.com
TCPPORT 5571
RESPORT 5572