Troubleshooting
Contains list of shipped APARs for the IBM® Data Server Driver for JDBC and SQLJ Version 9.1. APARs sorted by fix pack.
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"}}]