Re: Archive Incident Management Change Management 7.1
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 mahmoud_ma...@live.comwrote: ** 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 * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Archive Incident Management Change Management 7.1
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: kiranpatil@gmail.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.com 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Archive Incident Management Change Management 7.1
Delete from remedy as far as possible. Sent from my Xperia™ smartphone mahmoud mahdy mahmoud_ma...@live.com 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: kiranpatil@gmail.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.commailto:mahmoud_ma...@live.com 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Archive Incident Management Change Management 7.1
If you delete from Db then remedy may not be aware of what all data have been deleted and there are chances that deleting data from db, form association won't be maintained causing some other inconsistency. You better delete it from remedy application. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of mahmoud mahdy Sent: Monday, July 15, 2013 2:49 PM To: arslist@ARSLIST.ORG Subject: Re: Archive Incident Management Change Management 7.1 ** 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: kiranpatil@gmail.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.commailto:mahmoud_ma...@live.com 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Archive Incident Management Change Management 7.1
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: vkulka...@columnit.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** Delete from remedy as far as possible. Sent from my Xperia™ smartphone mahmoud mahdy mahmoud_ma...@live.com 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: kiranpatil@gmail.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.com 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Archive Incident Management Change Management 7.1
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 mahmoud_ma...@live.com 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: vkulka...@columnit.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** Delete from remedy as far as possible. Sent from my Xperia™ smartphone mahmoud mahdy mahmoud_ma...@live.com 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: kiranpatil@gmail.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.commailto:mahmoud_ma...@live.com 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
Re: Archive Incident Management Change Management 7.1
where can I get RRR tool..?? Date: Mon, 15 Jul 2013 04:44:24 -0500 From: vkulka...@columnit.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.com 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: vkulka...@columnit.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** Delete from remedy as far as possible. Sent from my Xperia™ smartphone mahmoud mahdy mahmoud_ma...@live.com 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: kiranpatil@gmail.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.com 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_ _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
Re: Archive Incident Management Change Management 7.1
Hi, Please refer below link for RRR tool details. *https://www.rrr.se/cgi/index?pg=chive-doc* If you are thinking of using Remedy Archiving to implement, below are brief details To delete the older records we can use the archive option in AR System form. Open the required form in Developer Studio, go to Form-Form Properties-Archive: Enable the archiving and set it to any one of the followings as per requirement .. Copy to Archive and Delete from Source if you want to only move the data to the archive form and delete it from main source form. .. Copy to Archive, so that the data is moved to archive form and it is still present on the main form. .. Delete from Source, if you want to delete the data from the main form. In case you want to delete the records and no longer need it select Delete from source. Once you delete the records from the main form you will not be able to get them back. So use this option with caution. *[Note: Remedy archiving has big performance impact, so avoid to perform this activity during business working hours]* Regards Kiran On Mon, Jul 15, 2013 at 4:34 PM, mahmoud mahdy mahmoud_ma...@live.comwrote: ** where can I get RRR tool..?? -- Date: Mon, 15 Jul 2013 04:44:24 -0500 From: vkulka...@columnit.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.com 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: vkulka...@columnit.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** Delete from remedy as far as possible. Sent from my Xperia™ smartphone mahmoud mahdy mahmoud_ma...@live.com 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: kiranpatil@gmail.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.comwrote: ** 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_ _ARSlist: Where the Answers Are and have been for 20 years_ _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 * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Archive Incident Management Change Management 7.1
Since you are running ARS 7.1.x, I suspect you are storing CLOBs out of row(default config) which will increase the db size drastically. We have gone through conversions to move the CLOBS to in-row, and it shrank the db anywhere from 60-80%. You can have your dba review the tables to confirm the CLOB tables are consuming a lot of disk space or not. Thanks, Bryan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of mahmoud mahdy Sent: Monday, July 15, 2013 5:41 AM To: arslist@ARSLIST.ORG Subject: Re: Archive Incident Management Change Management 7.1 ** 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: vkulka...@columnit.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** Delete from remedy as far as possible. Sent from my XperiaT smartphone mahmoud mahdy mahmoud_ma...@live.com 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: kiranpatil@gmail.com Subject: Re: Archive Incident Management Change Management 7.1 To: arslist@ARSLIST.ORG ** 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 mahmoud_ma...@live.com 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