Hi all:
I'm new to DB2 and I need some help.
I'm using DB2 UDB v. 7.1 Enterprise Edition on Mandrake Linux 8, kernel 2.4.10-pre8. I'm trying to connect to OS/390 MVS running DB2 6.1. I FINALLY figured out a good portion of how to get connected to my mainframe DB2 from my Linux Server. But now I have some 'remote request' issue that is just too odd. I -think- I've connected to the database on the mainframe correctly by the following:
[excerpt]
db2=> CATALOG TCPIP NODE gateway REMOTE gateway SERVER db2c<instance>
db2=> CATALOG DCS DATABASE DB2DATA AS DB2DATA
db2=> CATALOG DATABASE DB2DATA as DB2DATA at NODE gateway AUTHENTICATION client
db2=> UPDATE dbm cfg using AUTHENTICATION client
db2=> terminate
joeuser@linuxserver:> db2stop
joeuser@linuxserver:> db2start ; db2
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 = db2c<instance>
db2=> list database directory
System Database Directory
Number of entries in the directory = 1
Database 1 entry:
Database alias = DB2DATA
Database name = DB2DATA
Node name = GATEWAY
Database release level = 9.00
Comment =
Directory entry type = Remote
Authentication = CLIENT
Catalog node number = -1
db2 => connect to db2data user <user_name> using <password>
SQL1334N The database server cannot be used to route a remote request to a second database server in this configuration.
[/excerpt]
* What exactly is the last line talking about?
* If this NOT the correct configuration, what other configurations are there?
*How can I find this out?
*Any examples on the web (I couldn't find anything different than what the docs at IBM and my
DB2 UDB v 7.1 book by Baklarz and Wong)?
Any suggestions or comments would be appreciated.
Thanks!
