Migrating 7.5.1 to 8.7 performance issue on stored procedure

[boardrider]

Hi,
we are migrating from DataStage 7.5.1 to 8.7
We are facing performance issues with ODBC Stages calling a stored procedure.
All our ODBC Stages calling a stored procedure in DataStage 7.5.1 run at about 1000 rows / sec or faster.
The same ODBC Stages on DataStage 8.7 run at about 20 rows / sec or slower.
ODBC Stages not calling a stored procedure are not affected by this performance issue (for example "Clear the table, then insert rows" ones)

Both versions of Datastage access the same database server, which is a Sql Server 2005.

Additional information:
DataStage 7.5.1 runs on a Windows 2003 server
DataStage 8.7 runs on a Windows 2008 R2 server with slightly better hardware

Any suggestions ?
Are there some DataStage parameters that can improve these performances ?

Best regards

[boardrider]

Hi,
I' m glad to say that the problem is now solved.
We opened a ticket, and they found they had a performance issue with ODBC stages calling a stored procedure.
It is not been easy to convince them that it was actually an issue, but in the end we made it.
They made a Fix pack and installed it on the server.
This stages went from 20 rows / sec to 1000 rows / sec or more as they did in the old version of DataStage. We are testing our jobs at the moment and everything seems fine.

[chulett]

Thanks for posting that!