Re: Accessing DB2 on other platforms with DDM files -- MIDRANGE-L

Subject: Re: Accessing DB2 on other platforms with DDM files
From: Patrik Schindler <poc@xxxxxxxxxx>
Date: Mon, 9 Sep 2024 19:26:48 +0200
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

Hello Jim,

Am 09.09.2024 um 17:36 schrieb Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>:

DDM does exist on the mainframe using DB/2 (but not VSAM or other storage techniques), but I don't think (at least last time I checked) it supports TCP. It's all APPN/APPC, meaning SNA.

I already established a working SNA adjacency, and I can CONNECT with interactive SQL to the DB2 instance.

https://try-as400.pocnet.net/wiki/Access_OS/390_DB2_database_tables_from_OS/400_over_SNA/APPN

Startup messages emit a TCP port.

I think the network control program on the mainframe needs to add the LU2 devices needed to communicate.

Fortunately, there are default. Have not yet found out where these are set.

Tedious work as I remember it, having done that a time or two in the far past......

I guess so.

:wq! PoC

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Accessing DB2 on other platforms with DDM files , Jim Oberholtzer

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.