Hi All,
I am using ODBC stage as load,my target database is DB2.I need commit each 5000 rows.colud you tell me where i can set this option.
Thanks,
Raj
ODBC Stage
Moderators: chulett, rschirm, roy
ODBC Stage
Raj
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is this an interview question?
Why would you be using an ODBC stage to populate a DB2 table? Why not a DB2 stage of some kind?
Do you mean ODBC Enterprise stage or some other ODBC stage type?
Why would you be using an ODBC stage to populate a DB2 table? Why not a DB2 stage of some kind?
Do you mean ODBC Enterprise stage or some other ODBC stage type?
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.
Hi Ray,ray.wurlod wrote:Is this an interview question?
Why would you be using an ODBC stage to populate a DB2 table? Why not a DB2 stage of some kind?
Do you mean ODBC Enterprise stage or some other ODBC stag ...
I need to know how many rows get inserted or updated in a target table , I think ODBC stage providing this info in the log. This is very much useful for me to generating stats report. Because of this , i am using ODBC Enterprise stage. In target ODBC stage i am using Upsert Mode =Insert then update and Write Method = Upsert.
There is problem when Volume of data is more, it took nearly 3 hours for 17 million rows to load. here commit happens on each row.
Please help me how to improve the performance in ODBC EE stage.
Thanks,
Raj
Raj
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No stage can report how many were actually inserted/updated. They can only report how many they sent. You can also get a count of rejects (which the Oracle Enterprise stage can do).
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.