Informix bundled JVM (Krakatoa) has outdated TZ info

Technote (troubleshooting)


Problem(Abstract)

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.

Symptom

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


Cause

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: https://www.ibm.com/developerworks/java/jdk/dst/jtzu.html.
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:

1) Run JTZU in DISCOVERYONLY mode

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
* DISCOVERONLY=false


Related information

JTZU

Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Servers

Software version:

11.5, 11.7

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Software edition:

Developer, Enterprise, Express, Growth, Innovator, Ultimate, Workgroup

Reference #:

1610596

Modified date:

2012-12-29

Translate my page

Machine Translation

Content navigation