David: Try CLEAR.ACCOUNT. This should clear both _PH_ and _HOLD_ entries. I run this every day.
Bill >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of David >Wolverton >Sent: Tuesday, January 08, 2008 8:29 PM >To: [email protected] >Subject: [U2] [UD] Cleaning out _PH_ > >Have a _PH_ that is just full of crud and I cannot think of a convenient way >to automate the 'cleanup' from within UniData since there is nothing the key >to the _PH_ record that shows a 'date' -- the design cleverly stores the >User ID and ProcessID - both terribly non-useful for cleanup logic!! > >How do others deal with this maintenance short of telling users to >'periodically zap the records' -- I could clear data over 120 days old and >never lose a moment of sleep, but can't find a way to do this without >resulting to 'directory dump parsing', which just seems wrong. > >This is a 'Windows' box, and it appears to have _PH_ entries back to 2006! >Yikes! > >Thanks for thoughts on this maintenance task... > >David W >------- ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
