JR61892: NETEZZA CONNECTOR REPORTS TABLE NOT FOUND ERROR IN OPTIMIZED JOBS

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

• Netezza Connector in optimized jobs reports it cannot find the
  target table during schema reconciliation. The problem can be
  observed on systems with fix for APAR JR60007.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of optimized jobs with Netezza Connector
  ****************************************************************
  PROBLEM DESCRIPTION:
  In jobs optimized using Balanced Optimizer Netezza Connector
  reports that the target table cannot be found during schema
  reconciliation and the job fails with error.
  The problem can be observed on systems with Netezza Connector
  version containing fix for APAR JR60007 that decouples schema
  reconciliation routine from the execution of Before SQL and
  Table action operations.
  ****************************************************************
  RECOMMENDATION
  apply patch for JR61892
  ****************************************************************
  

Problem conclusion

• Fix schema reconciliation in optimized connector configuration:
  - Write mode: User-defined SQL
  - Table action: Create or Replace
  - Temporary work table mode: Existing
  - Temporary work table mode / Table name equals Table name
  Make it independent of target table existence and aware of the
  fact that TWT and target table are the same entity.
  

Temporary fix

• Change Netezza Connector configuration in optimized job to use
  the following settings:
  - Write mode: Insert
  - Direct insert: Yes
  

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

• RB70 PSY

     UP

• RB71 PSY

     UP