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"_
