Problems with scratch space while using JOIN stage in DS 8.5
Posted: Fri Nov 18, 2011 5:35 am
Hi, to everyone!!!
I am newer in Dastage.
How to config scratch space when trying to join 2 table with big amount of data. Each table has more then 200 million records in it.
Config file:
Configuration:
resource disk size : 500 gb
OS: Windows 2003 SP2 x64
Datastage version: 8.5
Job type: parallel
Using current configuration system has not got enought free space for tsort files in scratch directory.
Is it possible somehow to remove tsort operator?
Thank you!!!
I am newer in Dastage.
How to config scratch space when trying to join 2 table with big amount of data. Each table has more then 200 million records in it.
Config file:
Code: Select all
{
node "node1"
{
fastname "srv-etl-dev"
pools ""
resource disk "C:/IBM/InformationServer/Server/Datasets/node1" {pools ""}
resource scratchdisk "C:/IBM/InformationServer/Server/Scratch/node1" {pools ""}
}
node "node2"
{
fastname "srv-etl-dev"
pools ""
resource disk "C:/IBM/InformationServer/Server/Datasets/node2" {pools ""}
resource scratchdisk "C:/IBM/InformationServer/Server/Scratch/node2" {pools ""}
}
}
resource disk size : 500 gb
OS: Windows 2003 SP2 x64
Datastage version: 8.5
Job type: parallel
Using current configuration system has not got enought free space for tsort files in scratch directory.
Is it possible somehow to remove tsort operator?
Thank you!!!