Jim, Dwayne, Until ARS 7.1, it was a big deal if the H tables data was missing. When searching you would get an error about data missing from the SQL database (ARERR 303 if I am not mistaken).. ARS version 7.5 does not care about the contents of the H tables.. If its there its fine and it will display the Status History, and if missing, it would just display Status History with null values. It will not complain of missing data..
Joe ________________________________ From: "Martin, Dwayne" <[email protected]> To: [email protected] Sent: Thu, March 25, 2010 11:27:04 AM 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
