Murex – Archiving & Purging
Submitted by Markus Linke on Friday, 31 October 2008View Comments
Hi Folks:
We would like to archive our existing Murex transaction database to save database space, better data management and gain performance.
Does Murex provide any tool to archive Murex transaction database? We can think of few ways to archive data from Murex transaction database…
1) Database procedure: Store proc based archive process which will extract data from Murex DB. But here underlying murex database (read datamodel) is unknown to us. [...]
You can try to use the Murex native “Logical purge” procedure (akin to archiving). This procedure will retain the basic characterisitcs of the purged transactions in the database and will delete any non-critical data associated with the transactions. Refer to mxdoc document for details. Alternatviely, the “Physical purge” procedure will completely remove the transactions from the database.
You can write a dynamic database formula/filter to identify the deals that will be affected by the purge procedure prior to purging.
You can try to use the Murex native “Logical purge” procedure (akin to archiving). This procedure will retain the basic characterisitcs of the purged transactions in the database and will delete any non-critical data associated with the transactions. Refer to mxdoc document for details. Alternatviely, the “Physical purge” procedure will completely remove the transactions from the database.
You can write a dynamic database formula/filter to identify the deals that will be affected by the purge procedure prior to purging.