Database connections in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Tue Jan 06, 2015 4:30 am
Database connections in datastage
Hello Experts,
Just had a query.
Suppose my jobs runs on a head node and a compute node.
Now if i am using a database in the job, will the network sockets for the database be opened from the head node or the compute node?
Currently i am seeing sockets opened for both head node and compute node.
i.e. from where exactly are the database connections made?
Just had a query.
Suppose my jobs runs on a head node and a compute node.
Now if i am using a database in the job, will the network sockets for the database be opened from the head node or the compute node?
Currently i am seeing sockets opened for both head node and compute node.
i.e. from where exactly are the database connections made?
Re: Database connections in datastage
If i understand correctly. you are trying to connect to database ex: oracle from Datastage server A (head Node) server B (Compute node). yes you need to open the firewall and ports from both the Servers A and B and update the tnsnames.ora file on both the Servers A and B.
I think Database connections are made from Conductor node (Head Node)
lets see what others say.
I think Database connections are made from Conductor node (Head Node)
lets see what others say.
A Kumar
-
- Participant
- Posts: 32
- Joined: Fri Nov 07, 2014 11:18 am
-
- Participant
- Posts: 103
- Joined: Tue Jan 06, 2015 4:30 am
Ashsish/electajay,
Let me explain further, suppose i am using a DB2 DB in my job. I am connecting to db server using port say 65432. Now when i do a on both head nodes and compute node, i can see connections established.
So i was wondering where exactly are the connections made from? Head node or compute node.
Also the section leaders for the connector stage runs on compute nodes, so shouldnt the DB connections be made from the compute nodes?
Currently i can see DB connections on both head and compute node.
Let me explain further, suppose i am using a DB2 DB in my job. I am connecting to db server using port say 65432. Now when i do a
Code: Select all
netstat -a|grep 65432
So i was wondering where exactly are the connections made from? Head node or compute node.
Also the section leaders for the connector stage runs on compute nodes, so shouldnt the DB connections be made from the compute nodes?
Currently i can see DB connections on both head and compute node.
-
- Participant
- Posts: 32
- Joined: Fri Nov 07, 2014 11:18 am
-
- Participant
- Posts: 103
- Joined: Tue Jan 06, 2015 4:30 am
"View Data" at design time uses a different connection method than connections made at run time, so that would make sense.
The DB2 Connector also has a setting (not sure its value, as I'm not on a grid): In the Alternate conductor settings field, specify whether you want to provide alternate connection settings to use on the conductor node. The default value is No.
Also, here is some interesting reading on using direct connections:
http://www-01.ibm.com/support/knowledge ... tions.html
The DB2 Connector also has a setting (not sure its value, as I'm not on a grid): In the Alternate conductor settings field, specify whether you want to provide alternate connection settings to use on the conductor node. The default value is No.
Also, here is some interesting reading on using direct connections:
http://www-01.ibm.com/support/knowledge ... tions.html
Choose a job you love, and you will never have to work a day in your life. - Confucius