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
HOW to increase the performance of a QS job
Moderators: chulett, rschirm, roy
-
n.parameswara.reddy@accen
- Participant
- Posts: 40
- Joined: Mon May 18, 2009 5:22 am
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.