Aiko, My routine is to 1. Connect to the db with MULTI OFF, ERROR ON, ERROR MESSAGES ON 2. Disconnect 3. make a backup copy of the db 4. use the ide to rename the live db to something like DBBACK This does 2 things: It makes sure no one can connect to the db, and when you are done it is another backup. If anything goes wrong you are covered. 5. Connect DBBACK 6. Reload DBNAME I cannot advise you on user case, but others will chime in, I'm sure.
Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Aiko Ichimura Sent: Thursday, August 16, 2007 12:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Latest trouble Dear Dennis, That's worth a try. Can I just give a command at R prompt "Reload database Name"? According to the help instruction, I need to put Dbspec with user case. I don't understand this user case means. Thank you. Aiko Ichimura [EMAIL PROTECTED] ----- Original Message ----- From: "Dennis McGrath" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, August 16, 2007 10:54 AM Subject: [RBASE-L] - Re: Latest trouble We experience this from time-to-time. For us, a reload of the database solves the problem. Since this requires all users to be disconnected, it may be we are just clearing a rogue connection which is tying things up. In any case, reloading cleans up the indexes so is good periodic maintenance. Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Aiko Ichimura Sent: Thursday, August 16, 2007 9:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Latest trouble Hi all, Have you experienced the below symptom? Users noticed considerable slow down of processing time when more than one person are logged on to the Rabse system. This was not observed before and the users are forced wait longer than before. We have asked the Network Administrator to reboot the server and did not solve the problem although it did solve the previous occurrence of the same symptom. Is there anything I could look into to solve this sudden slowness in the multi-users mode? Any suggestion would be appreciated. hank you. Aiko Ichimura [EMAIL PROTECTED]
