how to determine which scratchdisk is picked first
Posted: Fri Feb 20, 2009 1:08 pm
Hi
How does DataStage determine which scratchdisk to pick when more than one is specified for a node? In the below configuration, I have specified "/ds/dsscratch" first as it is a faster disk space. However, when I execute the job, I find that "/archive/dsscratch" is being used. I was able to determine this based on the fact that temp files were getting created in "/archive/dsscratch" and not in "/ds/dsscratch".
node "node1"
{
fastname "abcbprd01"
pools ""
resource disk "/ds/dstmp" {pools ""}
resource disk "/archive/dstmp" {pools ""}
resource disk "/retro/dstmp" {pools ""}
resource scratchdisk "/ds/dsscratch" {pools "" "sort" "buffer"}
resource scratchdisk "/archive/dsscratch" {pools "" "sort" "buffer"}
resource scratchdisk "/retro/dsscratch" {pools "" "sort" "buffer"}
}
node "node2"
{
fastname "abcbcbprd01"
pools ""
resource disk "/ds/dstmp" {pools "" }
resource disk "/archive/dstmp" {pools ""}
resource disk "/retro/dstmp" {pools ""}
resource scratchdisk "/ds/dsscratch" {pools "" "sort" "buffer"}
resource scratchdisk "/archive/dsscratch" {pools "" "sort" "buffer"}
resource scratchdisk "/retro/dsscratch" {pools "" "sort" "buffer"}
}
Is there anyway to control what scratchdisk needs to be used first?
Thanks
Ravi
How does DataStage determine which scratchdisk to pick when more than one is specified for a node? In the below configuration, I have specified "/ds/dsscratch" first as it is a faster disk space. However, when I execute the job, I find that "/archive/dsscratch" is being used. I was able to determine this based on the fact that temp files were getting created in "/archive/dsscratch" and not in "/ds/dsscratch".
node "node1"
{
fastname "abcbprd01"
pools ""
resource disk "/ds/dstmp" {pools ""}
resource disk "/archive/dstmp" {pools ""}
resource disk "/retro/dstmp" {pools ""}
resource scratchdisk "/ds/dsscratch" {pools "" "sort" "buffer"}
resource scratchdisk "/archive/dsscratch" {pools "" "sort" "buffer"}
resource scratchdisk "/retro/dsscratch" {pools "" "sort" "buffer"}
}
node "node2"
{
fastname "abcbcbprd01"
pools ""
resource disk "/ds/dstmp" {pools "" }
resource disk "/archive/dstmp" {pools ""}
resource disk "/retro/dstmp" {pools ""}
resource scratchdisk "/ds/dsscratch" {pools "" "sort" "buffer"}
resource scratchdisk "/archive/dsscratch" {pools "" "sort" "buffer"}
resource scratchdisk "/retro/dsscratch" {pools "" "sort" "buffer"}
}
Is there anyway to control what scratchdisk needs to be used first?
Thanks
Ravi