Re: SQL*Net -> DB2

peters_at_bml4380.cpg.cdc.com (Rob Peters) writes:

>Has anyone tried or worked with SQL*Net and SQL*Connect in trying
>to access a DB2 system? I have a SUN system and am trying to make
>the connection work. It's clear TCP/IP all the way, but DB2 runs
>under CICS. Any one out there have this sort of success???
 

>Rob
>rpeters_at_cdc.com

Actually DB2 does not run under CICS or any other TP monitor. DB2 runs as its own subsystem within MVS and allows access to itself from a number of sources including CICS, TSO, and BATCH address spaces. SQL*Connect to DB2 runs as its own subsystem occupying its own address space. As long as you have SQL*Net for TCP/IP (version 1.x) running on both "ends" of the connection then you shouldn't have a problem connecting from the Sun to DB2. The easiest tool to try is SQL*Plus and trying to connect directly as in the following example:

SQLPLUS SCOTT/TIGER_at_T:MVS:SQLC

just substitute the name of your MVS system where I've typed MVS and the name of your SQL*Connect to DB2 subsystem where I've typed SQLC.

If you have problems, first try to ping the MVS host. Some flavors of TCP/IP for MVS will ignore a ping request from an unknown host and you want to make sure that your Sun can talk to the MVS host via TCP/IP. If you can ping the MVS host then there are any number of items which need to be checked. More than I can handle in an e-mail. You should check your Oracle administrators as well as with Oracle Support.

Dave (ddargo_at_oracle.com) Received on Tue Dec 21 1993 - 05:56:00 CET