JR37321: ORACLE ENTERPRISE STAGE: TARGET TABLE IS TRUNCATED BY JUST VALIDATE THE JOB.

APAR status

• Closed as program error.

Error description

• Just validating a job with Oracle Enterprise stage which uses
  Write Method = Load and Write Mode = Truncate results in actual
  truncation of the target table.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Validation of Oracle EE Stage load method jobs
  ****************************************************************
  PROBLEM DESCRIPTION:
  Load method jobs of Oracle EE Stage potentially affect the
  target table when juts validatting.   A truncation option used
  by the customer cleared the table even as the job is merely
  being validated.  This is not correct functionality.
  ****************************************************************
  RECOMMENDATION:
  apply patch provided.
  ****************************************************************
  

Problem conclusion

• Job description step is doing table operations.  they should be
  done later.  So the operator logic is corrected.
  

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

• R810 PSN

     UP