# DB Script is taking more time

**URL:** <https://techcommunity.softwareag.com/t/db-script-is-taking-more-time/190074>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Linux, Adabas-Utilities-on-Open-Systems\
**Created:** [August 8, 2016, 9:11am UTC](https://techcommunity.softwareag.com/t/db-script-is-taking-more-time/190074 "2016-08-08T09:11:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krishna\_PB](https://avatars.discourse-cdn.com/v4/letter/k/278dde/32.png) [@Krishna\_PB](https://techcommunity.softwareag.com/u/Krishna_PB)\
**Post date:** [August 8, 2016, 9:11am UTC](https://techcommunity.softwareag.com/t/db-script-is-taking-more-time/190074/1 "2016-08-08T09:11:40Z")

</div>

Hi Team,

WMPROCESSSTEP table is taking more time while executing the DB migration script?  
Do you have any idea what happens if we delete the content from WMPROCESSSTEP table? Is there any impact?

Any suggestion on this.

Thanks,  
Krishna

---

<div class="post-metadata">

**Author:** ![Holger\_von\_Thomsen](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/holger_von_thomsen/32/178_2.png) [@Holger\_von\_Thomsen](https://techcommunity.softwareag.com/u/Holger_von_Thomsen)\
**Post date:** [August 8, 2016, 10:32am UTC](https://techcommunity.softwareag.com/t/db-script-is-taking-more-time/190074/2 "2016-08-08T10:32:39Z")

</div>

Hi Krishna,

please check Monitoring Users/Administration Guide for the Archiving feature.

By using this featrue it is possible to remove outdated data in consistent manner from several WMPROCESS\* tables.

From which wM version are you migrating and which one will be the target?

Please note that the table names might change during migration dependent on target version

Regards,  
Holger

---

<div class="post-metadata">

**Author:** ![Krishna\_PB](https://avatars.discourse-cdn.com/v4/letter/k/278dde/32.png) [@Krishna\_PB](https://techcommunity.softwareag.com/u/Krishna_PB)\
**Post date:** [August 8, 2016, 12:36pm UTC](https://techcommunity.softwareag.com/t/db-script-is-taking-more-time/190074/3 "2016-08-08T12:36:51Z")

</div>

we are migrating from 8.2.2 to 9.8.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:36pm UTC](https://techcommunity.softwareag.com/t/db-script-is-taking-more-time/190074/4 "2021-04-02T15:36:41Z")

</div>