We get data from the DB2 database and insert it into the SQL database.We have a problem that there is a much time difference between db2 execution time and SQL insertion time. Finally we found that there is no problem with the Receive ports or Send Ports and the message is getting executed inside the Orchestraiton within seconds. We r thinking the problem might be when the orchestration is picking up the message from the messagebox. It is taking like 30min to 1 hour to pick a message from the messagebox.I have a doubt like whether this problem is due to much message traffic. Can anyone have a soution for this.
Ram.