ScratchDisk Configuration
Posted: Mon Jul 23, 2012 4:03 am
Hi,
we use the below 4 nodes configuration for our prod environment and curious to understand multinode configuration for Scratch disk (scratch area) will improve performance during SORT operation.
Here is the configuration file.
All of your expertise advice are highly appreciated.
Regards
Elavenil
we use the below 4 nodes configuration for our prod environment and curious to understand multinode configuration for Scratch disk (scratch area) will improve performance during SORT operation.
Here is the configuration file.
Code: Select all
{
node "node1"
{
fastname "prd_edw"
pools ""
resource disk "/EDW/SG1/" {pools ""}
resource scratchdisk "/EDW/SCR1/" {pools "sort" ""}
resource scratchdisk "/EDW/SCR2/" {pools ""}
}
node "node2"
{
fastname "prd_edw"
pools ""
resource disk "/EDW/SG2/" {pools ""}
resource scratchdisk "/EDW/SCR2/" {pools "sort" ""}
resource scratchdisk "/EDW/SCR1/" {pools ""}
}
node "node3"
{
fastname "prd_edw"
pools ""
resource disk "/EDW/SG3/" {pools ""}
resource scratchdisk "/EDW/SCR1/" {pools ""}
resource scratchdisk "/EDW/SCR2/" {pools "sort" ""}
}
node "node4"
{
fastname "prd_edw"
pools ""
resource disk "/EDW/SG4/" {pools ""}
resource scratchdisk "/EDW/SCR2/" {pools ""}
resource scratchdisk "/EDW/SCR1/" {pools "sort" ""}
}
}
Regards
Elavenil