JR34774: APPLIED PATCH JR34496 THE PERFORMANCE IS DEGRADING.

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• After applied patch JR34496 job is running slower
  

Local fix

• This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  all
  ****************************************************************
  PROBLEM DESCRIPTION:
  Upsert is running very slow after applying a patch for APAR
  JR34496.
  ****************************************************************
  RECOMMENDATION:
  Apply patch provided.
  ****************************************************************
  

Problem conclusion

• Bind variables are always assigned a character form NCHAR.  This
  is causing Oracle to skip indexes (as those are CHAR columns in
  the indexes). A full table scan per record is making upsert DML
  to a crawl.
  
  For a bind variable,  the operator now tries to read the
  character form of the corresponding target column and use it.
  If there is no corresponding column found, we need to use NCHAR
  as character column as default.
  

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

• R753 PSN

     UP