Connecting to Different Physical Node on Partitioned Database on DB2 8.1.6

stabbert

We are running DB2 UDB 8.1.6 in a partitioned environment where we have
8 physical nodes. We have a process that remotely connects to each
individual node and loads some data. By setting the DB2NODE variable
to a different value then the coordinator node is the only way I am
aware for a remote application to do this so I am making the assumption
that is how this application connects. What I am more interested in is
that after logging into any other node besides the coordinator node and
running NETSTAT I don't see a physical TCP connection to the remote box
that the application is running on. I only see a physical TCP
connection to the coordinator node. Why is this? It would appear that
even though we are connecting to a different node it is still making
some sort of a connection through the coordinator node and then the
coordinator routes the traffic to the appropriate node. Can anyone
confirm this or lend more information?
Spencer

Nov 12 '05 #1

Subscribe Reply

3253

Ronen

DB2NODE creates a gateway to the remote node through the node your
connected to instead of directly connecting to the node specified in
DB2NODE. If you want to connect directly to the remote node i would
catalog each remote node locally, and connect directly.

currently with that way you have it setup you have

client ---> node0 (gateway connection) ----> <node specified in
DB2NODE>

How to connect directly to a node:

cataloging each node:

db2 catalog tcpip node node0 remote <server0name> server <servicename>
db2 catalog tcpip node node1 remote <server1name> server <servicename>
....

catalog database on each node:

db2 catalog db <dbname> as <dbname0> at node node0
db2 catalog db <dbname> as <dbname1> at node node1
...

then instead of using DB2NODE=X connect directly dbnameX

Ronen

stabbert wrote:

We are running DB2 UDB 8.1.6 in a partitioned environment where we have 8 physical nodes. We have a process that remotely connects to each
individual node and loads some data. By setting the DB2NODE variable
to a different value then the coordinator node is the only way I am
aware for a remote application to do this so I am making the assumption that is how this application connects. What I am more interested in is that after logging into any other node besides the coordinator node and running NETSTAT I don't see a physical TCP connection to the remote box that the application is running on. I only see a physical TCP
connection to the coordinator node. Why is this? It would appear that even though we are connecting to a different node it is still making
some sort of a connection through the coordinator node and then the
coordinator routes the traffic to the appropriate node. Can anyone
confirm this or lend more information?
Spencer

Nov 12 '05 #2

stabbert

Great information! Thank you for the confirmation. We are having some
routing issues occur when the node0 is acting as a gateway connection
and we have some traffic going over a network that it shouldn't be.
This information will be of great help. I am assuming also that when I
specify something other then the controlling node the controlling node
then uses the db2nodes.cfg file to find the hostname that partition
resides on and that is the host the controlling node makes a connection
too. Is this correct or is the partition number to hostname resolved
someway else?
Spencer

Nov 12 '05 #3

Thiru

Yes Stabbert. You are perfectly right.

Cheers,
thiru
WantedToBeDBA.

Nov 12 '05 #4

Similar topics

1953

how to create additional instance in different diretory----Help

by: cat | last post by:

HiFolks, I am newbie in DB2 ESE. Here is the question, I already created an instance db2inst1 under file system /db2home/db2inst1 ( actually the instance has been created after installation.) Now I want to create an additional instance which the DB2PATH is point to /aix1/db2test. What shall I do, I found in IBM doc says You can change the location of the instance directory from DB2PATH using

DB2 Database

1572

db2 api sqlesetc() not connecting to catalog node

by: Sandeep S. Mutalik | last post by:

Hi, I am working with db2 8.1 ese instance with two physical nodes on AIX 5.1 boxes. I want to get history of the dropped tables from any of the nodes. I tried to use db2 api function sqlesetc(). My code is as below: struct sqle_conn_setting connSetting ; connSetting.type = SQL_ATTACH_NODE ;

DB2 Database

17635

how to use sql to query from different database

by: xixi | last post by:

hi, we use db2 udb v8.1 on windows, i am trying to use federated database objects to create wrapper, even though i have update dbm cfg using federated yes, i still get error "the instance for the db is not enable for the specified action", do i miss sth else?

DB2 Database

7897

Database Physical Location in UDB 8.1

by: Kamlesh | last post by:

Hi, How do I know the physical database path of a database. When I goto the DB2INSTANCE users's directory (/home/db2inst1), I see following folders: /db2inst1/NODE0000/SQL00001 /db2inst1/NODE0000/SQL00002 /db2inst1/NODE0000/SQL00003 /db2inst1/NODE0000/SQL00004

DB2 Database

1496

Local config vs. LDAP, weirdness connecting

by: for_your_spam_only | last post by:

Hi everybody, please take a look at the "screenshot" (DB2 CLI), Server is V7, FP12 running on WinNT, LDAP service is on AIX, IBM Directory Server 4.1 D:\>db2level DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08021" with level identifier "03020106". Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", and FixPak "8".

DB2 Database

5230

SQL6024E Table or index "tab_name" is not defined on node "0".

by: db2udbgirl | last post by:

Env : DB2 UDB 8.2 / AIX 5.3 When I try to use some DB2 Utilities against a partitioned table which is not defined on a particular node (Node 0 in this case) I'm getting this error. /home/db2udbgirl> db2 load query table ETL.TRANSACTION SQL6024E Table or index "TRANSACTION" is not defined on node "0". Hence I would do the following operation as a workaround

DB2 Database

3921

Connecting to Server Problem

by: Suresh | last post by:

Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2 development client. Bur Its gives me following error message. I searched lots of things on net and tried on remote server but i didnt got suceess. Can any one tell me how to set TCP\IP connection protocol on server for particular instance. Becuase I think

DB2 Database

15952

Error connecting to V9 remote database

by: mairhtin o'feannag | last post by:

Hello, I'm having problems connecting to my new v9 db box. The pertinent information is below: DB2_db2inst1 60000/tcp DB2_db2inst1_1 60001/tcp DB2_db2inst1_2 60002/tcp DB2_db2inst1_END 60003/tcp

DB2 Database

9285

Linux DB2 Client Hangs when Connecting to Remote Host

by: malooga | last post by:

Hello, I'm having a problem connecting to DB2 on a remote iSeries host from a Linux server, both of which reside on my company's internal network. I'm using the IBM Linux Client V9.1. When I try to connect to the remote host using a simple connect statement, DB2 hangs. The connection statement I'm using (I've obviously obscured the parameter names): $ ./db2 connect to DATABASENAME user USERNAME using PASSWORD;

DB2 Database

9234

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

9180

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

8186

AI Job Threat for Devs

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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6733

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6030

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4548

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

4805

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3259

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

2721

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