You have to run a truncate if you want to reset the high water marks and release the storage. It's ok to do things in sql against the db, you just need to have an understanding of what you are doing and how it impacts the db, and in turn the applications. Ignorance is bliss, unfortunately it doesn't get you far.
A truncate is like 'delete all', plus some other operations. So long as you clear the T, H, B, B#C tables when truncating one, you will not have a problem. Axton Grams On Nov 26, 2007 11:41 AM, Ravi <[EMAIL PROTECTED]> wrote: > Hi: The diskspace keeps showing high usage even after I have deleted all > records from all of the forms in my remedy instance. DBA is asking me to > run a truncate. But I remember being told in remedy training not do do > anything from sql prompt. I saw one email > ( > http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0709&L=arslist&P=R220861&I=-3&X=23F4FB0752F26A51E6&Y=ravinm%40cox.net > ) > which does run steps from the sql prompt. Can someone confirm if i can > actually run these (copy to a temp table, truncate the original table > and copy the stuff back to the orginal table) from sql prompt without > impacting Remedy operations? > > TIA > Ravi > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
