DB2 CONNECT configure and Sysplex support

zgh1970

Hi, All,
I have question on DB2 CONNECT configure.
We installed DB2 ESE V8 FixPak 14 o AIX .
When we set up the connection to DB2 Mainframe.
We just catalog node and DB directory without DCS.
From what I know, DB2 conenct needs to set up node, dcs and db
directories.

Why DB2 CONNECT can connect to DB2 mainframe without the DCS?

Another issue on the Sysplex support on the above db2 connect
configuration.
We have set DB2CONNECT_IN_A PP_PROCESS=NO ,
But i can still see reroute.
I checked IBM http://www-1.ibm.com/support/docview...id=swg21253021
It has the difference on DB2 Connect and gateway.
Is my above set is gateway or DB2 Connect?
In case the client applications are running locally on the same
physical machine as DB2 Connect, you need to set
DB2CONNECT_IN_A PP_PROCESS=NO to force the local clients to run in an
agent so as to utilize Sysplex support.

db2set DB2CONNECT_IN_A PP_PROCESS=NO

db2stop

db2start
However, if you want to disable DB2 Connect Sysplex support on your
gateway, you can simply catalog a DCS database without specifying the
Sysplex in the parameter list and re-catalog the DCS database as your
database alias. You can also turn off Sysplex in V8 by setting the DB2
registry variable DB2SYSPLEX_SERV ER to zero, but this variable is
deprecated in DB2 Connect V9. By default this variable is set to a
nonzero value in DB2 Connect V8.

thanks,

Jun 27 '08 #1

Subscribe Reply

3804

Larry

As for your first question, are you certain that you are connecting to
the mainframe? Could it be that you are connecting locally?

Larry E.

zgh1970 wrote:

Hi, All,
I have question on DB2 CONNECT configure.
We installed DB2 ESE V8 FixPak 14 o AIX .
When we set up the connection to DB2 Mainframe.
We just catalog node and DB directory without DCS.
From what I know, DB2 conenct needs to set up node, dcs and db
directories.

Why DB2 CONNECT can connect to DB2 mainframe without the DCS?

Another issue on the Sysplex support on the above db2 connect
configuration.
We have set DB2CONNECT_IN_A PP_PROCESS=NO ,
But i can still see reroute.
I checked IBM http://www-1.ibm.com/support/docview...id=swg21253021
It has the difference on DB2 Connect and gateway.
Is my above set is gateway or DB2 Connect?
In case the client applications are running locally on the same
physical machine as DB2 Connect, you need to set
DB2CONNECT_IN_A PP_PROCESS=NO to force the local clients to run in an
agent so as to utilize Sysplex support.

db2set DB2CONNECT_IN_A PP_PROCESS=NO

db2stop

db2start
However, if you want to disable DB2 Connect Sysplex support on your
gateway, you can simply catalog a DCS database without specifying the
Sysplex in the parameter list and re-catalog the DCS database as your
database alias. You can also turn off Sysplex in V8 by setting the DB2
registry variable DB2SYSPLEX_SERV ER to zero, but this variable is
deprecated in DB2 Connect V9. By default this variable is set to a
nonzero value in DB2 Connect V8.

thanks,

Jun 27 '08 #2

zgh1970

On May 1, 4:10*pm, Larry <la...@nospam.n etwrote:

As for your first question, are you certain that you are connecting to
the mainframe? Could it be that you are connecting locally?

Larry E.

zgh1970 wrote:
Hi, All,
I have question on DB2 CONNECT configure.
We installed DB2 ESE V8 FixPak 14 o AIX .
When we set up the connection to DB2 Mainframe.
We just catalog node and DB directory without DCS.
From what I know, DB2 conenct needs to set up node, dcs and db
directories.

Why DB2 CONNECT can connect to DB2 mainframe without the DCS?

Another issue on the Sysplex support *on the above db2 connect
configuration.
We have set DB2CONNECT_IN_A PP_PROCESS=NO ,
But i can still see reroute.
I checked IBM *http://www-1.ibm.com/support/docview...id=swg21253021
It has the difference on DB2 Connect and gateway.
Is my above set is gateway or DB2 Connect?

In case the client applications are running locally on the same
physical machine as DB2 Connect, you need to set
DB2CONNECT_IN_A PP_PROCESS=NO to force the local clients to run in an
agent so as to utilize Sysplex support.

db2set DB2CONNECT_IN_A PP_PROCESS=NO

db2stop

db2start

However, if you want to disable DB2 Connect Sysplex support on your
gateway, you can simply catalog a DCS database without specifying the
Sysplex in the parameter list and re-catalog the DCS database as your
database alias. You can also turn off Sysplex in V8 by setting the DB2
registry variable DB2SYSPLEX_SERV ER to zero, but this variable is
deprecated in DB2 Connect V9. By default this variable is set to a
nonzero value in DB2 Connect V8.

thanks,- Hide quoted text -

- Show quoted text -

Hi, Larry,
I am sure it can connect to mainfrmaw withour DCS directory.
thanks,

Jun 27 '08 #3

Similar topics

27922

How to configure MySQL ODBC driver to connect to a mysql server on my own side of the router?

by: MLH | last post by:

Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my linux box" will do nicely) Host/Server Name (or IP) - something like MSQLUserName@ServerName.net...

MySQL Database

2476

Linking SQL Server 2000 to DB2 Connect 8.x

by: Dad | last post by:

I need to connect SQL Server 2000 to DB2 on z/OS through DB2 Connect 8. I can successfully connect and query data through a System DSN, but trying to link the server using this DSN and MSDASQL fails (can't seem to find the DB2 Connect server). I've also tried IBM's OLE/DB driver (IBMDADB2). Has anyone successfully linked to DB2 on a mainframe through DB2 Connect 8.x via either ODBC or OLE/DB drivers?

Microsoft SQL Server

3609

Does any one know how to use php to connect sybase 5.5?

by: Alex Murphy | last post by:

As title, Thanks

PHP

17592

connect to db2 server with odbc

by: Thijs | last post by:

Hi, i'm new to db2, so the answer on this question is maybe verry simple (or not)... i've installed db2 on a server, and now, I want to make a connection with odbc from a client (windows 2000). I installed the IBM DB2 odbc driver.

DB2 Database

2113

connect vb app to sql 2005 express

by: josh | last post by:

I'm pretty new to both sql 2005 and VB but please bear with me. I have installed SQL 2005 express on a Windows 2003 Standard server. I have also installed VB 2005 Express edition on the server. SQL seems to be running fine (I can create databases, tables, modify them, etc.) I have created a very basic app in VB express that just lets me view and modify the current tables. It works just fine on the server. However, I am trying to make...

Visual Basic .NET

4784

CALL SQLEXEC "CONNECT TO ......."

by: cberthu | last post by:

Hi all, Is it possible to have two connects in the same rexx script to different DB's? I have to get data form on DB (with specifics selects and filter out some values with RExx) and save the results into another DB? I know from Wscripts and MS-Sql that you can build just two objects but I did not see something like that in REXX. Thanks in advance for your help

DB2 Database

3593

Configure errors with PHP 5.2.5 (Solaris)

by: Jim McCullars | last post by:

Greetings: Getting configure errors trying to build PHP 5.2.5 under Solaris 9. The configure command I use is this: ../configure --with-mysql --with-gd --with-jpeg-dir=/usr/local --with-png-dir=/usr/local --with-zlib-dir=/usr/local --with-apxs2=/usr/local/apache2/bin/apxs --with-libxml-dir=/usr/local and I get this error:

PHP

4600

Connect ASP.net(2.0) to AS400 Iseries w/ DB2

by: Al G | last post by:

Can someone tell me what I need to get connected to our AS400? I am trying to write an app in VS2005(Data source, Gridview) that requires data from files on our AS400. I've downloaded DB2, and installed it, but apparently I need an additional product, "DB Connect" to actually make a connection. "DB connect" says that it will only display tables with a type of "T", and as far as I know, we are using files, not tables on the 400. Can...

DB2 Database

5943

Connect To Local SQL Server DB From Remote Server

by: RN1 | last post by:

Is it possible to connect to my local SQL Server 2005 database from a remote web server? If yes, what ConnectionString do I use? Thanks, Ron

ASP.NET

8991

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9552

Problem With Comparison Operator <=> in G++

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9376

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9326

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9249

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

4607

Trying to create a lan-to-lan vpn between two differents networks

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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3315

transfer the data from one system to another through ip address

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

C# / C Sharp

2787

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2215

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General