473,569 Members | 2,572 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

is it possible to connect to db2/390 without having db2 connect?

aka
Hi

I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to
OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect
instance as tcpip node and then the Host DB cataloged on that node...this
works from v7.2 Fixpack 11 clients and servers, but with v8.1 server I get
SQL1334N.
Does anyone has an idea?

Thanks
aka
Nov 12 '05 #1
30 7390
SNA / APPC support is extremely limited inb Version 8.

Recommendations :

1. drop SNA and try TCP/IP only
or
2. upgrade to the latest fixpak of DB2 v8, and try CPIC support (v8
equivalent of APPC / SNA)

aka wrote:
Hi

I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to
OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect
instance as tcpip node and then the Host DB cataloged on that node...this
works from v7.2 Fixpack 11 clients and servers, but with v8.1 server I get
SQL1334N.
Does anyone has an idea?

Thanks
aka


Nov 12 '05 #2
SNA / APPC support is extremely limited inb Version 8.

Recommendations :

1. drop SNA and try TCP/IP only
or
2. upgrade to the latest fixpak of DB2 v8, and try CPIC support (v8
equivalent of APPC / SNA)

aka wrote:
Hi

I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to
OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect
instance as tcpip node and then the Host DB cataloged on that node...this
works from v7.2 Fixpack 11 clients and servers, but with v8.1 server I get
SQL1334N.
Does anyone has an idea?

Thanks
aka


Nov 12 '05 #3
Hi,

I am trying to setup DB2 in a multi-partition setup. But due to some
local configuration problems, We are not in a position to use an NFS.

Is there some way to install the multi-partition setup without having to
use the NFS?

--Sundeep Narravula.

Nov 12 '05 #4
Hi,

I am trying to setup DB2 in a multi-partition setup. But due to some
local configuration problems, We are not in a position to use an NFS.

Is there some way to install the multi-partition setup without having to
use the NFS?

--Sundeep Narravula.

Nov 12 '05 #5
aka
Hi Blair,

thanks for your answer...I'm DBA in a big health isurance company and it
takes me about a week or so to get a new fixpack or db2 instance
installed...
we have DB2/390 v6.1.2 on MVS Host
DB2/SUN v7.2.9 on SunFire Cluster, there is also DB2 Connect EE and SNA is
installed
and we use Solaris and AIX as DB2 Servers from v6.1 to v7.2.9 and also EEE
v7.2.9 on 8 AIX SP2 nodes for data warehouse...
now I have my first v8.1 FP 5 instance on AIX maschine and try to get a
connection to the Host System...

you say SNA/APPC support is limited, so i will first try to get the setup
for v8.1 FP5 on the connect instance
it will then be a second task to follow your tip to exchange APPC with
CPIC...I will let you know

in the above configuration we make connections to MVS host via Solaris
gateway (with DB2 connect EE) and I don't know how long it takes to upgrade
the host system with tcp/ip

in the meantime I read the manuals and wonder about the SQL1334N message I
get, when I try to connect in the same environment to host from v8.1

I thougt I need a DB2 Connect as gateway to access Host DB2 but from the SQL
message it is said that DRDA databases can only connect directly, so another
question is: can I connect to Host system without using the connect gateway?
Thanks
aka
SNA / APPC support is extremely limited inb Version 8.

Recommendations :

1. drop SNA and try TCP/IP only
or
2. upgrade to the latest fixpak of DB2 v8, and try CPIC support (v8
equivalent of APPC / SNA)

Nov 12 '05 #6
aka
Hi Blair,

thanks for your answer...I'm DBA in a big health isurance company and it
takes me about a week or so to get a new fixpack or db2 instance
installed...
we have DB2/390 v6.1.2 on MVS Host
DB2/SUN v7.2.9 on SunFire Cluster, there is also DB2 Connect EE and SNA is
installed
and we use Solaris and AIX as DB2 Servers from v6.1 to v7.2.9 and also EEE
v7.2.9 on 8 AIX SP2 nodes for data warehouse...
now I have my first v8.1 FP 5 instance on AIX maschine and try to get a
connection to the Host System...

you say SNA/APPC support is limited, so i will first try to get the setup
for v8.1 FP5 on the connect instance
it will then be a second task to follow your tip to exchange APPC with
CPIC...I will let you know

in the above configuration we make connections to MVS host via Solaris
gateway (with DB2 connect EE) and I don't know how long it takes to upgrade
the host system with tcp/ip

in the meantime I read the manuals and wonder about the SQL1334N message I
get, when I try to connect in the same environment to host from v8.1

I thougt I need a DB2 Connect as gateway to access Host DB2 but from the SQL
message it is said that DRDA databases can only connect directly, so another
question is: can I connect to Host system without using the connect gateway?
Thanks
aka
SNA / APPC support is extremely limited inb Version 8.

Recommendations :

1. drop SNA and try TCP/IP only
or
2. upgrade to the latest fixpak of DB2 v8, and try CPIC support (v8
equivalent of APPC / SNA)

Nov 12 '05 #7
I think the explanation for error msg SQL1334N isn't exactly clear, but
take my word for it, if you want to connect to a DB2 V6 database on
OS/390 ... you need either a DRDA gateway (DB2 COnnect EE), a DRDA
client (DB2 Connect Personal Edition), or the new type 4 JDBC driver in
DB2 Connect V8 (which will allow direct connections from a type 4 JDBC
client, but still requires a DB2 Connect license) ... and I'm not
entirely sure whether the type 4 JDBC driver in V8 will support either
DB2/390 V6 or SNA.

The description of your environment is not exactly clear to me. Where do
you receive this error msg? On the client? Gateway Server? What exactly
is the client configuration, and the gateway server configuration?

My advice is get off SNA asap.

Larry Edelstein

aka wrote:
Hi Blair,

thanks for your answer...I'm DBA in a big health isurance company and it
takes me about a week or so to get a new fixpack or db2 instance
installed...
we have DB2/390 v6.1.2 on MVS Host
DB2/SUN v7.2.9 on SunFire Cluster, there is also DB2 Connect EE and SNA is
installed
and we use Solaris and AIX as DB2 Servers from v6.1 to v7.2.9 and also EEE
v7.2.9 on 8 AIX SP2 nodes for data warehouse...
now I have my first v8.1 FP 5 instance on AIX maschine and try to get a
connection to the Host System...

you say SNA/APPC support is limited, so i will first try to get the setup
for v8.1 FP5 on the connect instance
it will then be a second task to follow your tip to exchange APPC with
CPIC...I will let you know

in the above configuration we make connections to MVS host via Solaris
gateway (with DB2 connect EE) and I don't know how long it takes to upgrade
the host system with tcp/ip

in the meantime I read the manuals and wonder about the SQL1334N message I
get, when I try to connect in the same environment to host from v8.1

I thougt I need a DB2 Connect as gateway to access Host DB2 but from the SQL
message it is said that DRDA databases can only connect directly, so another
question is: can I connect to Host system without using the connect gateway?
Thanks
aka

SNA / APPC support is extremely limited inb Version 8.

Recommendatio ns:

1. drop SNA and try TCP/IP only
or
2. upgrade to the latest fixpak of DB2 v8, and try CPIC support (v8
equivalent of APPC / SNA)



Nov 12 '05 #8
I think the explanation for error msg SQL1334N isn't exactly clear, but
take my word for it, if you want to connect to a DB2 V6 database on
OS/390 ... you need either a DRDA gateway (DB2 COnnect EE), a DRDA
client (DB2 Connect Personal Edition), or the new type 4 JDBC driver in
DB2 Connect V8 (which will allow direct connections from a type 4 JDBC
client, but still requires a DB2 Connect license) ... and I'm not
entirely sure whether the type 4 JDBC driver in V8 will support either
DB2/390 V6 or SNA.

The description of your environment is not exactly clear to me. Where do
you receive this error msg? On the client? Gateway Server? What exactly
is the client configuration, and the gateway server configuration?

My advice is get off SNA asap.

Larry Edelstein

aka wrote:
Hi Blair,

thanks for your answer...I'm DBA in a big health isurance company and it
takes me about a week or so to get a new fixpack or db2 instance
installed...
we have DB2/390 v6.1.2 on MVS Host
DB2/SUN v7.2.9 on SunFire Cluster, there is also DB2 Connect EE and SNA is
installed
and we use Solaris and AIX as DB2 Servers from v6.1 to v7.2.9 and also EEE
v7.2.9 on 8 AIX SP2 nodes for data warehouse...
now I have my first v8.1 FP 5 instance on AIX maschine and try to get a
connection to the Host System...

you say SNA/APPC support is limited, so i will first try to get the setup
for v8.1 FP5 on the connect instance
it will then be a second task to follow your tip to exchange APPC with
CPIC...I will let you know

in the above configuration we make connections to MVS host via Solaris
gateway (with DB2 connect EE) and I don't know how long it takes to upgrade
the host system with tcp/ip

in the meantime I read the manuals and wonder about the SQL1334N message I
get, when I try to connect in the same environment to host from v8.1

I thougt I need a DB2 Connect as gateway to access Host DB2 but from the SQL
message it is said that DRDA databases can only connect directly, so another
question is: can I connect to Host system without using the connect gateway?
Thanks
aka

SNA / APPC support is extremely limited inb Version 8.

Recommendatio ns:

1. drop SNA and try TCP/IP only
or
2. upgrade to the latest fixpak of DB2 v8, and try CPIC support (v8
equivalent of APPC / SNA)



Nov 12 '05 #9
aka
Larry thank you for answering
I think the explanation for error msg SQL1334N isn't exactly clear, but
take my word for it, if you want to connect to a DB2 V6 database on
OS/390 ... you need either a DRDA gateway (DB2 COnnect EE), a DRDA
client (DB2 Connect Personal Edition), or the new type 4 JDBC driver in
DB2 Connect V8 (which will allow direct connections from a type 4 JDBC
client, but still requires a DB2 Connect license) ... and I'm not
entirely sure whether the type 4 JDBC driver in V8 will support either
DB2/390 V6 or SNA.
yes that's my option also. I have a piece of java code to test the type 4
connect:

/*+----------------------------------+*/
/*! initialize JDBC/ODBC environment !*/
/*+----------------------------------+*/
try
{
// choose driver...
if (in_host_name.l ength() > 0 && in_port_number. length() > 0)
{ // use NET driver
db2_class = "COM.ibm.db2.jd bc.net.DB2Drive r";
db2_url = "jdbc:db2://" + in_host_name + ":" + in_port_number + "/"
+ in_source_db_na me;
}
else
{ // use APPlication driver
db2_class = "COM.ibm.db2.jd bc.app.DB2Drive r";
db2_url = "jdbc:db2:" + in_source_db_na me;
}
Driver myDBDriver = (Driver)Class.f orName (db2_class).new Instance();

// get db connection
System.out.prin tln ("DB2_Class= " + db2_class);
System.out.prin tln ("Connect_UR L=" + db2_url);
if (in_usr_name.eq uals("")) db_conn = DriverManager.g etConnection
(db2_url, "", "");
else db_conn = DriverManager.g etConnection (db2_url, in_usr_name,
in_usr_pw);
The description of your environment is not exactly clear to me. Where do
you receive this error msg? On the client? Gateway Server? What exactly
is the client configuration, and the gateway server configuration?
The sql message is kind of misleading, eh? Ok I try to describe the
environment more exactly...

(I) Host with MVS and DB2 v6.1.2
Subsystem called DB2T
I call this a server

(II) Solaris machine with DB2 Connect EE v7.2.9
Instance: GWMVS
Host DB cataloged at APPN node as DB2T
I call this gateway

(III) AIX machines with DB2 EEE v7.2.9
Instance: DB2TEST
cataloged GWMVS as TCPIP node
cataloged Host DB at TCPIP node GWMVS as DB2T
this is DB2 server but acts as client against host DB2

In this environment the connection to DB2T from machine (III), instance
DB2TEST works just fine. Now I got another instance V8TEST installed on
machine (III) with DB2 v8.1.5. With the same cataloging I get SQL1334N when
connecting to DB2T. I thought that DB2 v8 already has DRDA included, so the
only thing that is missing would be perhaps SNA...or that the gateway isn't
needed anymore when the host gets TCP/IP? This is primarily not a question
of licenses.
My advice is get off SNA asap.
yep. I told that since two years or so...
Larry Edelstein


Regards
aka
Nov 12 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3292
by: Marc | last post by:
Hello, Newbie here..... Searching and working this for a week now. We too are having the same problems. Using MySql 4.0.14 and there are "no problems" at all.
1
2523
by: Claus van de Vlierd | last post by:
Hello , a) in the following script (under RedHat AS3 with PHP 4.3.2 ) I make a "DB::connect" to an existing "mysql" database named "docu_files_of_cvdv" . The strange thing is : it works -- even if I give as protocol the string "nonsenseprotocol" (instead of "unix" or "tcp") and as Hostname "nonsensehostname" ... !!
4
2952
by: Mike | last post by:
Related to another topic I just posted, I wanted to discuss ways to optimize the validation of very large (>100MB) XML documents. First, I have no idea if something like this already exists; it may even be the typical implementation for all I know. At any rate, it occurs to me that the set of business rules that need to be validated...
5
15064
by: D. Dante Lorenso | last post by:
I have a simple table that I'd like to query to pull out a heirarchy from a tree relationship. What is the best way to do this without a 'CONNECT BY' clause like Oracle has? Example mytable +----------+-----------+ | child_id | parent_id |
0
409
by: aka | last post by:
Hi I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect instance as tcpip node and then the Host DB cataloged on that node...this works from v7.2 Fixpack 11 clients and servers, but with v8.1 server I get SQL1334N. Does anyone has an idea? ...
14
7012
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that sql server resides on is not reachable. The error is different depending on the connection string that I use. If I use the following connection...
0
2060
by: jordo | last post by:
I have an asp.Net app that connects to the WSS 2.0 list web service. I'm having issues with IIS and .Net configurations and hope that someone can help me. My ideal configuration is: asp.net: Authentication Mode=Windows Identity Impersonate=False IIS Allow Anonymous Disabled Integrated Windows Authentication Enabled Application Pool...
2
5320
by: daft | last post by:
Hi guys Following on from an issue a couple of years back, now archived: http://www.thescripts.com/forum/thread208561-tabledef.connect.html I'm having the same problems. I can update the Querydef.connect property programmatically without any problems, however if I try to update the Tabledef.connect property it won't do it, even though...
2
5815
by: Flash08 | last post by:
Hi all, I'm having some trouble with connecting to SQL server instance lately without adding a port number. I used to be able to always connect to instance without having to input SQLSERVER,portnumber. However now this is not the case. I doing this through an ADO connection object, and creating the connection string. Does anyone know if...
0
7614
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7924
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7974
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6284
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5513
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3653
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2114
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1221
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
938
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.