Hi, 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 way in Java to screw up this badly?
Database: UDB version 9 on Z/OS Driver: com.ibm.db2.jcc.DB2Driver Query: SELECT COL1, COL2, COL3 FROM TBL_NM WHERE COL2 = 'X' What I tried: stmt.setFetchSize()
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Joined: Jan 29, 2003
I got no answer, so I "moved" this to Performance. Follow the link if you have any ideas for me. Thanks!