I am using Component Integration Services using Sybse 11.5 to DB2 in Mainframne. Sybase11.5 is loaded on Dec Alpha. All the tables of DB2 are defined as proxy tables. The SQL execution is taken care of by AMD2.
I use stored proc and refer proxy tables. In a typical stored proc I use a couple of SQLs (mix of select, update and insert).
The problem is that I have proc having 4 SQl commands (4 inserts) it is taking a lot of time to execute. Upon analysing I find each SQL statement is starting a connection, executing the statement and then disconnecting the connection to DB2. Each insert is taking about 2 seconds where it should not take more that 1/10th of a second.
Is anybody having any idea how to optimize this or any alternate