JR32456: REJECT RECORDS FROM NETEZZA STAGE OVER WRITING IN REJECT FILE.

APAR status

• Closed as program error.

Error description

• Reject records from Netezza stage are over writing previous
  reject records in the reject file, instead of appending.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IS 801 RH Linux Netezza EE Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  Reject records from Netezza stage are over writing previous
  reject records in the reject file, instead of appending.
  ****************************************************************
  RECOMMENDATION:
  PREREQUISITE: A PX-Engine patch has to applied before the
  netezza patch is applied.
            1.PXEngine patch (JR32539 built on 2nd Apr)
  Then install JR32456 built on 8th April.
  
  The fix has been included in the IS 81 FP1. Apply the Fixpack 1
  for the IS 81.
  ****************************************************************
  

Problem conclusion

• The file names for the log (.log) and reject (.bad) files
  include a timestamp (to distinquish one run from another) and a
  partition number (so that each partition gets a unique file
  namefor its log and reject files).The prototype implementation
     generates names of the form:
  
      <directory>/<database name>.<table
  name>.<timestamp>.p<partition number>.log
    <directory>/<database name>.<table
  name>.<timestamp>.p<partition number>.bad
  
  Directory is the first of $APT_NETEZZA_LOAD_FILES, $TMPDIR or
  /tmp found.
  

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

• R801 PSY

     UP