--Hi all:
--I must be doing something awfully wrong. I'm looking at your instructions,
Philip, but I seem to be getting the same error.
--Side note: You are correct about my wanting the Linux box to act as a
gateway between Client PC's and Mainframe.
--This is what I've done:
[excerpt]
db2 => catalog tcpip node gateway remote {I tried both *gateway and *linuxserver
names} server 50000
**(note: gateway = OS390; linuxserver = linuxserver/UDB7.1 Enterprise)**
db2 => catalog database DB2DATA at node gateway authentication dcs
db2 => catalog dcs database DB2DATA as DB2DATA
[...]
db2 => list database directory
Database 1 entry:
Database alias = DB2DATA <-- database on OS390
Database name = DB2DATA
Node name = GATEWAY <-- name of OS390 mainframe
Database release level = 9.00
Comment =
Directory entry type = Remote
Authentication = DCS
Catalog node number = -1
db2 => list node directory
Node Directory
Number of entries in the directory = 1
Node 1 entry:
Node name = GATEWAY <-- name of OS390
Comment =
Protocol = TCPIP
Hostname = LINUXSERVER <--linux box (also tried GATEWAY)
Service name = 50000 <-- port for OS390 (also same for LINUXSERVER)
db2 => list dcs directory
Database Connection Services (DCS) Directory
DCS 1 entry:
Local database name = DB2DATA
Target database name = DB2DATA
Application requestor name =
DCS parameters =
Comment =
DCS directory release level = 0x0100
db2 => connect to db2data user joeuser using mypassword
SQL1334N The database server cannot be used to route a remote request to a
second database server in this configuration.
[/excerpt]
--Philip, your instructions looks to be very straight forward. I must be
doing something wrong, or, have missed some something in the process.
--I'm also looking at the configuration on the Windows box (NT: DB2 Connect)
and listing the node/database/directory at the same time I work in Linux.
The node name/protocol/hostname/service name matches and I can work from
NT (yeah, I know ...).
--Is it because the port number that I'm trying to connect to on the mainframe
is the same as the Linux box? Somehow, I seem to be pointing back at myself
(or the mainframe) and missing the connection.
--I'm going to uncatalog everything again and try to look at it from another
angle.
--I'm still trying to figure out a solution, but ... thanks for everything!
Your documentation is still very useful!
-shaunn
[snip]
