• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 94 subscribers
  • Views 2417 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Dialogprocess table entries movement to HDB

sabari.gopalaswamy
over 6 years ago

Currently in dialogprocess table in our system, more than 10 million records exists which are 3 years old. This affects the performance of daily dbscheduler jobs(commonshrink jobs). This data to be moved to safely to HDB->rawprocess. could you give some addtional steps to be considered while transferring data manually from live db to HDB.

Parents
  • 0 over 6 years ago
    Could you provide some more information on the retention time, which life time in the config param value to be changed

    we have jobhistory retention time as 56
    propertylog retention time as 14
    progressview is currently disabled

    and the records in dialogprocess are existing more than 3 yrs old records.

    SP vid_DialogProcessShrink which is taking too long time for execution.
Reply
  • 0 over 6 years ago
    Could you provide some more information on the retention time, which life time in the config param value to be changed

    we have jobhistory retention time as 56
    propertylog retention time as 14
    progressview is currently disabled

    and the records in dialogprocess are existing more than 3 yrs old records.

    SP vid_DialogProcessShrink which is taking too long time for execution.
Children
No Data