Thanks all for the help I think I found my problem. I was running a settings cmd file before the unload all. I think this caused some tables and rows to go bye bbye! I guess I was too smart for my own good.
Below is the file I war running, I don't see anything wrong but it seems to be the problem. thanks marc SET QUOTES=NULL SET QUOTES=' SET DELIMIT=NULL SET DELIMIT=',' SET LINEEND=NULL SET LINEEND='^' SET SEMI=NULL SET SEMI=';' SET PLUS=NULL SET PLUS='+' SET SINGLE=NULL SET SINGLE='_' SET MANY=NULL SET MANY='%' SET IDQUOTES=NULL SET IDQUOTES='`' SET CURRENCY '$' PREF 2 B SET CASE OFF SET AUTOSKIP OFF SET REVERSE ON SET BELL OFF SET NULL '-0- ' SET DATE FORMAT 'mm/dd/yyyy' SET TIME FORMAT 'HH:MM AP' SET DATE SEQUENCE mmddyy SET TIME SEQUENCE hhmmss SET DATE YEAR 5 SET DATE CENTURY 19 SET TOLERANCE 0. SET ZERO ON SET WRITECHK ON SET CLEAR ON --- "A. Razzak Memon" <[EMAIL PROTECTED]> wrote: > At 06:42 AM 8/7/2003 -0700, Marc Schluter wrote: > > >Hi all > > > >I am using RBW 1.866 and noticed if I Pack all or > >unload all then load the file, some rows are > missing. > > > >Is this the latest patch? > >I can't use trace because the unload file is too > big. > >How can I figure out what is going wrong? > > Marc, > > First, you need to figure out why those rows are > missing? > > Bad Index, Broken Pointers, etc ... > > After you PACK and/or RELOAD, and if you PACK and/or > RELOAD > the PACKed/RELOADed database again, do you still > miss any > row(s)? > > Take a look at the following article on: > > From The Edge: Finding and Fixing Broken Indexes > (04/30/2002) > > http://www.razzak.com/fte > > Hope that helps! > > Very Best R:egards, > > Razzak. > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
