Deleting data from Archive Database

raaj_p · October 20, 2022, 8:08pm

What product/components do you use and which version/fix level are you on?

webMethods 10.7

Is your question related to the free trial, or to a production (customer) instance?

Production

What are you trying to achieve? Please describe it in detail.

We are using WmMonitor services to move data to Archive database. We want to delete data from Archive database after some time.
Do we have any options provided by Software AG or it has to be done through custom scripts

Do you get any error messages? Please provide a full error message screenshot and log file.

Have you installed all the latest fixes for the products and systems you are using?

Nagendra_Prasad · October 21, 2022, 4:42am

Please check this answer - How to archive IS DB Tables - #2 by Kalpesh_Shah1 and see if this helps you.
-NP

Holger_von_Thomsen · October 21, 2022, 4:19pm

Hi Raaj,

in addendum to Nagendras response (which I think you have already set it up to archive data from productive database to archive database):
you can create a second internal IS instance and configured it to use the archive database as its productive schema.
For security reasons I would suggest to create an additional archive schema for the driver tables.
On this second instance run the WmMonitor archiving services in DELETE mode then instead of ARCHIVE mode.

Regards,
Holger

Venkata_Kasi_Viswanath_Mugada1 · October 22, 2022, 2:43pm

While this seems straightforward, there will be issues if both the Archive job executions overlap at runtime, causing an application/database slowdown or even deadlocks in worst-case scenarios.

KM

Holger_von_Thomsen · October 24, 2022, 2:52pm

Hi Kasi,

thanks for adding your thoughts about this.

Therefore I am adding these considerations:
Archiving from real production to archive database should be run during low load periods, i.e. in the night.
Purging/Deleting data from the archive database can then be run around noon, as this will not impact the real database nor conflict the above mentioned archiving in the night.

Additionally the amount of data affected by each run can be controlled by the “days to retain” parameter of the archiving services.
See Monitor Users Guide and Monitor Built-In-Services Reference for details.