Hello all,

I'm trying to connect a Linux machine (Redhat 8.0) to a IBM iSeries
running os400 V5R1. I installed IBM(R) DB2(R) Universal Database
Personal Edition Version 8.1 on the Linux machine and can successfully
connect to the sample database.

I followed the following steps (assuming 192.168.0.11 is the IP
address of the iSeries and the name of the database on that server I'm
trying to connect to is "DEVTEST") to try to connect from the Linux
machine to the os400 database:

db2 CATALOG TCPIP NODE as400 REMOTE 192.168.0.11 \
SERVER 446 REMOTE_INSTANCE DEVTEST \
OSTYPE os400

db2 CATALOG DCS DATABASE DEVTEST AS DEVTEST

db2 CATALOG DATABASE DEVTEST AS DEVTEST \
AT NODE as400 AUTHENTICATION DCS


If I do a connect from the Linux machine using the incorrect
password, I correctly receive the error:

SQL30082N Attempt to establish connection failed with security reason
"24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001


If I do a connect from the Linux machine using the correct
username/password, I receive the error:

SQL30061N The database alias or database name "DEVTEST "
was not found at the remote node. SQLSTATE=08004

This is the error that has me stumped. I verified the name of the
database on the server, which is DEVTEST. It's quite possible that
I'm missing something elementary, so any suggestions are greatly
appreciated.

Thanks,
Douglas Hunter

Douglas Hunter wrote:

This site may help:
http://www.ibm.com/servers/eserver/i...2/db22drda.htm

Ensure the *LOCAL RDB name using WRKRDBDIRE has the expected value.

Karl Hanson