Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!cs.utexas.edu!uunet!fdls!dougw
From: dougw@fdls.odag.or.gov (Doug Walker)
Newsgroups: comp.databases
Subject: Re: Little problem with Unify
Keywords: Unify SCOM
Message-ID: <352@fdls.odag.or.gov>
Date: 6 Apr 91 20:11:11 GMT
References: <1991Apr5.004919.9136@aablue.com>
Organization: OR Dept. of Agric., F&D-Lab Svcs, Salem, OR
Lines: 33
A-Internet: dougw@fdls.odag.or.gov
B-Uucp: uunet!fdls!dougw
C-Phone: (503) 378-3790

In <1991Apr5.004919.9136@aablue.com> jb@aablue.aablue.com (John B Scalia) 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.

I am assuming you are using Unify 4.x; not their newer product Unify 2000
which I have not used.  Their SCOM utility reconfigures the data base and is
used primarily when adding tables, fields, or increasing the number of
expected records.  I don't SCOM will solve your above problem.

I believe you need to use their REPOINT utility which will rebuild the
expicity relationships within the database.  For those records where it cannot
do this (which is probably your case here), it will write information to file
repoint.err which you can use to correct the problem.  The Database Reference
Manual documents what REPOINT does and explains in detail how to use it.  Be
sure to read the manual section where you can rebuild selected explicit
relationships as this will cut down dramatically on your run time.

Hope this helps.

-- 
-----------------------------------------------------------------------------

Doug Walker               uunet!fdls!dougw  -or-  dougw@fdls.odag.or.gov
Oregon Department of Agriculture, Salem, Oregon           (503) 378-3790