JR46310: DB2Z OPERATOR GENERATING WRONG LOAD STATEMENT WHEN A SINGLE PARTITION IS BEING TARGETED.

IBM InfoSphere Information Server, Version 9.1.2

APAR status

• Closed as program error.

Error description

• The load statement created when a TRUNCATE/APPEND write mode
  during a single-partition load was not in accordance to the
  rules laid down by DB2 for targeting a specific partition. The
  REPLACE/RESUME YES clause should be present after the PART
  <integer> clause to generate a correct LOAD Statement which
  would target only the particular partition.
  

Local fix

Problem summary

• DB2Z operator generating wrong load statement when a single
  partition is being targeted.
  

Problem conclusion

• The load statement created when a TRUNCATE/APPEND write mode
  during a single-partition load was not in accordance to the
  rules laid down by DB2 for targeting a specific partition. The
  REPLACE/RESUME YES clause should be present after the PART
  <integer> clause to generate a correct LOAD Statement which
  would target only the particular partition.
  

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

• R850 PSY

     UP