IBM Support

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 number

    JR30427

  • Reported component name

    DB2 CEE WINDOWS

  • Reported component ID

    5765F3001

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-09-05

  • Closed date

    2010-05-12

  • Last modified date

    2010-05-12

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 May 2010