Hi all:
We have a command-line connection set up for us on NT machines that
connect to a mainframe database "through a gateway". What we would
like to do is replicate this same connection so we can query the same
tables from a Linux-based machine. We have installed DB2-EE 7.1 on a
Mandrake 8.1 system to support this. Unfortunately, the
administrators for the mainframe database are unavailable, so we have
to gather all relevant connection information from the NT client. See
below for what we have so far. Everything seems to go great right up
to the point of making a connection, then it says it can't cannot be
used to route a remote request to a second database server. What
gives? It can't be this hard, can it?
Thanks for any info.
-X / p. w.
################### ON NT ##########################
C:\>db2
(c) Copyright IBM Corporation 1993, 1997
Command Line Processor for DB2 SDK 5.2.0
db2 => list node directory
Node Directory
Number of entries in the directory = 1
Node 1 entry:
Node name = GATEWAY
Comment =
Protocol = TCPIP
Hostname = GATEWAY
Service name = 50000
db2 => list database directory
System Database Directory
Number of entries in the directory = 1
Database 1 entry:
Database alias = DB2DSNB
Database name = DB2DSNB
Node name = GATEWAY
Database release level = 8.00
Comment =
Directory entry type = Remote
Authentication = SERVER
Catalog node number = -1
db2 => connect to db2dsne user fred using tu786ky
Database Connection Information
Database server = DB2 OS/390 6.1.1
SQL authorization ID = FRED
Local database alias = DB2DSNE
db2 => select * from sales.region;
..... (table rows not shown) .....
########################### ON Linux #############################
db2 => list database directory
System Database Directory
Number of entries in the directory = 1
Database 1 entry:
Database alias = DB2DSNE
Database name = DB2DSNE
Node name = GATEWAY
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
Comment =
Protocol = TCPIP
Hostname = gateway
Service name = 50000
db2 => list dcs directory
Database Connection Services (DCS) Directory
Number of entries in the directory = 1
DCS 1 entry:
Local database name = DB2DSNE
Target database name = DB2DSNE
Application requestor name =
DCS parameters =
Comment =
DCS directory release level = 0x0100
db2 => connect to db2dsne user FRED using tu786ky
SQL1334N The database server cannot be used to route a remote request
to a second database server in this configuration.
