Well use tools like RRR to delete data via remedy. I have deleted similar sized data. In less than 3 weeks.
Sent from my Xperia™ smartphone mahmoud mahdy <[email protected]> wrote: ** I contacted WIPRO whom support BMC Remedy, and they told me that deleting from DB level is better as it is a huge data and the system may not be able to complete. ________________________________ Date: Mon, 15 Jul 2013 04:19:48 -0500 From: [email protected] Subject: Re: Archive Incident Management& Change Management 7.1 To: [email protected] ** Delete from remedy as far as possible. Sent from my Xperia™ smartphone mahmoud mahdy <[email protected]> wrote: ** Dears, I'd like to delete the history and keep only the last two years. so, is it better to delete form remedy forms or DB..? Thanks ________________________________ Date: Mon, 15 Jul 2013 14:41:23 +0530 From: [email protected] Subject: Re: Archive Incident Management& Change Management 7.1 To: [email protected] ** Hi Mahmoud, You can achieve remedy archiving using some of the external tools like rrchive, Informatica, BMC DSO 1. First find out business timeframe and condition for data archieving. 2. Identify main forms and related forms to archieve. Use any of the above tool or similar tool to migrate data. Challenge here would be data integritiy which should be impacted. Good Luck !! Regards Kiran On Mon, Jul 15, 2013 at 2:22 PM, mahmoud mahdy <[email protected]<mailto:[email protected]>> wrote: ** Dears, Kindly help as we have (500 GB database file) which affecting our performance and causing system down. is there a way to truncate the history data from the system or DB..?. Thanks, Best Regards, _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Regards Kiran Patil Cognizant Technology Solutions Pune, India Mob No: +91 989 037 7125 _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
