Hash File Calculator? Where is it?
Posted: Mon Feb 13, 2006 9:23 am
Hi,
I am new to datastage. I am trying to write/update and read a Hash at the same time. I have seen several posts about this. I have the reference hash set up at "Disabled, Lock for Updates" (I tried just disabled also). The allow stage write cache is not checked in the hash stage to which I write. Enable row buffering option is also unchecked in the job properties.I have only 30,000 rows, 8 columns and 1 key column and yet the performance is very slow! Takes nearly 10 minutes for the whole job to complete. I left all the other Dynamic hash properties at default values. Any help or tips to improve performance is appreciated.
I was looking at changing the properties of the hash file and reference is made in several posts about a Hash File Calculator which we seem to be missing. I talked to the admin, he looked through the datastage Cd and was not able to find it. Where are we supposed to find it?
Please help.
Thank You,
Jahnavi
I am new to datastage. I am trying to write/update and read a Hash at the same time. I have seen several posts about this. I have the reference hash set up at "Disabled, Lock for Updates" (I tried just disabled also). The allow stage write cache is not checked in the hash stage to which I write. Enable row buffering option is also unchecked in the job properties.I have only 30,000 rows, 8 columns and 1 key column and yet the performance is very slow! Takes nearly 10 minutes for the whole job to complete. I left all the other Dynamic hash properties at default values. Any help or tips to improve performance is appreciated.
I was looking at changing the properties of the hash file and reference is made in several posts about a Hash File Calculator which we seem to be missing. I talked to the admin, he looked through the datastage Cd and was not able to find it. Where are we supposed to find it?
Please help.
Thank You,
Jahnavi