JR52093: GREENPLUM CONNECTOR JOBS MIGHT HANG IN SQLGETDIAGREC ON ERROR OR WARNING

IBM InfoSphere Information Server, Version 11.3.1.2 (Fix Pack 2)

APAR status

• Closed as Vendor Solution.

Error description

• GreenPlum Connector jobs might hang whenever the server throws
  any error or warning messages with the headings NOTICE / HINT /
  CONTEXT / ERROR etc. This is a problem with DataDirect ODBC
  GreenPlum driver and defect# PSC00323000 has been filed.
  

Local fix

• Job may run successfully in sequential mode
  

Problem summary

Problem conclusion

Temporary fix

Comments

• The GreenPlum Connector jobs might hang when the SQL Statement
  returns any of the NOTICE / HINT / WARNING / ERROR etc messages.
  Also the function may not return the return value when ODBC
  Connector is used. Both the problems are fixed in the following
  Driver versions.
  
  DD 7.1
  ------
  $ bin/ddtestlib lib/libodbc.so
  Load of lib/libodbc.so successful, qehandle is 0x1793030
  File version: 07.14.0137 (U0135)
  
  $ bin/ddtestlib lib/VMgplm00.so
  Load of lib/VMgplm00.so successful, qehandle is 0x501030
  File version: 07.14.0166 (B0190, U0135)
  
  
  DD7.0
  ------
  $ bin/ddtestlib lib/libodbc.so
  Load of lib/libodbc.so successful, qehandle is 0x501030
  File version: 07.01.0111 (U0090)
  
  $ bin/ddtestlib lib/VMgplm00.so
  Load of lib/VMgplm00.so successful, qehandle is 0x501030
  File version: 07.01.0093 (B0138, U0090)
  

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