John, I have seen this issue before on our server, not in a Unload/Reload, but in the file being locked with no users or open files being reported by the server. If I do a LOGOFF of the current user on the server, it usually will go away without having to do a full reboot. Let us know what you find in your checking of the issue.
Frank Taylor - Information Technology Administrator F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Thursday, May 05, 2011 8:56 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Over reloading/repacking Frank, Since November of last year, I have been performing an unload/reload once per week at four of my sites (all V8 compiled). Three times in the past 6 months, two of the sites have reported that the unload failed with an "Access violation" and they could not logon to the application until they rebooted the server. I have never been able to see the problem until yesterday, when the customer called before they rebooted. Here is what I found: The basic process is: BACKUP DB AUTOCHK - No errors reported UNLOAD ALL RENAME THE DB LOAD ALL The access error occurred during the unload; before the DB was renamed. I do not know where in the unload process the failure occurred because I do not output the command execution sequence to a file. I will in the future. The reason that they could not logon to the application after the reload attempt was because the RX4 file was "in use". I checked the server open file list and it did not show the RX4 file open. I could not copy or delete the RX4 file. I rebooted the server and everything worked properly after the reboot. I reran Autochk (no errors). This DB is on a Dell server running OS 2008. I plan to do some more checking after close of business tonight (RScope etc.). A month or so ago, I asked my clients if they noticed an improvement in performance since I started the weekly Unload/reload and all but one said that they did not notice any change. I think that I will go back to a monthly unload/reload. BTW, I make heavy use of temp tables and temp views. John Engwer (412) 751-2433 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Frank Taylor Sent: Wednesday, May 04, 2011 2:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Over reloading/repacking Is there such a thing as over reloading/packing your database ? Our Database uses a lot of permanent tables to store temporary data. ( We used to use temp tables a long time ago, but ran into corruption issues). This leads to a high number of fragmentation in our File 2 with utilization dropping quickly each day, which appears to slow our DB down on lookups and printing. As standard practice I used to do a Reload / Pack routine every Sunday with an unload/load every month. But now we are getting busier and it seems like I need to do a reload/repack on a daily basis to keep things running fast. So the question is, is there such a thing as over doing a reload/repack on a DB ? Anyone have experience with doing reloads frequently ? Frank Taylor - Information Technology Administrator F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: [email protected] _______________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. If you need assistance, please contact the Systems Administrator, Frank Taylor at [email protected] - 617-790-3093. _______________________________________________________________________
