Sorry about that, what I meant was that we weren't moving what I considered to be a large number of records since we didn't have a very busy help desk. If you had say over 100K records to move then that might cause other processes on the server to take a performance hit.
I might even be remembering incorrectly, I might have scheduled it for every night as that does make much more sense. It has been several years since I even looked at that job and I've moved on to another engagement recently so I can't go back to check. In any case it was definitely a set & forget for me, it worked flawlessly to move the records over and retain request ID numbers as advertised. -Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Tuesday, August 07, 2012 8:44 AM To: arslist@ARSLIST.ORG Subject: Re: EXTERNAL: Help on archiving data. Hi Rick, Can you elaborate on the "caveat"? There should be no 10K limit to the number of records RRR|Chive can move in a single run. And why not run it every night. This would minimize impact even further, as fewer records will be deleted each run. The technical limit of the 32-bit Windows version of RRR|Chive, when moving records is somewhere around 20M records per run. Make sure to use the splitsearch=YES parameter to avoid tablescans. Best Regards - Misi, RRR AB, http://rrr.se > In my last engagement I built a simple batch file to call RRR|Chive > with parameters and then used the Windows scheduler to run monthly > record archiving for anything older than 36 months to the read-only > archive copy of the form (yes the business wanted to keep three years' > worth of tickets in the live form). The batch file ran in the middle > of the night (corporate office time) when Remedy activity was at its > slowest so the performance impact was minimal. One caveat is that it > was only moving less than 10K records each month. > > -Rick > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky > Sent: Tuesday, August 07, 2012 7:01 AM > To: arslist@ARSLIST.ORG > Subject: Re: EXTERNAL: Help on archiving data. > > Hi, > > RRR|Chive has the ability to MOVE things, which is good when you do > archiving. If the forms are identical, it is very easy, and you can > retain the original Request ID, which the built in archiving does not > support. > > You can also use RRR|Chive to archive things to ARX-files. If you then > use > RRR|ArxToHTML, you get a very simple way of accessing your old data > RRR|from a > web server or a file share. > > Here is a sample database dump done with RRR|Chive and RRR|ArxToHTML > of a newly installed ITSM 7.6.04 Stack Installer: > http://rrr.se/itsmdoc/itsm764arxhtml/ > > This sample rrrchive config will archive between two forms after 3 months: > source_server = myserver > source_user = Demo > source_password = > source_form = HPD:Help Desk > target_server = myserver > target_form = HPD:Help Desk Archive > qual = '7' = "Closed" AND '6' < $TIMESTAMP$ - 3*30*24*60*60 > transfertype = MOVE > logfile = AUTO > progressbar = YES > > This sample rrrchive config will archive to ARX-files after 6 months: > source_server = myserver > source_user = Demo > source_password = > source_form = HPD:Help Desk Archive > target_dir = C:\archive > target_form = HPD:Help Desk Archive > qual = '7' = "Closed" AND '6' < $TIMESTAMP$ - 6*30*24*60*60 > transfertype = MOVE > logfile = AUTO > progressbar = YES > > This RRR|ArxToHTML call will create HTML pages based on an ARX-file > and a DEF-file with the form definition: > rrrArxToHTML.pl -suppressnull -d "c:\archivehtml\schema.def" -a > "c:\archive\HPD_Help_Desk_Archive.arx" -t "c:\archivehtml\html" > > ADV: If you want a supported solution, you can always sign up for > support on RRR|Chive, which is otherwise free to use. Just ask for a quote. > > Best Regards - Misi, RRR AB, http://rrr.se > >> Robin, >> Both of these could be handled by RRR|Chive. >> www.rrr.se >> >> Misi's tools are very straight forward. >> >> Thank you, >> --- >> John J. Reiser >> Remedy Developer/Administrator >> Senior Software Development Analyst >> Lockheed Martin - MS2 >> The star that burns twice as bright burns half as long. >> Pay close attention and be illuminated by its brilliance. - >> paraphrased by me >> >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Robin >> Sent: Tuesday, August 07, 2012 3:07 AM >> To: arslist@ARSLIST.ORG >> Subject: EXTERNAL: Help on archiving data. >> >> Hi all, >> >> Can you please let me know your suggestions/solutions on requirements >> 1 and 2? >> >> 1) Transfer records from a regular form to an archive form and delete >> records from the regular form. I don't want to use built-in remedy >> archive feature as it consumes lot of resources and takes long time >> to complete. >> >> 2) Transfer records from an archive table to a different database >> table and delete records from the archive table. >> >> The AR System database is oracle. >> >> >> Regards >> Robin >> >> _____________________________________________________________________ >> _ _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> >> _____________________________________________________________________ >> _ _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature