ESP dSeries Workload Automation

 View Only

Cause of excessive data update of WADE Repository Table

  • 1.  Cause of excessive data update of WADE Repository Table

    Posted Apr 27, 2020 12:42 AM
    I am using Oracle as the WADE repository DB,
    Oracle DB is being used in archive log mode.
    Disk full occurs due to excessive archive log,
    In the esp_subscription TABLE, 10 million cases (insert, delete) were being processed.


    The number of JOBs is about 200, and the number of JOBs processed per day is not large.
    What causes excessive data change in the table below?

    esp_subscriptions
    esp_publishers
    esp_l2o_map
    esp_pubsub
    esp_manager_inq
    esp_wss_job

    Since a reference file is attached, please analyze the cause with reference.

    Many Thanks