Hi All,
Db2 UDB stage which is running on 1 node and Sequential performing a operation "insert new or update existing one" taking 20 to 25 minutes for
70000 records, can any onle help me to tune the performance.
Thanks
A
DB2 UDB API stage running very slow
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
1. Separate the inserts and updates into separate streams.
2. Upgrade to version 8 and prefer DB2 Connector or DB2 Enterprise stage.
3. Execute in parallel mode if possible.
2. Upgrade to version 8 and prefer DB2 Connector or DB2 Enterprise stage.
3. Execute in parallel mode if possible.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: