JR30427: JCC TYPE 4 CONNECTION HANGS WHEN GOING THROUGH DB2 CONNECT TO AN ISERIES (V6R1)

APAR status

• Closed as program error.

Error description

• There is a hang during an executeQuery when using the JCC driver
  (type 4 mode) to access an iSeries database via DB2 Connect. The
  same test works when JCC connects directly to the iSeries. A
  standalone test has been produced which recreates the failure.
  The essence of that is like so:
  
  System.out.println("inserting new record...");
  Statement stmt = conn.createStatement();
  stmt.executeUpdate("insert into cmtest values ( 21 , 'gaga' )");
  //set autoCommit false
  conn.setAutoCommit(false);
  //create statement
  Statement s =
  conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
  ResultSet.CONCUR_UPDATABLE,
  ResultSet.CLOSE_CURSORS_AT_COMMIT);
  //execute query
  System.out.println("about to execute the query...");
  s.executeQuery("select * from cmtest");
  
  In the failing scenario, the JCC driver never returns from that
  query.
  

Local fix

• Avoid using the DB2 Connect server when connecting to the DB2 on
  iSeries server. Make the connection directly from the
  application to the iSeries machine.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: *
  * JCC TYPE 4 CONNECTION HANGS WHEN GOING TO A DB2 CONNECT TO *
  * AISERIES (V6R1) *
  ****************************************************************
  * PROBLEM DESCRIPTION: *
  * purequery *
  ****************************************************************
  * RECOMMENDATION: *
  * Please move to fix pack 8 *
  ****************************************************************
  

Problem conclusion

• Please move to fix pack 8
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  JR30369

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 CEE WINDOWS

• Fixed component ID

  5765F3001

Applicable component levels

• R910 PSY

     UP