IBM Support

Informix bundled JVM (Krakatoa) has outdated TZ info

Technote (troubleshooting)


Due to outdated TZ info in JVM bundled with Informix database server ("Krakatoa" feature) certain operations in Java UDRs may result in incorrect conversion of datetime values.


Conversion of datetime <-> java.sql.Timestamp types produces incorrect values.


Outdated TZ info in JVM supplied with Informix engine (Krakatoa)

Diagnosing the problem

Use IBM Time Zone Update Utility for Java (JTZU) to check the version of TZ info in Krakatoa JRE

JTZU can be downloaded here:
Usage is explained at Readme file referenced on that page.

While executed in discovery mode, it searches for all installed JREs and prints a complete path and TZ info level in SDKList.txt file.

Sample content of SDKList.txt file:
/opt/IBM/11.50.FC9W2/extend/krakatoa/jre tzdata2012d
/opt/IBM/11.50.UC8/extend/krakatoa/jre tzdata2007h
/opt/IBM/11.70.FC1/extend/krakatoa/jre tzdata2009p
/opt/IBM/11.70.FC2/extend/krakatoa/jre tzdata2009p
/opt/IBM/11.70.FC3/extend/krakatoa/jre tzdata2009p
/opt/IBM/11.70.FC4/extend/krakatoa/jre tzdata2009p
/opt/IBM/11.70.FC5/extend/krakatoa/jre tzdata2009p
/opt/IBM/11.70.FC5W1/extend/krakatoa/jre tzdata2009p

By the time this document is created, the latest TZ info is tzdata2012d, which means that in provided sample all JREs except the first entry are outdated.

Resolving the problem

You can use JTZU utility to manually update TZ info within JRE:


2) Edit the SDKList.txt file and remove any entries that you do not want to patch.

3) Run JTZU with the JTZU settings file containing the values (Krakatoa must not be in use):
* NOGUI=true

Related information


Document information

More support for: Informix Servers

Software version: 11.5, 11.7

Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows

Software edition: Developer, Enterprise, Express, Growth, Innovator, Ultimate, Workgroup

Reference #: 1610596

Modified date: 29 December 2012

Translate this page: