PH34548: SELECT FROM TABLE(SYSHADOOP.BIGSQL_ENV()) WITH LIMIT CLAUSE CAUSES ROUTINE TO HANG AND BE NON-INTERRUPTABLE

APAR status

• Closed as fixed if next.

Error description

• Big SQL provides a function called BIGSQL_ENV() which is used to
  gather system information. The definition of the VALUE
  parameter is VARCHAR(32K), but the data returned can exceed this
  limit. The data is truncated when received by the Db2 engine and
  an SQLCODE +445 is returned. This works fine, until a LIMIT
  clause is added to the query involving BIGSQL_ENV(). In this
  case, when the limit is reached, an internal interrupt is used
  to stop query processing, but this causes the system to get
  stuck in an infinite loop (hang), and the function will never
  return.
  .
  The hang can happen with either LIMIT or FFNR.
  .
  The following works fine and retrieves the full result set:
  select * from table(SYSHADOOP.BIGSQL_ENV())
  But either of the following hang and cannot be terminated
  or forced off:
  select * from table(SYSHADOOP.BIGSQL_ENV()) fetch first 5 rows
  only
  or
  select * from table(SYSHADOOP.BIGSQL_ENV()) LIMIT 5
  

Local fix

Problem summary

• Please see the problem description.
  

Problem conclusion

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

Applicable component levels