APAR status
Closed as program error.
Error description
The fix for APAR IT26222 "executing queries using xml existsnode routine in parallel can assert server" introduces the use of a Java UDR for selected OS platforms, such as AIX, when executing certain XML queries. Upon executing a relevant XML query the Java UDR will automatically be created which requires the installation of a jar file. If there is an error during this process the Java UDR may still be created even though it cannot be executed. Once the problem relating to installation of the jar file is resolved execution of the XML query may still end in failure. Examples of error messages include: 9431: Can't find system class or method or library ($INFORMIXDIR/extend/krakatoa/jre/bin/liblibjava.so.so). and (46103) - Error loading Java UDR class (<xmldb.informix.libxml_jar:libxml> : Class xmldb.informix.libxml_jar:libxml not found in jar xmldb.informix.libxml_jar. Please verify the three part name (dbname.username.jarid) of the installed jar with the jar file name in your JAR_TEMP_PATH or /tmp directory.).
Local fix
These steps should be performed to effect a manual clean-up of the UDR associated with the XML query so that it may then be run successfully: 1. Identify and resolve the problem relating to the failed Jar file installation. For example ensure that any deprecated JVP parameters are removed from the onconfig file. 2. Drop the Java UDR that is automatically created: $ echo 'drop function if exists libxml_xslt_check' | dbaccess <database> - 3. Shut down the database server $ onmode -kuy 4. Remove any jar files from $INFORMIXDIR/tmp that may have been created in relation to the Java UDR: $ rm -f $INFORMIXDIR/tmp/<database>.<user>.libxml_jar.jar where <database> is the name of the database where the XML query was executed and <user> is the username that ran it. 5. Restart the database server and re-run the XML query.
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC4.
Temporary fix
Comments
APAR Information
APAR number
IT32248
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-03-20
Closed date
2020-12-14
Last modified date
2024-09-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 September 2024