ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later

[mce]

Hello,

After upgrade to PA 2.0.9.14, we have seen major performance degradation in TI processes pulling data from Oracle DB to TM1.
Is there anyone else who have seen this problem and any solutions so far?

All responses will be appreciated.

Regards,

[Steve Rowe]

Hi mce,
There has been a change in the handling of ODBC in recent releases, however we were getting out and out failures not performance drop off.

There is a long thread by Herman on the IBM forum that details something in this space, where some specific type of rule references are hitting performance of load routines.

https://community.ibm.com/community/use ... ata-slowly?

[mce]

When we execute a TI process loading data from Oracle DB, it takes twice longer in new version compared to old one.
With the new version, as we run the same process in multiple concurrent threads with different parameters to load different slices of the data, then data load speed for each thread decreases. As the number of concurrent threads increase, number of records loaded per second in each thread decreases. It looks there might be some sort of bottleneck with the new ODBCProxy which limits the total records retrieval speed in TM1 Server.

Hello,

After upgrade to PA 2.0.9.14, we have seen major performance degradation in TI processes pulling data from Oracle DB to TM1.
Is there anyone else who have seen this problem and any solutions so far?

All responses will be appreciated.

Regards,

[mce]

APAR is created for this issue:
PH53021: ORACLE ODBC DATASOURCE PERFORMANCE SLOWER THAN PREVIOUS VERSIONSOF PA
https://www.ibm.com/support/pages/apar/ ... s=swgother