1. DB2 jdbc performance stackoverflow.comdoing profiling on an java application running websphere 7 and DB2 we can see that we spend most of our time in the com.ibm.ws.rsadapter.jdbc package handling connections to and from the ... |
2. Java - DB2 Performance Improvements stackoverflow.comWe have a SELECT statement which will take approx. 3 secs to execute. We are calling this DB2 query inside a nested While loop. Ex: While(hashmap1.hasNext()){ while(hashmap2.hasNext()){ SQL Query } } Problem is, the outer While loop will ... |
3. JDBC vs DB2 Export - Performance coderanch.comI am working with DB2 and I have to export (2 times per day) a lot of information from a table (DB2 database). I Know that exist a Utility from DB2 (export utility) but, because I need to update the rows that I export, I would prefer to use JDBC (I think that I could have more control with JDBC) but ... |
4. DB2 Performance Troubles coderanch.comHi, I'm hitting a mainframe DB2 database from my PC with IBM's driver. I have a query that runs fine for small retrieval sizes but the executeQuery() call just never returns on about 2700 rows. All the same SQL with different values for 'X' below. It's also fine at any scale from DB2 Client or SQLExplorer in Eclipse. Is there some ... |