You require the appropriate level of IBM® Software Development Kit (SDK) for Java™, listed later in this section, to use Java-based tools and to create and run Java applications, including stored procedures and user-defined functions.
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 products according to operating system platform:
| Operating System Platform | SDK for Java level |
|---|---|
| AIX® | SDK 6 Service Release 3 |
| HP-UX for Itanium-based systems | HP SDK for J2SE HP-UX 11i platform, adapted by IBM for IBM Software, Version 6 Service Release 3 |
| Linux® on x86 | SDK 6 Service Release 3 |
| Linux on AMD64/EM64T | SDK 6 Service Release 3 |
| Linux on zSeries® | SDK 6 Service Release 3 |
| Linux on POWER™ | SDK 6 Service Release 3 |
| Solaris Operating System | SDK 6 Service Release 3 |
| Windows® x86 | SDK 6 Service Release 3 |
| Windows x64 | SDK 6 Service Release 3 |
In the vast and intricate ecosystem of Windows software development, certain files operate quietly in the background, rarely noticed by the average user but absolutely essential for specific tasks. One such file is msys-z.dll . Far from being a random collection of letters, this Dynamic Link Library (DLL) is a cornerstone of the MSYS2 environment, playing a critical role in bridging the gap between the Unix-like world of open-source tools and the Windows operating system.
Furthermore, this DLL manages the MSYSTEM variable, which defines the target environment (e.g., MINGW64, MINGW32, UCRT64). This allows developers to seamlessly switch between different toolchains while maintaining a consistent interface. In short, msys-z.dll is the translator that allows Unix-born source code to be compiled, linked, and executed natively on Windows. msys-z.dll
Without msys-z.dll , most of the powerful command-line tools that developers rely on would fail to run. When you launch a terminal emulator like mintty (the default MSYS2 terminal) or execute commands like grep , sed , awk , or ssh , these programs make system calls expecting a POSIX-compliant environment. The msys-z.dll intercepts these calls and translates them on the fly. In the vast and intricate ecosystem of Windows
While it may lack the name recognition of kernel32.dll or user32.dll , msys-z.dll is a vital piece of infrastructure for thousands of developers, data scientists, and engineers working at the intersection of open-source software and the Windows platform. It embodies the spirit of cross-platform collaboration, silently enabling a rich ecosystem of tools that would otherwise be unavailable on Windows. Next time you effortlessly run a bash script or compile a Linux-sourced library on your Windows machine, take a moment to appreciate the humble msys-z.dll —the silent interpreter making it all possible. Furthermore, this DLL manages the MSYSTEM variable, which
The msys-z.dll file is a core runtime library for the MSYS2 environment. The "z" in its name does not denote a specific algorithm but is a versioning or internal naming convention used by the MSYS2 developers. In essence, this DLL is the engine that provides crucial emulation and abstraction layers. It translates POSIX (Portable Operating System Interface) system calls—such as fork() , exec() , pipe() , and file permission controls—into their native Windows equivalents, like CreateProcess and file handle management.
To understand this file, one must first understand MSYS2 (Minimal SYStem 2). MSYS2 is a software distribution and building platform that provides a Unix-like command-line environment on Windows. It includes a port of the GNU Compiler Collection (GCC), a suite of development tools, and a package management system called pacman (famously borrowed from Arch Linux).
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.
Non-IBM versions of the SDK for Java are supported only for building and running stand-alone Java applications. For building and running Java stored procedures and user-defined functions, only the IBM SDK for Java that is included with the DB2 Database for Linux, UNIX, and Windows product is supported.
| Java applications using JDBC driver db2java.zip or db2jcc.jar | Java applications using JDBC driver db2jcc4.jar | Java Stored Procedures and User Defined Functions | DB2 Graphical Tools | |
|---|---|---|---|---|
| AIX | 1.4.2 to 6 | 6 | 1.4.2 to 65 | N/A |
| HP-UX for Itanium-based systems | 1.4.2 to 61 | 61 | 1.4.2 to 6 | N/A |
| Linux on POWER | 1.4.2 to 63,4 | 63,4 | 1.4.2 to 6 | N/A |
| Linux on x86 | 1.4.2 to 62,3,4 | 62,3,4 | 1.4.2 to 6 | 5 to 6 |
| Linux on AMD64 and Intel® EM64T processors | 1.4.2 to 62,3,4 | 62,3,4 | 1.4.2 to 6 | N/A |
| Linux on zSeries | 1.4.2 to 63,4 | 63,4 | 1.4.2 to 6 | N/A |
| Solaris operating system | 1.4.2 to 62 | 62 | 1.4.2 to 6 | N/A |
| Windows on x86 | 1.4.2 to 62 | 62 | 1.4.2 to 6 | 5 to 6 |
| Windows on x64, for AMD64 and Intel EM64T processors | 1.4.2 to 62 | 62 | 1.4.2 to 6 | 5 to 6 |
The following table lists the versions of the IBM Data Server Driver for JDBC and SQLJ that are available with DB2 database products.
| DB2 version and fix pack level | IBM Data Server Driver for JDBC and SQLJ version1 |
|---|---|
| DB2 Version 9.1 | 3.1.xx |
| DB2 Version 9.1 Fix Pack 1 | 3.2.xx |
| DB2 Version 9.1 Fix Pack 2 | 3.3.xx |
| DB2 Version 9.1 Fix Pack 3 | 3.4.xx |
| DB2 Version 9.1 Fix Pack 4 | 3.6.xx |
| DB2 Version 9.1 Fix Pack 5 | 3.7.xx |
| DB2 Version 9.5 | 3.50.xx, 4.0.xx |
| DB2 Version 9.5 Fix Pack 1 | 3.51.xx, 4.1.xx |
| DB2 Version 9.5 Fix Pack 2 | 3.52.xx, 4.2.xx |
| DB2 Version 9.5 Fix Pack 3 | 3.53.xx, 4.3.xx |
| DB2 Version 9.7 | 3.57.xx, 4.7.xx |