MVS Publish Transaction Data

MVS Publish Transaction Data

Archive or Purge
Archive
Commit Type (Default)
ALL_OR_NOTHING
Commit Parameters (Default)
None
Tables affected
ES_ROTATION_PUBLISH_TASK
ES_PUBLISH
ES_PUBLISH_EMPLOYEE
Description/Notes
Moves all MVS publishing transactions for MR, OTS, and ASV to the archive schema. This process involves moving:
  1. All data from the ES_ROTATION_PUBLISH_TASK table where the ROTPUBTSK_CREATE_DATE is before the aging date and the ROTPUBTSK_TYPE is not DAILY.
  2. All data from the ES_PUBLISH table where the PUB_REQUEST_TIME is before the aging date.
  3. All data from the ES_PUBLISH_EMPLOYEE table for the publishing transactions identified in #2.