// you’re reading...

Murex Mailing List

Murex - Archiving & Purging

00000
By Markus Linke ⋅ October 31, 2008 ⋅ Email This Post Email This Post ⋅ Print This Post Print This Post ⋅ Post a comment

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. [...]

Print This Post

Discussion

Comments for “Murex - Archiving & Purging”

Viewing 1 Comment

    • ^
    • v
    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.
 
close Reblog this comment
Powered by Disqus · Learn more
blog comments powered by Disqus

Join Us

Join Us
Bookmark and Share

The User Group and this website are not sponsored, endorsed or approved by Murex S.A.S. or any of its affiliates (“Murex”), and Murex is not responsible for any statements or postings by the User Group or any content on this website. The User Group is an independent organization which is operated and managed for the benefit of its members, and has no relationship with Murex. The trade name and trademark “Murex”, the Murex logos, and all other Murex-related trademarks, service marks, product names (including, without limitation, MX.3, MXIII, MxGeneration 2000) and other indicia of origin are the property of Murex S.A.S. and its affiliates, and Murex S.A.S. and its affiliates reserve all rights with respect thereto. CAUTION: USE THE INFORMATION FOUND HERE AT YOUR OWN RISK! PLEASE BE AWARE THAT ANY INFORMATION YOU MAY FIND HERE MAY BE INACCURATE, MISLEADING, DANGEROUS OR ILLEGAL. DO NOT TRY ON PRODUCTION ENVIRONMENTS!

Feedback Form