IT24280: GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSINGCLAUSE MAY RETURN -901

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Db2 may return a -901: "Empty plan list detected!" or
  "sqlno_crule_NLJN          [ 50]:rc(     0)                "
  while compiling a SQL statement when the following criteria are
  met:
  
  - The database is in DPF.
  - The SQL statement contains an XMLQUERY function call.
  - The XMLQUERY function call PASSING clause contains an XQuery
  variable defined using a global variable, host variable, or
  parameter marker.
  - The XQuery expression contains transform expressions and
  references the XQuery variable multiple times.
  
  Example:
  
  create table T(c xml);
  insert into T values '<root><example>123</example></root>';
  
  SELECT XMLQUERY ('copy $new := $XML modify (
  do insert $s/root/test as last into $new/root,
  do insert $s/root/test2 as last into $new/root)
  return $new'
  PASSING XMLCAST(? as XML) as "s", C AS "XML") from T
  

Local fix

• Instead of using a global variable, host variable, or parameter
  marker within the PASSING clause, use a constant or column value
  instead.
  
  For example, in the query above change the PASSING clause to:
  
  PASSING XMLPARSE(document '<root><example>123</example></root>')
  as "s", C AS "XML"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.1.4.7                                          *
  ****************************************************************
  

Problem conclusion

• Upgrade to 11.1.4.7
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IT24278

• APAR is sysrouted TO one or more of the following:

  IT39643

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP