Terdata performance issues post-upgrade
Posted: Thu Dec 19, 2013 11:00 pm
Hi All,
In a client migrated the server datastage 7.5 on AIX 7 32bit To DataStage 8.7 on AIX 7 64bit and database TeraData 14.
We have problems with performance job, all using FastLoad and FastExport Stage. Jobs in the version 7.5 with 40 million records take 2 mins but in version 8.7 delayed 3 hours
we review the teradata client libraries, configuration in dsenv but were unable to find results
Someone has a history of performance problems between TeraData 14 and DatStage 8.7, additional configuration points to improve the parallelism?
Regards,
Jorge Ch.
In a client migrated the server datastage 7.5 on AIX 7 32bit To DataStage 8.7 on AIX 7 64bit and database TeraData 14.
We have problems with performance job, all using FastLoad and FastExport Stage. Jobs in the version 7.5 with 40 million records take 2 mins but in version 8.7 delayed 3 hours
we review the teradata client libraries, configuration in dsenv but were unable to find results
Someone has a history of performance problems between TeraData 14 and DatStage 8.7, additional configuration points to improve the parallelism?
Regards,
Jorge Ch.