IBM Support

Unsupported encoding Cp037 when using DB2© Universal JDBC Driver to connect to DB2 UDB for z/OS©



This document provides troubleshooting information for the scenario where you are using the DB2 Universal JDBC Type 4 Driver (db2jcc.jar) to make a connection to a DB2 UDB for z/OS database and receive the following error: Unsupported encoding Cp037.


This problem can occur if the international version of the JDK and/or JRE are not installed and thus the international version of the carsets.jar is not in use.

The following information appears on a Solaris® "Supported Encodings" website:

"The J2RE installer by default installs a European languages version if it recognizes that the host operating system only supports European languages. If the installer recognizes that any other language is needed, or if the user requests support for non-European languages in a customized installation, a complete international version is installed."

Resolving The Problem

The charsets.jar file comes from the JDK, not from DB2® Universal Database™ (DB2 UDB). In order for your Java™ version to pick up the lib/charsets.jar file, it has to be from the same JDK level.

Most likely the European language version (also known as the Standard Version) was installed on your client instead of the international version.

Determine the version you are using. If it's not the international version, then perform ONE of these steps:

  1. Re-install your current JDK or JRE, and specify during the install that you wish to have the International version, or
  2. Uninstall the Solaris JDK and install the IBM® JDK instead. (IBM's JDK defaults to the international version)

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Programming Interface - JCC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8","Edition":"Enterprise;Personal;Workgroup;Express","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018