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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
