Question & Answer
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: Starting with APAR PH17211, the IBM Data Server Driver for JDBC and SQLJ that is based on the JDBC 3 specification is no longer supported. You need to upgrade to the driver that is based on the JDBC 4 specification. See Upgrading from the IBM Data Server Driver for JDBC and SQLJ with JDBC 3.0 support to the IBM Data Server Driver for JDBC and SQLJ with JDBC 4.0 support for more information.
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 13 for z/OS APAR that delivers each version.
| IBM Data Server Driver for JDBC and SQLJ version | Db2 13 for z/OS APAR/PTF |
| 4.32.49 | PH56221/UI93576 |
| 4.32.46 | PH55284/UI92488 |
| 4.32.45 | PH51779/UI92024 |
| 4.31.25 | PH48861/UI83244 |
| 4.31.18 | PH47828/UI81607 |
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.32.49 | PH56221/UI93575 |
| 4.32.46 | PH55284/UI92489 |
| 4.32.45 | PH51779/UI92023 |
| 4.31.25 | PH48861/UI83243 |
| 4.31.18 | PH47828/UI81606 |
| 4.31.15 | PH43423/UI80323 |
| 4.29.27 | PH40658/UI77245 |
| 4.28.11 | PH32181/UI72953 |
| 4.27.26 | PH28350/UI71213 |
| 4.26.18 | PH22490/UI68263 |
| 4.26.16 | PH17211/UI65729 |
| 4.25.21 | PH14604/UI64434 |
| 4.25.17 | PH09452/UI61809 |
| 4.25.14 | PH05977/UI60494 |
| 4.24.95 | PI98598/UI59279 |
| 4.23.50 | PI92195/UI55687 |
| 4.22.37 | PI76338/UI47392 |
| 4.21.40 | PI67610/UI44315 |
| 4.19.66 | PI59547/UI39908 |
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.32.46 | PH55284/UI92490 |
| 4.32.45 | PH51779/UI91976 |
| 4.31.25 | PH48861/UI83242 |
| 4.31.18 | PH47828/UI81605 |
| 4.31.15 | PH43423/UI80322 |
| 4.29.27 | PH40658/UI77244 |
| 4.28.11 | PH32181/UI72952 |
| 4.27.26 | PH28350/UI71212 |
| 4.26.18 | PH22490/UI68262 |
| 4.26.16 | PH17211/UI67528 |
| 4.25.21 | PH14604/UI64433 |
| 4.25.17 | PH09452/UI61808 |
| 4.25.14 | PH05977/UI60493 |
| 4.24.95 | PI98598/UI59278 |
| 4.23.50 | PI92195/UI55686 |
| 4.22.37 | PI76338/UI47391 |
| 4.21.40 | PI67610/UI44314 |
| 4.19.66 | PI59547/UI39907 |
| 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.28.11 | PH32181/UI72951 |
| 4.27.26 | PH28350/UI71211 |
| 4.26.18 | PH22490/UI68261 |
| 4.26.16 | PH17211/UI65727 |
| 4.25.21 | PH14604/UI64432 |
| 4.25.17 | PH09452/UI61807 |
| 4.25.14 | PH05977/UI60492 |
| 4.24.95 | PI98598/UI59277 |
| 4.23.50 | PI92195/UI55685 |
| 4.22.37 | PI76338/UI47390 |
| 4.21.40 | PI67610/UI44313 |
| 4.19.66 | PI59547/UI39906 |
| 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.23.50 | PI92195/UI55688 |
| 4.22.37 | PI76338/UI47393 |
| 4.21.40 | PI67610/UI44316 |
| 4.19.66 | PI59547/UI39909 |
| 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.72.54 | PH05988/UI60497 |
| 3.72.53 | PI98662/UI59282 |
| 3.72.45 | PI92198/UI55692 |
| 3.72.30 | PI76340/UI47363 |
| 3.71.32 | PI67609/UI44298 |
| 3.69.66 | PI59538/UI39912 |
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.72.54 | PH05988/UI60496 |
| 3.72.53 | PI98662/UI59281 |
| 3.72.45 | PI92198/UI55691 |
| 3.72.30 | PI76340/UI47362 |
| 3.71.32 | PI67609/UI44297 |
| 3.69.66 | PI59538/UI39911 |
| 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.72.54 | PI05988/UI60495 |
| 3.72.53 | PI98662/UI59280 |
| 3.72.45 | PI92198/UI55690 |
| 3.72.30 | PI76340/UI47361 |
| 3.71.32 | PI67609/UI44296 |
| 3.69.66 | PI59538/UI39910 |
| 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.72.45 | PI92198/UI55694 |
| 3.72.30 | PI76340/UI47365 |
| 3.71.32 | PI67609/UI44300 |
| 3.69.66 | PI59538/UI39914 |
| 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.72.30 | PI76340/UI47364 |
| 3.71.32 | PI67609/UI44299 |
| 3.69.66 | PI59538/UI39913 |
| 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
Was this topic helpful?
Document Information
Modified date:
21 September 2023
UID
swg21428742