DB2 10.5 for Linux, UNIX, and Windows

Java software support for DB2 database products

You require the appropriate level of IBM® Software Development Kit (SDK) for Java™ to use Java-based tools and to create and run Java applications, including stored procedures and user-defined functions.
Important: For the most up-to-date installation requirements for DB2® database products, you must start using the System requirements for IBM DB2 for Linux, UNIX, and Windows and System requirements for IBM DB2 Connect™ techdocs. These techdocs use IBM Software Product Compatibility Reports (SPCR). With the SPCR tool, you can locate and find complete lists of supported operating systems, system requirements, prerequisites, and optional supported software for DB2 database products. This DB2 Information Centre topic might be removed in a future release or fix pack.

If the IBM SDK for Java is required by a component being installed and the SDK for Java is not already installed in that path, the SDK for Java will be installed if you use either the DB2 Setup wizard or a response file to install the product.

The SDK for Java is not installed with IBM Data Server Runtime Client or IBM Data Server Driver Package.

The following table lists the installed SDK for Java levels for DB2 database products according to operating system platform:
Operating System Platform SDK for Java level
AIX® SDK 7
HP-UX for Itanium-based systems SDK 7
Linux on x86 SDK 7
Linux on AMD64/EM64T SDK 7
Linux on zSeries SDK 7
Linux on POWER® SDK 7
Sun SPARC x64 SDK 7
Sun Solaris x64 SDK 7
Windows x86 SDK 7
Windows x64 SDK 7
Note:
  1. The SDK for Java software can be downloaded from the developerWorks® Web page at: http://www.ibm.com/developerworks/java/jdk/index.html . For a list of the supported levels of the SDK for Java, see the table later in this section entitled DB2 for Linux, UNIX, and Windows support for SDKs for Java.
    Note: For Windows operating system platforms, use the IBM Development Package for Eclipse downloads.
  2. DB2 GUI tools only run on Linux on x86, Linux on AMD64/EM64T, Windows x86, and Windows x64.
  3. On Windows x86 and Linux on x86:
    • the 32-bit SDK is installed
    • 32-bit applications and Java external routines are supported
  4. On all supported platforms (except Windows x86, and Linux on x86):
    • 32-bit applications are supported
    • 32-bit Java external routines are not supported
    • 64-bit applications and Java external routines are supported

Supported Java application development software

The following table lists the supported levels of the SDK for Java. The listed levels and forward-compatible later versions of the same levels are supported.

Because there are frequent SDK for Java fixes and updates, not all levels and versions have been tested. If your database application has problems that are related to the SDK for Java, try the next available version of your SDK for Java at the given level.

Versions of SDK for Java, other than IBM SDK, are supported only for building and running stand-alone Java applications. For building and running new Java stored procedures and user-defined functions, only the IBM SDK for Java that is included with the DB2 for Linux, UNIX, and Windows product is supported. For running Java stored procedures and user-defined functions that were built by prior DB2 releases, refer to Table 1, column "Java Stored Procedures and User Defined Functions" for details.

Table 1. DB2 for Linux, UNIX, and Windows supported levels of SDKs for Java
  Java applications that use JDBC 3.0 or earlier Java applications that use JDBC 4.0 or earlier and JDBC 3.0 or earlier7 Java Stored Procedures and User Defined Functions DB2 Graphical Tools
AIX 1.4.2 to 7 6 and 7 1.4.26 to 7 5 N/A
HP-UX for Itanium-based systems 1.4.2 to 71 6 and 71 1.4.26 to 7 N/A
Linux on POWER 1.4.2 to 73,4 6 and 73,4 1.4.26 to 7 N/A
Linux on x86 1.4.2 to 72,3,4 6 and 72,3,4 1.4.26 to 7 5 to 7
Linux on AMD64 and Intel EM64T processors 1.4.2 to 72,3,4 6 and 72,3,4 1.4.26 to 7 N/A
Linux on zSeries 1.4.2 to 73,4 6 and 73,4 1.4.26 to 7 N/A
Sun SPARC 64 1.4.2 to 72 6 and 72 1.4.26 to 7 N/A
Solaris x64 1.4.2 to 72 6 and 72 1.4.26 to 7 N/A
Windows on x86 1.4.2 to 72 6 and 72 1.4.26 to 7 5 to 7
Windows on x64, for AMD64 and Intel EM64T processors 1.4.2 to 72 6 and 72 1.4.26 to 7 5 to 7
Note:
  1. The same levels of the SDK for Java that are available from Hewlett-Packard are supported for building and running stand-alone client applications that run under the IBM Data Server Driver for JDBC and SQLJ.
  2. The same levels of the SDK for Java that are available from Oracle are supported for building and running stand-alone applications with the IBM Data Server Driver for JDBC and SQLJ. However, if you set the IBM Data Server Driver for JDBC and SQLJ property securityMechanism for a type of security that uses encryption, the SDK for Java must support the type of encryption that you use. For example, the SDK for Java that you use might support 256-bit AES (strong) encryption, but not 56-bit DES (weak) encryption. You can specify the encryption algorithm by setting the IBM Data Server Driver for JDBC and SQLJ property encryptionAlgorithm. To use 256-bit AES encryption, set encryptionAlgorithm to 2. When you use 256-bit AES encryption with the SDK for Java from Oracle, you might need to install the JCE Unlimited Strength Jurisdiction Policy File, which is available from Oracle.
  3. A minimum level of SDK for Java 1.4.2 SR6 is required for SUSE Linux Enterprise Server (SLES) 10. A minimum level of SDK for Java 1.4.2 SR7 is required for Red Hat Enterprise Linux (RHEL) 5.
  4. SDK for Java 6 support on Linux requires SDK for Java 6 SR3 or later.
  5. If SDK for Java 6 SR2 or later is used, set DB2LIBPATH=java_home/jre/lib/ppc64.
  6. Support for Java stored procedures and user-defined functions built by IBM SDK for Java 1.4.2 was deprecated in Version 9.7 and might be removed in a future release. IBM SDK for Java 1.4.2 has an End of Service date of September 2011. It is recommended to remove SDK for Java 1.4.2 dependency well before this date. Removing this dependency can be done by rebuilding Java stored procedures and user-defined functions with the SDK for Java included in DB2 Version 9.1, DB2 Version 9.5, DB2 Version 9.7 or DB2 V10.1 .
  7. Java 6 is sufficient if you need to use JDBC 4.0 functions only. Java 7 is required if you need to use JDBC 4.1 functions.
Related reference:
DB2 for Linux, UNIX, and Windows and IBM Data Server Driver for JDBC and SQL levels
Data types that map to database data types in Java applications