DB2 Connect EE as Gateway Configuration

Gary R Maculsay

DB2 Connect EE as Gateway Configuration
I'm running into a problem that I'm sure is silly, but I can't seem to find
any specific documentation to help me.

Important Facts:

Very little DB2/Unix knowledge is available.

We have installed DB2 Connect EE on a Solaris. After cataloging the
necessary host information, I can connect to DB2/OS390 from the unix command
line.

I have also successfully configured an NT box with DB2 Personal Connect
(trial) to OS/390 using a direct connection.

I'm now trying to configure an NT desktop to reach DB2/OS390 through the DB2
Connect EE on the unix box. Using the client configuration tool, I choose
"Connect to the server via the Gateway. I now need to supply appropriate
host name, port number, and optional service name. I don't know what is
expected for these values in this situation, but I have a few hints. I
don't see any entries in /etc/services for ports associated with DB2, and a
dump of DBM CFG does not show a service name. Not being Unix-savvy (and
obviously very un-connect savvy, what can I do to help resolve the
situation?

Any advice will help - I am looking through the online manuals again.



Shauna Hadden

Re: DB2 Connect EE as Gateway Configuration
(in response to Gary R Maculsay)
Have you tried the "Search the Network" selection on the Add function under
Client Configuration Assistant?

We are using an AIX box. In our case, our host name was the name of the
server. Can you connect to the OS/390 directly from the server? Is this
working? Have you set up connection between the server and the mainframe?

When you did the setup, a service name was assigned to the port number that
DB2 is using. This can be found on the server by issuing a Connect to ....
whatever you called the mainframe connection) from a DB2 Line Editor Window.
Then issue a GET DBM CFG. Look under "TCP/IP Service name" (SVCENAME). That
is the name of your service and should be assigned to your port.


On Wed, 20 Dec 2000 20:47:04 -0000, Maculsay, Gary R
<[login to unmask email]> wrote:

>I'm running into a problem that I'm sure is silly, but I can't seem to find
>any specific documentation to help me.
>
>Important Facts:
>
> Very little DB2/Unix knowledge is available.
>
>We have installed DB2 Connect EE on a Solaris. After cataloging the
>necessary host information, I can connect to DB2/OS390 from the unix
command
>line.
>
>I have also successfully configured an NT box with DB2 Personal Connect
>(trial) to OS/390 using a direct connection.
>
>I'm now trying to configure an NT desktop to reach DB2/OS390 through the
DB2
>Connect EE on the unix box. Using the client configuration tool, I choose
>"Connect to the server via the Gateway. I now need to supply appropriate
>host name, port number, and optional service name. I don't know what is
>expected for these values in this situation, but I have a few hints. I
>don't see any entries in /etc/services for ports associated with DB2, and a
>dump of DBM CFG does not show a service name. Not being Unix-savvy (and
>obviously very un-connect savvy, what can I do to help resolve the
>situation?
>
>Any advice will help - I am looking through the online manuals again.
>
>
>



Have you tried the "Search the Network" selection on the Add function under
Client Configuration Assistant?

We are using an AIX box. In our case, we did not use a service name since it
was optional. Sounds like you may not have one either.

The port number we used was 50000. I believe it should have been part of the
install or could be found in the install documentation somewhere. We put it
in ETC/Services as part of the documentation so that we did not try to reuse
it.



Gary R Maculsay

Re: DB2 Connect EE as Gateway Configuration
(in response to Shauna Hadden)
The connection between the unix server and the mainframe works.

The svcename is blank. The admins did an install, but did not fully utilize
all the niceties of the install program, so we ended up creating the
instance later.

I'm just guessing (I have to find a moment to rtfm) but I think we need to
set up /etc/services to reserve port(s) and update svcename on the dbm cfg.


Thanks to all who have responded publicly and privately - I appreciate the
help!



-----Original Message-----
From: Shauna Hadden [mailto:[login to unmask email]
Sent: Thursday, December 21, 2000 11:21 AM
To: [login to unmask email]
Subject: Re: DB2 Connect EE as Gateway Configuration


Have you tried the "Search the Network" selection on the Add function under
Client Configuration Assistant?

We are using an AIX box. In our case, our host name was the name of the
server. Can you connect to the OS/390 directly from the server? Is this
working? Have you set up connection between the server and the mainframe?

When you did the setup, a service name was assigned to the port number that
DB2 is using. This can be found on the server by issuing a Connect to ....
whatever you called the mainframe connection) from a DB2 Line Editor Window.
Then issue a GET DBM CFG. Look under "TCP/IP Service name" (SVCENAME). That
is the name of your service and should be assigned to your port.


On Wed, 20 Dec 2000 20:47:04 -0000, Maculsay, Gary R
<[login to unmask email]> wrote:

>I'm running into a problem that I'm sure is silly, but I can't seem to find
>any specific documentation to help me.
>
>Important Facts:
>
> Very little DB2/Unix knowledge is available.
>
>We have installed DB2 Connect EE on a Solaris. After cataloging the
>necessary host information, I can connect to DB2/OS390 from the unix
command
>line.
>
>I have also successfully configured an NT box with DB2 Personal Connect
>(trial) to OS/390 using a direct connection.
>
>I'm now trying to configure an NT desktop to reach DB2/OS390 through the
DB2
>Connect EE on the unix box. Using the client configuration tool, I choose
>"Connect to the server via the Gateway. I now need to supply appropriate
>host name, port number, and optional service name. I don't know what is
>expected for these values in this situation, but I have a few hints. I
>don't see any entries in /etc/services for ports associated with DB2, and a
>dump of DBM CFG does not show a service name. Not being Unix-savvy (and
>obviously very un-connect savvy, what can I do to help resolve the
>situation?
>
>Any advice will help - I am looking through the online manuals again.
>
>
>



Have you tried the "Search the Network" selection on the Add function under
Client Configuration Assistant?

We are using an AIX box. In our case, we did not use a service name since it
was optional. Sounds like you may not have one either.

The port number we used was 50000. I believe it should have been part of the
install or could be found in the install documentation somewhere. We put it
in ETC/Services as part of the documentation so that we did not try to reuse
it.