JR53023: NETEZZA CONNECTOR QUERIES FOR THE TABLE DUMMY

InfoSphere Information Server, Version 11.5 for Linux
InfoSphere Information Server, Version 11.5 for Windows
InfoSphere Information Server, Version 11.5.0.2 for Linux
InfoSphere Information Server, Version 11.5.0.2 for AIX
InfoSphere Information Server, Version 11.5.0.2 for Windows
InfoSphere Information Server, Version 11.5.0.1 for AIX

APAR status

• Closed as program error.

Error description

• Netezza Connector issues the statement "SELECT * FROM DUMMY
  WHERE 1=2" to see if the connection is still active or dead.
  This will result in multiple "ERROR:  Relation 'DUMMY' does not
  exist" errors in the pg.log file on the Netezza Server. With
  this fix, the connection valid test is modified to use a
  different mechanism to check the connection validity.
  

Local fix

• n/a
  

Problem summary

• Netezza Connector issues the statement: SELECT * FROM DUMMY
  WHERE 1=2 query to test whether the connection is still active.
  This is filling up the Netezza side pg.log file and if the table
  doesn't exist, ERROR: relation not found messages are logged.
  

Problem conclusion

• Modified the connection validity check to use SQLGetInfo API and
  checking the error code to see if the connection is still active
  or dead. This way there won't be any queries related to DUMMY
  table are fired by Netezza Connector.
  

Temporary fix

• Create a table called DUMMY with any schema to avoid ERROR:
  relation not found messages in the pg.log file.
  

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

• R850 PSY

     UP

• R870 PSY

     UP

• R910 PSY

     UP

• R912 PSY

     UP