I am struggling with something like to open multiple connections to a db2 sever at a time . Maximum of 3 connections to be run.
I tried with ATS but have to run on a federation database & finally ended up with a bug.
Can some one kindly give me a small basic code like an db2luw external procedure or function to open 2 connections on a db2 server.
I can't use any sql file to open the connection as the database name & procedure call statements are dynamic.
I got tired to find out the solution for this.
I am not completely into Db2 so unable to get the complete concepts in it.
I am using db2 c express on windows.
Thanks for the reply ARWinner.
Actually I am having 100 tables each having 30 records. I can update these 100 tables one by one on a direct call in a procedure, As the control has to pass table by table serially, which is taking more time.
My requirement is how can i run at-least three update statements at a time concurrently.For example I have to start updating table1 & without waiting to get completed I have to start updating table2.
If you don't have the SQLLIB\samples catalog, then it means that you didn't checked the corresponding option during db2 installing. You may try to install an additional db2 express-c copy for that.
If you have zero knowledge on java, it's worth to start learning from the following examples: SpServer.java, SpClient.java