RE: Accessing 400 RDB using DB2 UDB 6.1

You need DB2 UDB Personal (or greater) Connect is minimum, and you might need Communications Server for the DDCS and communications transports. In your setup you need to supply the CPI-C side information containing the network ID and the LU name of the Local machine and in the communications Info you supply the network and the name of the remote LU. Assuming you are using TCP you would also supply the TCP address of your machine and that of the Target. In theory once all of the communications protocols and transports are established, UDB is supposed to be able to find any remote DB2s and set up the necessary hooks to talk to them! (I have not gotton this to work, we are a govt. site and nothing is ever allowed to work as designed!) But I have gotten 5.2 Connect to interact with V4R1 and V3R2. One other possible difference is at that time I was using Token Ring instead of Ethernet.

-----Original Message-----
From: David Gibbs [mailto:dgibbs@mks.com]
Sent: Friday, June 15, 2001 14:48
To: 'Midrange Mailing List'
Subject: Accessing 400 RDB using DB2 UDB 6.1

Folks:

Is anyone using DB2 UDB 6.1 (running on a PC) to connect to a 400's
database?

I'm trying to make this work, but haven't been able to get any
communications established.

In the control center, I've added a system for my AS400, identified the OS
as OS/400, but when I try to attach I get a "The DB2 Administration Server
is not active.  SQLSTATE=57019" message.

Does something have to be started on the 400 in order for this to work?  I
did add an RDB Directory entry for the local system.

When I try to add a database to the client configuration, I get a 'SQL10007N
Message "-1092" could not be retrieved.  Reason code: "4".' message.  I
select TCP/IP as the protocol, OS400 as the OS, port 446, database = the
database name I put in the RDB Directory, and options in the "Host or AS/400
Options" panel.

Any suggestions?

Thanks!

david

--
David Gibbs
Sr. Software Engineer
Mortice Kern Systems US, Inc.
2500 S. Highland Ave., Suite 200
Lombard, IL  60148

phone: (630) 495-2108 x5004
http://www.mks.com
mailto:dgibbs@mks.com

Need a laugh: http://www.userfriendly.org/static

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---