My first recommendation is to never use PACK because if you lose data, your data is gone, gone, gone. Also, PACK does not (TTBOMK) move the data contiguous as does the RELOAD.
My second recommendation is to AUTOCHK the database before doing a RELOAD. See the syntax I use below. Note that I am connecting single user when I do the autochk to prevent any other user from connecting during the check. You must disconnect and reconnect before running the check, as it really goes astray if there are temporary tables in the schema when you run the check. My third recommendation is to delete from any permanent or reporting/calculating tables you may have. I find that the autochk will often find errors in these tables where the data does not matter, and have taken to running a series of DELETEs at the top of the command file that does the autochk. R>SET NULL -0- R>DISCONNECT R>SET MULTI OFF R>CONNECT <dbname> R>DELETE FROM <reporting tables> R>OUTPUT Autochk.log WITH SCREEN R>AUTOCHK FULL R>OUTPUT SCREEN R>RBEDIT AUTOCHK.LOG An alternate method would be to disconnect and run AUTOCHK <dbname> FULL, but then you open the system to a user connecting while you are attempting to autochk the database. marc schluter <[EMAIL PROTECTED]> 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? > >thanks marc > > >__________________________________ >Do you Yahoo!? >Yahoo! SiteBuilder - Free, easy-to-use web site design software >http://sitebuilder.yahoo.com > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
