JR60833: DB2 CONNECTOR DOES NOT ASSIGN DATA PROCESSING EVENLY WHEN WRITING TO RANDOM DISTRIBUTED TABLES

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

• DB2 Connector does not assign data processing evenly when
  writing to random distributed tables
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using DB2 connector to load data to tables with DISTRIBUTE
  BY RANDOM clause
  ****************************************************************
  PROBLEM DESCRIPTION:
  During data load to tables created with DISTRIBUTE BY RANDOM
  clause,
  DB2 Connector does not assign data processing evenly between the
  players.
  
  Job log contains information about the distribution (example):
  
  <DB2_Connector_14,0> Number of records loaded = 10,000
  <DB2_Connector_14,1> Number of records loaded = 0
  <DB2_Connector_14,2> Number of records loaded = 0
  <DB2_Connector_14,3> Number of records loaded = 0
  
  ****************************************************************
  RECOMMENDATION:
  Install APAR JR60833
  ****************************************************************
  

Problem conclusion

• DB2 Connector code has been corrected to evenly assign data
  processing
  between the player nodes. All players will write data using
  database main
  node when table was created with DISTRIBUTE BY RANDOM clause.
  

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

• RB70 PSY

     UP

• RB71 PSY

     UP