DB2 Performance Troubles

[Stan James]

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()

The Code:

public void executeQuery(String sql, ResultSetHandler listener) throws Exception {
    Statement stmt = null;
    ResultSet rs = null;
    try {
        stmt = connection.createStatement();
        rs = stmt.executeQuery(sql);
        new ResultSetReader(listener).read(rs);
    }
    catch (SQLException e) {
        System.out.println(e.getMessage());
        throw e;
    }
    finally {
        Closer.close(rs);
        Closer.close(stmt);
    }
}

[Stan James]

I got no answer, so I "moved" this to Performance. Follow the link if you have any ideas for me. Thanks!

[Jeanne Boyarsky]

I'm going to close this for you so we don't have conversation in two places. For future reference, note that the forum moderators or any sheriffs can move a thread for you.