JR59561: JOB MAY ABORT WHEN DB2 CONNECTOR REPORTS WARNING: "UNMATCHED PARENTHESIS CHARACTER FOUND AT OFFSET '-1' PARSING SQL"

Download the mod pack for IBM InfoSphere Information Server 11.7.1.0 In-Place Upgrade

APAR status

• Closed as program error.

Error description

• Job may abort when DB2 Connector reports Warning: "Unmatched
  parenthesis character found at offset '-1' parsing SQL".
  
  Error in DB2 CC is reported as "unknown exception" (SIGSEGV) by
  PX Engine, with message :
  ----
  Error when checking operator: Caught unknown exception during
  wrapDescribeOperator().
  ----
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users which provide SQL query to DB2 Connector with table or
  column names containing a COUNT, SEED, SAMPLE, PARTITION,
  SUBPARTITION as a substring. Or queries which cause the SQL
  parser to report a warning.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Job aborts when DB2 Connector reports a warning when parsing
  user defined SQL.
  SQL query containing a COUNT, SEED, SAMPLE, PARTITION,
  SUBPARTITION as a substring of table or column name resulted in
  the following warning:
  "Unmatched parenthesis character found at offset '-1' parsing
  SQL"
  The SQL parsing was interrupted and incomplete table information
  was returned, leading to a segmentation fault.
  ****************************************************************
  RECOMMENDATION:
  Apply the patch JR59561
  ****************************************************************
  

Problem conclusion

• DB2 Connector has been modified to properly parse user defined
  SQL with COUNT, SEED, SAMPLE, PARTITION, SUBPARTITION as a
  substring of table or column name.
  Cases when warning is reported are fixed, to avoid segmentation
  fault.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• RB50 PSY

     UP