VERIFIED SOLUTION i
X

Resolve performance difference between DB2 client 8.1 and 9.7 (and later) with Sagent

Issue

Execution of same plan on a machine having DB2 client 9.7 (or later) installed takes considerably more time as compared to a machine with DB2 client 8.1.

Cause

Sagent code pushes an async enabled command. It had no effect on the older versions of the db2 client (8.1 or earlier) as async was not supported in those, however it causes the poor performance with newer clients since they do support async.

Resolution

UPDATED: June 5, 2017


As a workaround, include "asyncenable=0" setting in the COMMON section of DB2CLI.ini file.

Environment Details

Product Feature: DataFlow Server
Database: DB2 Server 10.1, DB2 Client 10.1/9.1/8.1

Downloads

  • No Downloads