Hi,
we have recently installed datastage 7.5 on AIX 5.2 and we have poor performance.
When we want to load a file from a table which content 102 columns and 145000 lines, the load is very slow.
We put the array size parameter to 10000 what has improve our performance, about 1300 row/s. But it is not satisfactory . It must be better
On our system we have 2 proc and 5 Go of RAM.
Is there a parameter in AIX or Datastage that we must change to improve the performance.
Thanks for your help
we have recently installed datastage 7.5 on AIX 5.2 and we have poor performance.
When we want to load a file from a table which content 102 columns and 145000 lines, the load is very slow.
We put the array size parameter to 10000 what has improve our performance, about 1300 row/s. But it is not satisfactory . It must be better
On our system we have 2 proc and 5 Go of RAM.
Is there a parameter in AIX or Datastage that we must change to improve the performance.
Thanks for your help