DSXchange

I am using DB2PX stage(just select query for retiring nearly 222 fields with where condition) as input and standardizing on 3 input fields , then with help of DB2PX loading(nearly 300 fields) into DB2 database ,but its taking 1 hour for 1 Lac records .

Can you please help me how to increase the performance of a QS job

Advance thanks

PARAM

Are you using DB2 Load (or direct write from an Enterprise or Connector stage)?

As a test can you write the results of the QS job into a Copy stage, to determine whether the slowness is in QS or DB2?