Dennis, In essence, I've done that. I took this network weirdness as the opporunity to do an UNLOAD from V8 and a LOAD into V9.
That process worked as expected with no errors and all TABLES being loaded. Then recompiled into V9 and embedded the engine and all FORMS, REPORTS and LABELS. Even included all the licenses and RBM's into the EXE. The resulting EXE is now placed on the users machine so the only thing that should now transfer over the network is data itself. Network still doesn't like it. Jan -----Original Message----- From: Dennis McGrath <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 19 Jan 2011 15:02:40 -0600 Subject: [RBASE-L] - Re: Pack versus Unload/Load Jan, Until you go through an UNLOAD/LOAD cycle you don’t know for sure if it is the DB that is causing the problem or not. I do a reload weekly, or when the users start having indexing issues. I do an UNLOAD/LOAD when things still don’t “feel right” after a reload. We were trying to use a third-party database analyzer and it was crashing. RELOAD did not solve the problem. UNLOAD/LOAD solved the problem. Dennis From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Wednesday, January 19, 2011 2:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Pack versus Unload/Load Wish mine was that easy. Something happened overnight on Jan 10 that has brought the database to it's knees. I can only have one at a time in if they want to get anything done. AUTOCHK shows everything is fine. The database is reloaded everynight. So I know it's not an R:BASE thing. File transfer across the network is fine. It's like something is watchdogging the RX files. I don't have antivirus running. I'm kinda at a loss. Jan -----Original Message----- From: [email protected] To: [email protected] (RBASE-L Mailing List) Date: Wed, 19 Jan 2011 20:33:19 +0000 (UTC) Subject: [RBASE-L] - Re: Pack versus Unload/Load Thanks all. That is what I needed to know. I know the UNLOAD/LOAD the preferred method, but I needed to know about the PACK as there are times that a full unload/load is difficult to fit in. (Not that I am having any serious problem. 6 years on a production database with 10 wireless units on fork trucks, several "unschooled users" , 300,000 sqft facility with ethernet wiring running who knows where and not a single corruption until today! A quick 2 minute PACK got us back and running, but I wanted to check about it anyway.) A good load/unload will wait until tonight Thanks again. -Bob ----- Original Message ----- From: "Lawrence Lustig" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, January 19, 2011 1:46:08 PM Subject: [RBASE-L] - Re: Pack versus Unload/Load << Will the PACK command fix anything that a Load/Unload would fix? At least in theory? >> No. With PACK you don't get a new copy of the RB1 file so problems in the database structure (like mismatched PK/FK relationships) will carry over. -- Larry
