Skip to main content

Software  >  Information Management  >  DB2 Product Family  >  

Supported Java SDK and Java Runtime Environment levels for DB2 UDB Version 8 platforms

 Technote (FAQ)
 
Question
What are the supported Java SDK and Java Runtime Environment levels for DB2 UDB Version 8?
 
Cause
You require the appropriate level of Software Development Kit (SDK) for Java to use Java-based tools like the DB2 Control Center, and to create and run Java applications, including stored procedures and user-defined functions.
 
Answer
The following table lists the supported Java™ SDK and Java™ Runtime Environment levels for DB2® Universal Database™ (DB2 UDB) Version 8 platforms. Only listed levels and forward compatible later versions of the same level are supported. For example, if level 1.3.1 is listed, then levels 1.3.* are supported. Level 1.4.* is considered a new level and is not supported. Because there are frequent Java SDK fixes and updates, IBM® does not test every level. If your database application has Java SDK-related problems, try the next available service release (SR) of your Java SDK level.
DB2 UDB for Linux®, UNIX®, and Windows® clients and servers include either an IBM Java SDK or a non-IBM Java SDK. If an IBM SDK for Java is required and it is not already installed, it can be installed using the DB2 Setup wizard or a response file. Note: The DB2 Run-Time client does include an SDK for Java install.

For information about installing the DB2 Universal JDBC Driver, refer to "Installing the DB2 Universal JDBC Driver" in the related information at the bottom of this technote.

IBM Java SDKs are supported for building and running client applications, Java stored procedures and user-defined functions. Refer to the charts below for the specific Java SDK and JRE levels that each DB2 UDB Version 8 FixPak supports.

Non-IBM Java SDKs are only supported for building and running client applications on the following platforms (refer to the charts below for details about the Java SDK and JRE levels supported by each FixPak):

  • DB2 UDB for Solaris supports the Java SDK from Sun Microsystems for building and running client applications with the DB2 Universal JDBC Driver.

  • DB2 UDB for Linux supports the Java SDK from Sun Microsystems for building and running client applications with the DB2 Universal JDBC Driver.

  • DB2 UDB for HP-UX supports the Java SDK from HP for building and running client applications with the DB2 Universal JDBC Driver.


Non-IBM Java SDKs are only supported for building and running Java stored procedures and user-defined functions on the following platforms:
  • DB2 UDB for Solaris supports the Java SDK, versions 1.3.1 to 1.4.2 from Sun Microsystems for building and running Java stored procedures and user-defined functions.

  • DB2 UDB for HP-UX supports the Java SDK, versions 1.3.1 to 1.4.2 from HP for building and running Java stored procedures and user-defined functions.

The following charts shows the Java SDK and JRE levels and service releases that each DB2 UDB Version 8 FixPak supports.

Supported Java SDK versions
Operating system
Width of the DB2 UDB instance
Supported Java SDK versions
DB2 UDB Version 8.1
DB2 UDB Version 8.1 FixPak 7 (Version 8.2)
DB2 UDB Version 8.1
FixPaks 8 to 16
(Version 8.2
FixPaks 1 to 9)
AIX® 4.3.3.1032-bit1.3.11.3.1 to 1.3.1 SR61.3.1 to 1.3.1 SR6
AIX 5L™32-bit, 64-bit1.3.11.3.1 to 1.4.1 SR21.3.1 to 1.4.2
HP-UX 11i PA-RISC32-bit1.3.11.3.1 to 1.4.2.01(*1)1.3.1 to 1.4.2.01(*1)
HP-UX 11i PA-RISC, IA6464-bit1.4.01.4.0 to 1.4.2.011.4.0 to 1.4.2.01
Linux on 32-bit x8632-bit1.3.11.3.1 SR4 to 1.4.1 SR2(*2)1.3.1 SR4 to 1.4.2(*2)
Linux on IA6464-bit1.3.11.3.1 to 1.4.21.3.1 to 1.4.2 (*10)
Linux on x86-6432-bitn/a1.3.1 SR4 to 1.4.1 SR2(*2)1.3.1 SR4 to 1.4.2(*2)
Linux on x86-6464-bitn/an/a1.4.2 SR1(*3, *9)
Linux on pSeries®, iSeries™32-bit1.3.11.3.1 to 1.4.1 SR21.3.1 to 1.4.2
Linux on pSeries, iSeries64-bit1.3.11.3.1 to 1.4.1 SR21.4.1 to 1.4.2
Linux on zSeries®31-bit, 64-bit1.3.11.3.1 to 1.4.1 SR2(*2)1.3.1 to 1.4.2(*2)
Solaris SPARC32-bit1.3.11.3.1 to 1.4.21.3.1 to 1.4.2 (*6)
Solaris SPARC64-bit1.4.01.4.0 to 1.4.21.4.0 to 1.4.2 (*6)
Solaris x86-6464-bitn/an/a1.4.2(*7)
Windows on 32-bit x8632-bit1.3.11.3.1 to 1.4.1 SR2a1.3.1 to 1.4.2
Windows on IA6464-bit1.4.0(*4)1.4.0 to 1.4.1 SR21.4.0 to 1.4.2 (*10, *11)
Windows x6464-bitn/an/a1.4.2 SR1a(*5)

Supported Java Runtime Environment versions
Operating system
Width of the DB2 UDB instance
Supported versions of Java Runtime Environment
DB2 UDB Version 8.1
DB2 UDB Version 8.1
FixPak 7 (Version 8.2)
DB2 UDB Version 8.1
FixPaks 8 to 13
(Version 8.2
FixPaks 1 to 6)
DB2 UDB Version 8.1 FixPaks 14, 15 and 16
(Version 8.2 FixPaks 7, 8 and 9)
AIX 4.3.3.1032-bit1.3.11.3.1 to 1.3.1 SR61.3.1 to 1.3.1 SR61.3.1 to 1.3.1 SR6
AIX 5L32-bit, 64-bit1.3.11.3.1 to 1.4.1 SR21.3.1 to 1.4.21.3.1 to 5.0 (*8)
HP-UX 11i PA-RISC32-bit1.3.11.3.1 to 1.4.2.01(*1)1.3.1 to 1.4.2.01(*1)1.3.1 to 5.0 (*1, *8)
HP-UX 11i PA-RISC, IA6464-bit1.4.01.4.0 to 1.4.2.011.4.0 to 1.4.2.011.4.0 to 5.0 (*8)
Linux on 32-bit x8632-bit1.3.11.3.1 SR4 to 1.4.1 SR2(*2)1.3.1 SR4 to 1.4.2(*2)1.3.1 SR4 to 5.0 (*2, *8)
Linux on IA6464-bit1.3.11.3.1 to 1.4.21.3.1 to 1.4.2 (*10)1.3.1 to 5.0 (*8, *10)
Linux on x86-6432-bitn/a1.3.1 SR4 to 1.4.1 SR2(*2)1.3.1 SR4 to 1.4.2(*2)1.3.1 SR4 to 5.0 (*2, *8)
Linux on x86-6464-bitn/an/a1.4.2 SR1(*3, *9)1.4.2 SR1 to 5.0 (*3, *8)
Linux on pSeries, iSeries32-bit1.3.11.3.1 to 1.4.1 SR21.3.1 to 1.4.21.3.1 to 5.0 (*8)
Linux on pSeries, iSeries64-bit1.3.11.3.1 to 1.4.1 SR21.4.1 to 1.4.21.4.1 to 5.0 (*8)
Linux on zSeries31-bit, 64-bit1.3.11.3.1 to 1.4.1 SR2(*2)1.3.1 to 1.4.2(*2)1.3.1 to 5.0 (*2, *8)
Solaris SPARC 32-bit1.3.11.3.1 to 1.4.21.3.1 to 1.4.2 (*6)1.3.1 to 5.0 (*6, *8)
Solaris SPARC64-bit1.4.01.4.0 to 1.4.21.4.0 to 1.4.2 (*6)1.4.0 to 5.0 (*6, *8)
Solaris x86-6464-bitn/an/a1.4.2(*7)1.4.2 to 5.0 (*7, *8)
Windows on 32-bit x8632-bit1.3.11.3.1 to 1.4.1 SR2a1.3.1 to 1.4.21.3.1 to 5.0 (*8)
Windows on IA6464-bit1.4.0(*4)1.4.0 to 1.4.1 SR21.4.0 to 1.4.2 (*10, *11)1.4.0 to 5.0 (*8, *10, *11)
Windows x6464-bitn/an/a1.4.2 SR1a(*5)1.4.2 SR1a to 5.0 (*5, *8)
  • (*1) HP-UX 11i 32-bit supports Java stored procedures and user-defined functions with JDK 1.3.1 only.

  • (*2) JDK 1.4.1 may not be supported on all distributions of Linux that are supported by DB2 UDB. Refer to this web site for JDK support on specific distributions: http://www.ibm.com/developerworks/java/jdk/linux/tested.html

  • (*3) DB2 UDB Java-based graphical tools (for instance, the Control Center or the Development Center) are not supported on 64-bit instances of DB2 UDB for Linux on x86-64.

  • (*4) Java support for DB2 UDB for Windows on IA64 was introduced in FixPak 2.

  • (*5) Java support for DB2 UDB for Windows x64 was introduced in FixPak 9.

  • (*6) DB2 support for Solaris 10 SPARC was introduced in FixPak 9.

  • (*7) Java support for DB2 UDB for Solaris 10 x86-64 was introduced in DB2 UDB Version 8.1 FixPak 11. JDK 1.4.2 is for installation only purpose. Otherwise, Solaris 10 x86-64 supports JDK 5.0.

  • (*8) JRE 5.0 support is added in FixPak 14 with the use of the DB2 Universal JDBC type 4 driver for client applications only. Java stored procedures and user-defined functions and DB2 UDB Java-based graphical tools (for instance, the Control Center or the Development Center) do not support JRE 5.0.
    Neither the deprecated DB2 JDBC Type 2 Driver for Linux, UNIX and Windows nor the deprecated DB2 JDBC Type 3 Driver for Linux, UNIX and Windows provide JRE 5.0 support.

  • (*9) Starting with FixPak 9, JDBC and SQLJ support is available for 64-bit instances of DB2 UDB for Linux on x86-64 that use the DB2 Universal JDBC type 4 driver. The same support is available using the DB2 Universal JDBC Type 2 driver starting with FixPak 10.

  • (*10) JDK 1.4.2 SR3 or later is required on systems with dual-core Itanium processors.

  • (*11) Windows 2003 SP2 is required on systems with dual-core Itanium processors. Refer to DB2 UDB V8 installation prerequisites for Microsoft Windows operating system.


DB2 Universal JDBC Driver versions

DB2 UDB for Linux,
UNIX, and Windows version

DB2 Universal JDBC Driver version

Version 8.1
1.0.581

Version 8.1, FixPak 1
1.1.67

Version 8.1, FixPak 2
1.2.117

Version 8.1, FixPak 3
1.3.70

Version 8.1, FixPak 4a
1.5.54

Version 8.1, FixPak 5
1.9.23

Version 8.1, FixPak 6
2.2.49

Version 8.1, FixPak 7 (Version 8.2)
2.3.63

Version 8.1, FixPak 8 (Version 8.2, FixPak 1)
2.5.33

Version 8.1, FixPak 9 (Version 8.2, FixPak 2)
2.6.80

Version 8.1, FixPak 10 (Version 8.2, FixPak 3)
2.7.58

Version 8.1, FixPak 11 (Version 8.2, FixPak 4)
2.8.46

Version 8.1, FixPak 12 (Version 8.2, FixPak 5)
2.9.31

Version 8.1, FixPak 13 (Version 8.2, FixPak 6)
2.10.27

Version 8.1, FixPak 14 (Version 8.2, FixPak 7)
2.10.52

Version 8.1, FixPak 15 (Version 8.2, FixPak 8)
2.10.72

Version 8.1, FixPak 16 (Version 8.2, FixPak 9)
2.11

Version 8.1, FixPak 17 (Version 8.2, FixPak 10)
2.11.65

NOTE:

  • The DB2 Universal JDBC driver archive is db2jcc.jar.

  • In DB2 UDB 8.2, the default JDBC driver for Java stored procedures is the DB2 JDBC Type 2 Driver for Linux, UNIX and Windows. If you want to make the DB2 Universal JDBC Driver the default JDBC driver for Java stored procedures, issue the following db2set command:
    db2set DB2_USE_DB2JCCT2_JROUTINE=on -g
  • As of DB2 UDB Version 8.1 FixPak 3, you can also use the DB2Jcc utility (specifically the "-version" command option) to determine the version of the IBM Universal JDBC Driver. Refer to Identifying the version and service level of your product
 
Related information
Java Database Connectivity (JDBC)
Setting up the Windows Java environment
Setting up the UNIX Java environment
Installing the DB2 Universal JDBC Driver
Supported Java software for DB2 Version 9
Determining the DB2 Driver for JDBC and SQLJ version
Properties for the DB2 Universal JDBC Driver
 
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Data Management
 Data Servers (Database Management Systems)
 DB2 for Linux, UNIX and Windows
 Application Programming - Languages/Compilers
 Operating system(s):
  AIX, HP-UX, Linux, Solaris, Windows
 Software version:
  8
 Software edition:
  Enterprise, Express, Personal, Workgroup
 Reference #:
  1251460
 IBM Group:
 Software Group
 Modified date:
 2009-03-29

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.