Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!apple!mrspoc!itkin From: itkin@mrspoc.Transact.COM (Steven M. List) Newsgroups: comp.databases Subject: Re: Little problem with Unify Keywords: Unify SCOM Message-ID: <1991Apr5.181230.4656@mrspoc.Transact.COM> Date: 5 Apr 91 18:12:30 GMT References: <1991Apr5.004919.9136@aablue.com> Reply-To: steven@Transact.COM Organization: Transact Software Lines: 39 clint@aablue.aablue.com writes: >I ran into a problem two days ago. First, I executed an SQL statement to get >the count of the total records in a specific table and then I ran another one >to get the count of those with valid reference field which is 6 records short >of the total count. So I dumped all the records from this table and ran a >delete statement in SQL mode to clean up the table. After I did that, >I still got a record count of 6 in this supposedly empty table. I've concluded >that I probably need to run SCOM on it, but I'd prefer a simpler way to >get rid of these 6 bad records without spending another two and a half >hours :). >Any help will be appreciated. > >Clint. Sounds to me like the datablock is corrupted. There are a couple of things to be tried. 1. find out what values are stored in the reference field in those mysterious records, replace them with VALID values, then try deleting them. 2. run REPOINT on the parent and child tables and check the error log. See if you can delete them then. 3. combine 1 and 2 If none of this works, or if it looks like it's going to take longer than 2 1/2 hours, then your only option will be to dump and reload. It's not clear that SCOM will do the job, since it dumps good AND bad records. You might also consider checking indexes and hash table. They can cause problems. Finally, you might consider calling Unify Tech Support and asking for "dbck", an unreleased database sanity checker that does many of these tasks as part of a larger process (like fsck). -- +----------------------------------------------------------------------------+ : Steven List @ Transact Software, Inc. :^>~ : : Chairman, Unify User Group of Northern California : : itkin@Transact.COM :