time difference between DB2 execution and SQL insertion

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › time difference between DB2 execution and SQL insertion

Viewing 0 reply threads
  • Author
    Posts
    • #18194

      Hello guys,

       

      We got two biztalk servers which are load balanced. We get the data from the db2 database and insert it into the sql database.Inbetween we use orchestration. The polling is done for every 1 hour.To avoid duplication of data, I created a staging table , in which the db2 execution time will be updated in the staging table when ever the data is inserted into the sql database, so if the new message arrives it checks in the staging table ,if the difference between the previous execution time and current time is greater than 60 min , then the row is inserted into the sql database, If not the message gets terminated. But there is a huge time difference between DB2 execution and SQL insertion (30 to 45 min). Can any provide me a solution why it is taking so much time to insert data into the SQL data base.

       

      Ram.

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.