JR61260: DB2 CONNECTOR TAKES LONG TIME TO PARSE USER-DEFINED SQL WITH MANY UNION CLAUSE

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• DB2 connector takes long time to parse user-defined SQL with
  many UNION clause
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DB2 connector users
  ****************************************************************
  PROBLEM DESCRIPTION:
  DB2 connector parses the SQL query to obtain table names. When
  the query defined with connector properties contains multiple
  'UNION' clauses, parsing might take up to tens of minutes,
  depending on the complexity of the SQL
  statement.******************************************************
  **********
  ****************************************************************
  RECOMMENDATION
  Install patch JR61260
  ****************************************************************
  

Problem conclusion

• DB2 connector code has been optimized to parse the SQL statement
   much faster.
  

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

• RB70 PSY

     UP

• RB71 PSY

     UP