You cannot truncate the table willy-nilly. All real db tables must be truncated together else you will get errors that prevent looking at the table with ARS. This also happens if a single id is missing from only one of the tables. It will be no problem to truncate the EIE:LOG table. Just do it to all dependent tables and YES try it on a dev server first! Cheers Ben
_____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Martin, Dwayne Sent: March 25, 2010 4:27 PM To: [email protected] Subject: Re: Question on H and T tables in Remedy Schema ** Jim, The "H" files are Status History. I don't know what will happen if you truncate them. Maybe you just won't be able to see the Status History. Maybe the form won't display at all. You could try it in a test environment and see. Whatever you do, don't do anything irreversible in your production system. Dwayne Martin James Madison University From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jim Coryat Sent: Thursday, March 25, 2010 11:16 AM To: [email protected] Subject: Question on H and T tables in Remedy Schema ** I have a quick question on the tables in the Remedy schema. I know that the T prefixed tables are the actual form data. What function do the H prefixed tables provide? Our EIE:Log form has over 60 million rows. We want to truncate the table and them implement purging for the form. Thinking we can implement the purging and have it purge the rows is not realistic. However I don't want to do this and have some other dependent forms start having issues because of this action. Jim Coryat Micron Technology Inc. ITIL v2 Practitioner Certified _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
