IT32248: ERROR IN EXECUTION OF CERTAIN XML QUERIES FOLLOWING EARLIER FAILURE OF JAR FILE INSTALLATION FOR JAVA UDR

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