INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

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
( : 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.).

****************************************************************
* 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.                                                   *
****************************************************************

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
 -
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/..libxml_jar.jar
where  is the name of the database where the XML query
was executed and  is the username that ran it.
5. Restart the database server and re-run the XML query.

****************************************************************
* 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.                                                   *
****************************************************************

Fixed in Informix Server 12.10.xC15 and 14.10.xC4.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.03.2020
14.12.2020
14.12.2020