JR59180: IA JOB USING DB2CONNECTOR FAILS AFTER IIS UPGRADE TO 11.7

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

APAR status

• Closed as program error.

Error description

• DataStage job is unable to drop existing table and parse it.It
  is DB2 connector schema reconciliation issue.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IA users of IIS 11.7 after upgrade from previous releases.
  ****************************************************************
  PROBLEM DESCRIPTION:
  A change in the desing of Information Analyzer jobs using DB2
  connector in Information Server 11.7 may result in schema
  validation problems if the table used during analysis existed
  before Information Server upgrade.
  Analysis job reports an error like:
  "pxbridge(7): [Input link 0] Schema reconciliation failed. No
  conversion between typecodes INT32 and DATETIME for field
  DEPENDENTS (CC_DBSchemaRules::negotiateTypedFields, file
  CC_DBSchemaRules.cpp, line 542)"
  ****************************************************************
  RECOMMENDATION:
  Install IIS 11.7.0.0 SP2
  ****************************************************************
  

Problem conclusion

• The schema validation problem was reported despite the fact that
   DB2 connector was configured to recreate (drop then create) the
   target table.
  DB2 connector schema validation routine has been changed not to
  validate the design schema against the table schema in database
  before the target table is recreated.
  

Temporary fix

• Remove the problematic Information Analyzer work table from DB2
  database. The analysis job will recreate the work table before
  it is used.
  

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