Configuration file modification
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
Configuration file modification
Hi,
Currently we are using 4 node configuration file. All nodes we are utilizing only for resource and scratch disk.
Is their any possibility to use one of the nodes for database for fetching data from source/loading data into target (As we are using ODBC to connect to SQL Sever database). Remaining 3 nodes use for resource and scratch disk.
As I am using more number of datasets and ODBC stages in the jobs. Searching for the possibility tune the job at configuration level.
Please let me know the syntax to change the configuration file on mapping one of nodes for database. Remaining for the (resource and scratch disk)
Current configuration file.
{
node "node1"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N1" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N1" {pools ""}
}
node "node2"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N2" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N2" {pools ""}
}
node "node3"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N3" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N3" {pools ""}
}
node "node4"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N4" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N4" {pools ""}
}
}
I appreciate your help in regards to this.
Thanks and Regards,
Currently we are using 4 node configuration file. All nodes we are utilizing only for resource and scratch disk.
Is their any possibility to use one of the nodes for database for fetching data from source/loading data into target (As we are using ODBC to connect to SQL Sever database). Remaining 3 nodes use for resource and scratch disk.
As I am using more number of datasets and ODBC stages in the jobs. Searching for the possibility tune the job at configuration level.
Please let me know the syntax to change the configuration file on mapping one of nodes for database. Remaining for the (resource and scratch disk)
Current configuration file.
{
node "node1"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N1" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N1" {pools ""}
}
node "node2"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N2" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N2" {pools ""}
}
node "node3"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N3" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N3" {pools ""}
}
node "node4"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N4" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N4" {pools ""}
}
}
I appreciate your help in regards to this.
Thanks and Regards,
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
{
node "node1"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N1" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N1" {pools ""}
}
node "node2"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N2" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N2" {pools ""}
}
node "node3"
{
fastname "abcd123"
pools ""
resource disk "/inputdir/DataSets/DataSets_N3" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N3" {pools ""}
}
node "node4" /* SQL Server node */
{ /* Note that this node is not in the default node pool "" */
fastname "abcd123"
pools "sqlserver"
resource disk "/inputdir/DataSets/DataSets_N4" {pools ""}
resource scratchdisk "/inputdir/Scratch/Scratch_N4" {pools ""}
}
}
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
Thanks for valuable responses.
As I am not premium member I am unable to see the ray wurold message.
Notes from the chain responces.
1. We are not going to update the existing configuration file.
2. We will create a new configuration file.
I have small clarification, can we assign configuration file (one node) to ODBC stage.
Thanks and Regards,
Suri.
As I am not premium member I am unable to see the ray wurold message.
Notes from the chain responces.
1. We are not going to update the existing configuration file.
2. We will create a new configuration file.
I have small clarification, can we assign configuration file (one node) to ODBC stage.
Thanks and Regards,
Suri.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes you can, as my response shows. It's up to you when you get your premium membership. It's not expensive (under 30c (Rs12) per day) and worth every penny/paise).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom