Excellent information everyone. Yes, try this first in a non-production environment first!
Thank you Thad, this can come in handy for cleaning out disk space this has no value to our environment. ~Jim From: Thad K Esser [mailto:[email protected]] Sent: Thursday, March 25, 2010 10:27 AM Subject: Re: Question on H and T tables in Remedy Schema ** Depending on your version of ARS, you could disable status history on the form. This is from the 7.1 "what's new" guide (note that doing this deletes existing status history): Disable status history recording and retrieval This feature provides a property for regular forms that disables the server maintenance of status history. When the property is set to disable status history maintenance, the server clears the history, does not update it when the status changes, and returns AR_DATA_TYPE_NULL when the status history is requested. BMC Remedy User or a form viewed in a browser using BMC Remedy Mid Tier display an empty status history when it is disabled. Thad Esser Remedy Developer From: Jim Coryat <[email protected]> To: [email protected] Date: 03/25/2010 08:16 AM Subject: Question on H and T tables in Remedy Schema Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ________________________________ ** 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"_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _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"
