Two options we have seen from BMC are DSO and custom scripts, both require custom mappings for each of ~1000 regular forms. Additionally, structure changes would need to be maintained in custom mappings when customizations, patches, and upgrades are installed. Since BMC no longer includes the change details in ITSM patch release documentation, both solutions are problematic.
There are database level products that allow some mining of the redo logs and should give a hybrid replication/archive functionality. One strategy under development is strip purge job deletes from the redo logs and propagate all other data/structure changes. Two products that we have encountered are Oracle Golden Gate and IBM Change Data Capture (neither is in use yet and this is not an endorsement or recommendation). Matthew Kunkel Systems Engineer Phone 479.277.3392 [email protected] Walmart 805 Moberly Lane, MS32 Bentonville, AR 72716 Save money. Live better. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of patchsk Sent: Tuesday, January 24, 2012 2:19 PM To: [email protected] Subject: Archiving strategy on ITSM 7.6 + ** We just started to looking at archiving our production data. We are currently in ITSM 7.6.03. With so many related forms to main forms, it would be tricky and take significant effort to properly draw the archiving plan like which forms need to archived in which order so that relationships are carried over so that a closed incident will be moved to a different server or a different form with all of its relationships in tact. Anyone done this already, if so can you provide a few details on the strategy you followed. DSO is another option we are looking at it but have not made decision yet. We can not use DB level replication because if we delete a record in production then it will delete it from replicated database also. Seems like from BMC knowledge base it is not supported and cannot provide any guidelines. But we cannot just keep storing the data in production. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. *** Walmart Confidential *** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
