PX Configuration

venkat · Post by **venkat** » Tue Dec 13, 2005 5:43 pm

Hi,
We had recently configured the PX on the Unix Server.
As of now performance is very slow and the sysadmin said only one node is utilized though the server is running on 2 CPUs on the same server.

Here is the configuration file.

{
node "node1"
{
fastname "wawdb14"
pools ""
resource disk "/var/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/var/Ascential/DataStage/Scratch" {pools ""}
}
}

{
node "node2"
{
fastname "wawdb14"
pools ""
resource disk "/var/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/var/Ascential/DataStage/Scratch" {pools ""}
}
}

Required help in setting up the server so that the two nodes are utilized in the job execution.

Thanks,
Venkat

ray.wurlod · Post by **ray.wurlod** » Tue Dec 13, 2005 7:48 pm

Have you set all operation to sequential mode? It would be very difficult for your sys admin to determine otherwise, because your node definitions are identical. You can only determine whether two nodes are used under such a configuration from your logs, or by using the data set management tool or viewing a File Set control file.

vmcburney · Post by **vmcburney** » Tue Dec 13, 2005 8:02 pm

Monitoring of CPU usage, RAM usage and I/O bottlenecks will give you a more complete picture of why your performance is slow. I would prefer to see each node using resource and scratch space in different locations to make it easier to monitor and improve.

trammohan · Post by **trammohan** » Tue Dec 13, 2005 9:09 pm

Define 2 logical nodes in /etc/hosts file and use those in your configuration file

{
node "node1"
{
fastname "wawdb14_new"
pools ""
resource disk "/var/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/var/Ascential/DataStage/Scratch" {pools ""}
}
}

{
node "node2"
{
fastname "wawdb14_new1"
pools ""
resource disk "/var/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/var/Ascential/DataStage/Scratch" {pools ""}
}
}

ashwin2912 · Post by **ashwin2912** » Wed Dec 14, 2005 12:00 am

trammohan,

Will that make any difference? I dont think so...

trammohan · Post by **trammohan** » Wed Dec 14, 2005 10:05 am

resource allocation will be doubled ..( scrach disk, resource disks ) . in our environment we found lot of difference..

kprama · Post by **kprama** » Wed Dec 14, 2005 12:52 pm

I think you have the extra braces which are not usually needed. Check to see if that makes any difference.

{

node "node1"
{
fastname "wawdb14"
pools ""
resource disk "/var/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/var/Ascential/DataStage/Scratch" {pools ""}
}

node "node2"
{
fastname "wawdb14"
pools ""
resource disk "/var/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/var/Ascential/DataStage/Scratch" {pools ""}
}

}