IBM Support

IBM® Data Server Driver for JDBC and SQLJ versions and DB2® for z/OS® APARs

Technote (FAQ)


Question

How do you determine which DB2 for z/OS APARs deliver a certain IBM Data Server Driver for JDBC and SQLJ version?

Cause

IBM Data Server Driver for JDBC and SQLJ versions are delivered through DB2 for z/OS APARs. You need to know the APAR numbers to determine which functions are provided in each version of the driver.

Answer

The following tables list the IBM Data Server Driver for JDBC and SQLJ versions, and the DB2 for z/OS Version APARs and PTFs that deliver those versions.

You can use the DB2Jcc utility with the -version or -configuration parameter to determine version and environment information for the driver that you are using. When you specify the -version parameter, the DB2Jcc utility returns the driver name and version. When you specify the -configuration parameter, the DB2Jcc utility returns the driver name, Java runtime environment, operating system, path information, and license restrictions.

The syntax is:
>>-java--com.ibm.db2.jcc.DB2Jcc--+-----------+-->
                                 '- -version-'   

>--+-----------------+--+--------+-------------><
   '- -configuration-'  '- -help-'  


Important: Each version of the the IBM Data Server Driver for JDBC and SQLJ is shipped with a driver that is based on the JDBC 3 specification, and a driver that is based on the JDBC 4 or later specifications. After version 3.72, the driver that is based on the JDBC 3 specification is deprecated. No enhancements will be made to this driver. However, fixes will continue to be delivered.

4.xx drivers and DB2 for z/OS APARs

The following table lists the 4.xx versions of the IBM Data Server Driver for JDBC and SQLJ and the DB2 12 for z/OS APAR that delivers each version.

IBM Data Server Driver for JDBC and SQLJ version DB2 12 for z/OS APAR/PTF
4.21.40 PI67610/UI44315


The following table lists the 4. xx versions of the IBM Data Server Driver for JDBC and SQLJ and the DB2 11 for z/OS APAR that delivers each version.
IBM Data Server Driver for JDBC and SQLJ version DB2 11 for z/OS APAR/PTF
4.21.40 PI67610/UI44314
4.19.56 PI47282/UI35891
4.18.74 PI34907/UI29934
4.17.55 PI34903/UI26209
4.15.105 PM96295/UI12420

The following table lists the 4. xx versions of the IBM Data Server Driver for JDBC and SQLJ and the DB2 10 for z/OS APAR that delivers each version.
IBM Data Server Driver for JDBC and SQLJ version DB2 10 for z/OS APAR/PTF
4.21.40 PI67610/UI44313
4.19.56 PI47282/UI35890
4.18.74 PI34907/UI29933
4.17.55 PI34903/UI26208
4.15.105 PM96295/UI12415
4.15.99 PM89898/UK96847
4.15.94 PM84363/UK94639
4.14.126 PM77185/UK92325
4.14.119 PM65003/UK83409
4.13.145 PM65004/UK82475
4.13.136 PM58952/UK78529
4.13.110 PM47801/UK76380
4.12.93 PM47800/UK74721
4.12.72 PM36838/UK69741
4.12.57 PM32361/UK66666
4.11.98 PM26575/UK64550
4.11.86 PM25193/UK62145
4.11.82 GA

The following table lists the 4. xx versions of the IBM Data Server Driver for JDBC and SQLJ and the
DB2 Version 9.1 for z/OS APAR that delivers each version.
IBM Data Server Driver for JDBC and SQLJ version DB2 Version 9.1 for z/OS APAR/PTF
4.21.40 PI67610/UI44316
4.19.56 PI47282/UI35892
4.18.74 PI34907/UI29935
4.17.55 PI34903/UI26210
4.15.105 PM96295/UI12421
4.15.99 PM89898/UK96849
4.15.94 PM84363/UK94641
4.14.126 PM77185/UK92326
4.14.119 PM65003/UK83410
4.13.145 PM65004/UK82476
4.13.136 PM58952/UK78530
4.13.110 PM47801/UK76381
4.12.93 PM47800/UK74722
4.12.72 PM36838/UK69742
4.12.57 PM32361/UK66665
4.11.98 PM26575/UK64551
4.11.86 PM25195/UK62191
4.9.105 PM17419/UK61846
4.9.80 PM15293/UK57688
4.8.129 PM09694/UK57679
4.8.108 PM03787/UK54837
4.8.95 PM02862/UK52963
4.7.94 PK87569/UK48782
4.3.120 PK85361/UK47113
4.3.108 PK75093/UK43777

3.xx drivers and DB2 for z/OS APARs

The following table lists the 3. xx versions of the IBM Data Server Driver for JDBC and SQLJ and the DB2 12 for z/OS APAR that delivers each version.

IBM Data Server Driver for JDBC and SQLJ version DB2 12 for z/OS APAR/PTF
3.71.32 PI67609/UI44298


The following table lists the 3. xx versions of the IBM Data Server Driver for JDBC and SQLJ and the DB2 11 for z/OS APAR that delivers each version.

IBM Data Server Driver for JDBC and SQLJ version DB2 11 for z/OS APAR/PTF
3.71.32 PI67609/UI44297
3.69.56 PI47281/UI35887
3.68.76 PI34906/UI29929
3.67.49 PI34901/UI26202
3.65.102 PM96293/UI12401



The following table lists the 3. xx versions of the IBM Data Server Driver for JDBC and SQLJ and the DB2 10 for z/OS APAR that delivers each version.

IBM Data Server Driver for JDBC and SQLJ version DB2 10 for z/OS APAR/PTF
3.71.32 PI67609/UI44296
3.69.56 PI47281/UI35886
3.68.76 PI34906/UI29928
3.67.49 PI34901/UI26201
3.65.102 PM96293/UI12400
3.65.96 PM89897/UK96839
3.65.92 PM84359/UK94635
3.64.119 PM77184/UK92320
3.64.111 PM65007/UK83411
3.63.141 PM65005/UK82465
3.63.131 PM58951/UK78526
3.63.107 PM47803/UK76374
3.62.95 PM47802/UK74718
3.62.73 PM36832/UK69732
3.62.57 PM32360/UK66662
3.61.96 PM26574/UK64541
3.61.84 PM25192/UK62141
3.61.80 GA

The following table lists the 3. xx versions of the IBM Data Server Driver for JDBC and SQLJ and the DB2 Version 9.1 for z/OS APAR that delivers each version.

IBM Data Server Driver for JDBC and SQLJ version DB2 Version 9.1 for z/OS APAR/PTF
3.71.32 PI67609/UI44300
3.69.56 PI47281/UI35889
3.68.76 PI34906/UI29931
3.67.49 PI34901/UI26204
3.65.102 PM96293/UI12403
3.65.96 PM89897/UK96842
3.65.92 PM84359/UK94638
3.64.119 PM77184/UK92322
3.64.111 PM65007/UK83413
3.63.141 PM65005/UK82467
3.63.131 PM58951/UK78528
3.63.107 PM47803/UK76376
3.62.95 PM47802/UK74720
3.62.73 PM36832/UK69734
3.62.57 PM32360/UK66664
3.61.96 PM26574/UK64543
3.61.84 PM25194/UK62189
3.59.108 PM17416/UK61842
3.59.83 PM15292/UK57685
3.58.127 PM09693/UK57672
3.58.104 PM03785/UK54799
3.58.90 PK93123/UK52962
3.57.91 PK87567/UK48236
3.53.104 PK77599/UK47085
3.53.81 PK71020/UK42554
3.52.112 PK71010/UK42371
3.52.99 PK65069/UK39205
3.51.126 PK68428/UK38507
3.6.93 PK58105/UK38018
3.6.67 PK49868/UK32181
3.4.77 PK46324/UK29044
3.3.85 PK41173/UK28583
3.3.63 PK36170/UK22777


The following table lists the 3. xx versions of the IBM Data Server Driver for JDBC and SQLJ and the DB2 for z/OS Version 8 APAR that delivers each version.

IBM Data Server Driver for JDBC and SQLJ version DB2 for z/OS Version 8 APAR/PTF
3.71.32 PI67609/UI44299
3.69.56 PI47281/UI35888
3.68.76 PI34906/UI29930
3.67.49 PI34901/UI26203
3.65.102 PM96293/UI12402
3.65.96 PM89897/UK96841
3.65.92 PM84359/UK94637
3.64.119 PM77184/UK92321
3.64.111 PM65007/UK83412
3.63.141 PM65005/UK82466
3.63.131 PM58951/UK78527
3.63.107 PM47803/UK76375
3.62.95 PM47802/UK74719
3.62.73 PM36832/UK69733
3.62.57 PM32360/UK66663
3.61.96 PM26574/UK64542
3.58.104 PM03785/UK54798
3.58.90 PK93123/UK52961
3.57.91 PK87567/UK48235
3.53.104 PK77599/UK47084
3.53.81 PK71020/UK42553
3.52.112 PK71010/UK42370
3.52.99 PK65069/UK39204

The following table lists the 2. xx versions of the IBM Data Server Driver for JDBC and SQLJ and the DB2 for z/OS Version 8 APAR that delivers each version.

IBM Data Server Driver for JDBC and SQLJ version DB2 for z/OS Version 8 APAR/PTF
2.11.119 PM32366/UK75814
2.11.113 PK94785/UK64540
2.11.95 PK71159/UK49574
2.11.67 PK64228/UK39699
2.11.44 PK54969/UK35430
2.10.122 PK54969/UK35430
2.10.113 PK44367/UK31362
2.10.84 PK36169/UK24663
2.10.59 PK33368/UK20656
2.10.40 PK25139/UK18528
2.9.39 PK27031/UK16446
2.9.32 PK19585/UK14852
2.8.59 PK22376/UK14598

For a list of DB2 for Linux, UNIX, and Windows fix packs that correspond to IBM Data Server Driver for JDBC and SQLJ versions, see the information at this URL:
http://www.ibm.com/support/docview.wss?uid=swg21363866


Cross reference information
Segment Product Component Platform Version Edition
Information Management DB2 for z/OS Value Unit Edition z/OS

Document information

More support for: DB2 for z/OS
SQLJ/JDBC

Software version: 8.0, 9.1, 10.0, 11.0, 12.0

Operating system(s): z/OS

Software edition: All Editions

Reference #: 1428742

Modified date: 29 May 2015


Translate this page: