IBM Support

Knowledge Collection : DB2 JDBC driver for version 9.1 APARs

Troubleshooting


Problem

Contains list of shipped APARs for the IBM® Data Server Driver for JDBC and SQLJ Version 9.1. APARs sorted by fix pack.

Resolving The Problem

Tab navigation

After reviewing the JDBC APARs you may Verify the version of the JDBC driver you have, or Download the latest JDBC driver from Fix Central.

************************************************************
Product Name : DB2 JDBC driver Version 9.1
Updated : January 20, 2014
************************************************************

Select a Fix Pack: 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1


DB2 JDBC Version 9.1 Fix Pack 12
APAR No. Abstract
No changes to the JCC driver in this fix pack from V9.1 FP11 to V9.1 FP12

DB2 JDBC Version 9.1 Fix Pack 11
APAR No. Abstract
IC78824 DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.8.85 FOR DB2 LUW V9.1 FIXPACK 11

DB2 JDBC Version 9.1 Fix Pack 10
APAR No. Abstract
IC67694 XAER_OUTSIDE, hang or connection leak in JDBC/JCC driver
JR36693 DUPLICATE AUTHENTICATION OCCURRED IN DB2 FOR LUW SERVER

DB2 JDBC Version 9.1 Fix Pack 9
APAR No. Abstract
IC62554 CLASSCASTEXCEPTION WHEN CALLING EXECUTEBATCH() IF A STATEMENT PARAMETER THAT GETS CAST TO DECIMAL WAS SET USING SETLONG()
LI74704 SQLCODE -805 RETURNED BY IBM DB2 DRIVER FOR JDBC AND SQLJ IF BOTH CURRENTPACKAGEPATH AND CURRENTFUNCTIONPATH SET
IC65510 EXCEPTIONS ARE GETTING CHAINED TO WARNING OBJECT

DB2 JDBC Version 9.1 Fix Pack 8
APAR No. Abstract
IZ39349 JCC DRIVER NOT CHAINING COMMIT ON CURSOR CLOSE
JR31711 THE V9 JCC DRIVER FAILOVER FUNCTIONALITY IS NOT BACKWARDS COMPATIBLE WITH THE V8 JCC FUNCTIONALITY.
IZ39737 INSERT OF VARGRAPHIC VALUES WITH TRAILING SPACES FAIL WHEN USING V9 JCC T4 DRIVER
IZ40382 UNIVERSAL JDBC DRIVER FAILS TO RESOLVE INDOUBT TRANSACTIONS WHEN MORE THAN ONE MEMBER OF A DB2/Z DATASHARING GROUP IS AVAILABLE
IZ43314 NULLPOINTEREXCEPTION MAY OCCUR USING BLOB,CLOB,DBCLOB,OR XML OUT PARAMTERS ON CALLABLESTATEMENT IF PROGRESSIVE STREAMING ENABLED.
JR31309 CLIENT REROUTE WITH THE JCC DRIVER SHOULD BE SUPPORTED/ENABLED V IA SYSPLEX WORKLOAD BALANCING AGAINST DB2 FOR Z/OS.
LI74691 NULLPOINTEREXCEPTION FROM JAVA.UTIL.LINKEDLIST$LISTITR.REMOVE
LI74664 WITH DATA SHARING GROUP MEMBERS ON DIFFERENT ZOS LPARS, THE JCC PROPERTY CURRENTSCHEMA MIGHT NOT WORK, SO YOU GET ERROR SQL0204
IZ44579 SQL0805 RECEIVED EVEN AFTER FREEING STATEMENT HANDLES BEFORE.
IZ46835 AN INDEXOUTOFBOUNDS EXCEPTION MAY OCCUR ACCESSING OUT PARAMETERSRETURNED FROM A STORED PROCEDURE IF STATEMENT CACHE SIZE IS > 0.
IZ58008 JCC DOES NOT COMMIT WHEN Z/OS ROUTINE RESULTSET EARLY CLOSES
JR32080 JCC DRIVER NOT WORKING CORRECTLY WITH PREDICTIVE GOVERNOR IN DB2 V8, THUS CAUSING APPLICATION TO FAIL WITH A -30002 ERROR CODE
LI73949 JDBC API RESULTSET.GETSTRING() RETURNS DIFFERENT FORMATS FOR BIGDECIMAL NUMERIC VALUE BETWEEN JDK 1.4 AND JDK 1.5.
JR32319 JCC DRIVER DISPLAYS WARNING EXECUTING AN SQL STATEMENT AGAINST ATABLE CONTAINING A DECIMAL COLUMN ON DB2 FOR Z/OS V9
IZ52794 DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.8.62 FOR DB2 LUW V9 FIXPACK 8
IZ52613 DB2 server may crash by application snapshot with a kind of data set by JCC/JDBC

DB2 JDBC Version 9.1 Fix Pack 7
APAR No. Abstract
JCC DRIVER NOT CHAINING COMMIT ON CURSOR CLOSE
LI73560 JAVA EXCEPTION - ILLEGALSTATEEXCEPTION: TIMER ALREADY CANCELLED
LI73765 IN THE THREAD DUMP, IT APPEARS LOT OF THREADS IS WAITING FOR A JAVA.UTIL.VECTOR, HOWEVER, IT DOES NOT SHOW IN THE DUMP
LI73812 JDBC DRIVER DOESNT CAPTURE THE SQLWARNING AT PREPARE STAGE, PROPERLY
IZ32618 DEADLOCK SITUATION OBSERVED WHEN TWO OR MORE BATCH PROGRAMS RUN CONCURRENTLY ON SERVER WAS XA EDITION.
IZ39268 DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.8.47 FOR DB2 LUW V9 FIXPACK 7

DB2 JDBC Version 9.1 Fix Pack 6
APAR No. Abstract
LI73362 SETTING NON-ZERO QUERYTIMEOUT IN THE UNIVERSAL JDBC DRIVER MAY RESULT IN HIGH MEMORY USAGE IN HIGH THROUGHPUT ENVIRONMENTS
IC57215 INVOKING A Z/OS SP VIA DATASTUDIO 1.1.1 MAY RESULT WITH -4499
IZ23045 JCC 9.14 ENABLESYSPLAXWLB=TRUE IS NOT IGNORED FOR DRIVERMANGER CONNECTION AND CLIENT RE-ROUTE DOES NOT WORK CORRECTLY.
IZ28794 IBM DB2 DRIVER FOR JDBC AND SQLJ TRUNCATES TRAILING ZEROS WHEN RETRIEVING STRING VALUE FOR TIMESTAMP BY RESULTSET.GETSTRING().
IZ22295 AFTER DB2 SERVER RETURNS ABNUOWRM MESSAGE FOR SQL0911 ERROR, JCCDRIVER BLOCKS ALL LOCAL TRANSCATIONS WITH ERRORCODE=-4497.
JR29617 JCC DRIVER PROPERTY DOWNGRADEHOLDCURSORSUNDERXA=TRUE CLOSING CURSOR FOR XA LOCAL TRANSACTIONS RESULTING IN -4470
JR29176 SQL ERROR -4700 WHEN USING JCC DRIVER 3.X TO CONNECT TO DB2 Z/OS V8 IN COMPATIBILITY MODE
IZ28309 DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.8.30 FOR DB2 LUW V9.1 FIXPACK 6

DB2 JDBC Version 9.1 Fix Pack 5
APAR No. Abstract
IZ21339 JCC DRIVER RETURNS XAER_PROTO
LI72608 JCC DRIVER NOT CHAINING DRDA BUFFERS CORRECTLY WHEN IN AUTOCOMMIT MODE WITH AUTO GENERATED KEYS & LOB COLUMNS
LI72814 SOME CLASS FILES IN DB2JCC.JAR (JCC DRIVER) ARE CORRUPT
IZ07301 XAER_NOTA ON XA END, IF CALLING ROUTINE WHICH PERFORMS COMMIT ONRETURN
IZ04652 GETS -805 ERROR WHEN SYSPLEXWLB IS ENABLE & CURRENTFUNCTIONPATH,CURRENTPACKAGESET PROPERTY ARE SPECIFIED IN THE DATASOURCE
IZ15539 THE NUMBER OF RETRIES FOR CLIENT REROUTE IS DOUBLED THAN THE MAXRETRIESFORCLIENTREROUTE SET.
IZ10807 ADD SUPPORT FOR JAVA 1.5 CHANGES TO BIGDECIMAL IN THE UNIVERSAL JDBC DRIVER
IZ04224 THE JAVA APPLICATIONS ARE HUNG OR UNABLE TO CONNECT WHEN A SYSPLEX MEMBER IS RESTARTED AFTER ALL THE MEMBERS WERE DOWN
JR27842 TYPE 4 UNIVERSAL JCC DRIVER RETURNS WRONG VALUE FOR DATABASE METADATA FUNCTIONS AGAINST ISERIES.
IZ07562 BLOB.GETBYTES(1,0) THROWS SQLEXCEPTION
IZ17660 DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.7.73 FOR DB2 LUW V9.1 FIXPACK 5 (PART 1)

DB2 JDBC Version 9.1 Fix Pack 4
APAR No. Abstract
IZ01099 TO ENABLE RESETDB2CONNECTION() AGAINST DB2 UDB V9
JR27396 ENHANCEMENTS MADE TO JDBC UNIVERSAL DRIVER TO SUPPORT ZOS CLIENT RE-ROUTE FEATURE
LI72466 THE RESULTSET.UPDATEROW METHOD IS NOT UPDATING A BLOB WHEN IT ISCHANGED.
IZ03496 -4212: NO MEMBER OF SYSPLEX AVAILABLE FROM JCC DRIVER.
IZ06818 DOCUMENTATION OF CHANGES IN IBM DB2 DRIVER FOR JDBC AND SQLJ VERSION 3.6.60 FOR DB2 LUW V9 FP4

DB2 JDBC Version 9.1 Fix Pack 3
APAR No. Abstract
JR26744 JDBC CALL DATABASEMETADATA.GETMAXCOLUMNNAMELENGTH() IS RETURNING128 WHEN IT SHOULD RETURN 30.
JR25829 THE UNIVERSAL JDBC DRIVER RETURNS SOME JAPANESE CHARACTERS AS GARBAGE WHEN IT CONNECTS TO A DATABASE WITH CCSID 1390.
IY91122 NUMBERFORMATEXCEPTION IN JCC JDBC DRIVER WHEN INVALID DEFAULT LOCALE IS DETECTED.
IY91477 IF YOU USE DB2 UDB VERSION 8 FIXPAK 13 JCC TYPE 4 DRIVER V8 FIXPAK 13 JCC TYPE 4 DRIVER CAN NOT EXECUTEQUERY() TO V7
JR25575 JDBC UNIVERSAL DRIVER: COM.IBM.DB2.JCC.B.SQLEXCEPTION: REQUIRED PROPERTY "SERVERNAME" IS UNKNOWN HOST WHEN USING CLIENT REROUTE.
JR25457 INCLUDE A JCC PROPERTY CONNECTNODE TO SPECIFY WHICH NODE TO CONNECT TO ON THE SERVER
IY97953 STREAMBUFFERSIZE SHOULD APPLY FOR LOB LOCATORS AS WELL AS PROGRESSIVE STREAMING.
IY95565 JCC DRIVER NOT ALLOWING MERGE STATEMENTS AS BATCHEABLE STATEMENTTYPE
IY92364 JCC JDBC DRIVER DOES NOT CONVERT THE EURO CHARACTER CORRECTLY WHEN READING FROM THE DB2 V8 EURO ENABLED 850 CODEPAGE

DB2 JDBC Version 9.1 Fix Pack 2
APAR No. Abstract
IY91477 IF YOU USE DB2 UDB VERSION 8 FIXPAK 13 JCC TYPE 4 DRIVER V8 FIXPAK 13 JCC TYPE 4 DRIVER CAN NOT EXECUTEQUERY() TO V7
IY89431 JCC TYPE 4 DRIVER IS RETURNING ONLY THE FIRST 10 XID OF IN-DOUBTTRANSACTIONS WHEN INVOKES VIA XARESOURCE.RECOVER(TMSTARTRSCAN)
IY93349 ADDING NEW PROPERTY RETURNALIAS FOR THE UNIVERSAL JDBC DRIVER
IY88878 WEBSPHERE MQ RECEIVES AMQ7605, TM051000, XAER_PROTO ON TWO PHASECOMMIT WITH JCC TYPE 4 DRIVER
IY91122 NUMBERFORMATEXCEPTION IN JCC JDBC DRIVER WHEN INVALID DEFAULT LOCALE IS DETECTED.
LI71431 XA METHOD END(TMSUCCESS) IN UNIVERSAL JDBC DRIVER TYPE 4 FAILS WITH XAER_PROTO WHEN CALLED ON A SUSPENDED ASSOCIATION
JR24973 ERROR "EXCEPTIONININITIALIZERERROR" WHEN USING JCC DRIVER WITHIN AN APPLET
JR25607 JCC: ALLOW COMMIT AND ROLLBACK IN AUTOCOMMIT MODE
IY93728 DB2 V9 LUW FP2 INCLUDES IBM DB2 DRIVER FOR JDBC AND SQLJ VERSION 3.3.54

DB2 JDBC Version 9.1 Fix Pack 1
APAR No. Abstract
LI71403 AN ARRAYINDEXOUTOFBOUNDSEXCEPTION OCCURS DURING A LARGE INSERT USING THE JCC DRIVER
IY96921 WAS5.1 WITH HADR.
IY87304 PERFORMANCE IMPROVEMENT OF JCC APPLICATION WHEN USING EXECUTEQUERY AGAINST DB2/390 (ADDS SETREADONLY ()).
LI71295 JCC DRIVER CONSIDERS THE VALUE OF THE PROPERTY "RETRY INTERVALFORCLIENTREROUTE" TO BE IN MILLISECONDS INSTEAD OF SECONDS
LI71272 UNIVERSAL TYPE 4 XA TRANSACTION FAILS WITH XAER_PROTOOR XAER_OUTSIDE IF STATEMENT CACHED

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - JCC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1","Edition":"Enterprise Server;Express;Personal;Personal Developer's;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPDU","label":"Db2 Connect"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 June 2018

UID

swg21414941