The database is located on G drive and each computer has RBASE on the local C drive. Which drive will I execute this code on?
Forgive me but it has been so long since I have used the DOS window, I even need to know how to change to another drive. Jim As you can see, I am not a programmer. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Paul Sent: Monday, June 15, 2009 10:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IS THERE A LIMIT TO THE SIZE OF A TABLE At each workstation: Start> Run> type 'cmd' when the dos window opens type 'Taskkill /f /im RBG76.exe' If you are using 76 Extended: 'taskkill /f /im RBG76EE.exe' etc.... I actually had a temp command that I had on the desktop that had this code till I found the issue. I had the users use it just to make sure. It is much easier than shutting down a server. Good Luck and I hope this works. Paul Also if this happens to be a Windows Server you can use RBase Admin to see the connection and shut it down. It also works in Linux to shut down users also. From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, June 15, 2009 7:37 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IS THERE A LIMIT TO THE SIZE OF A TABLE I AM USING 7.6. I THINK PART OF THE PROBLEM IS THIS: WHEN WE RECENTLY ADDED 7.6 TO A NEW USER, THE INSTALL HAD A PROBLEM. THOUGH WE GOT THE PROBLEM FIXED AND 7.6 IS ON THE COMPUTER, I HAVE NOT BEEN ABLE TO PACK MY DB BECAUSE THE SERVER CONTINUES TO "SEE" AN OPEN CONNECTION THOUGH THERE IS NONE. I WILL HAVE TO MAKE A TRIP TO THE OFFICE AND SHUT THE SERVER DOWN TO CLEAR THE CONNECTIONS. ALL THE SUGGESTIONS I HAVE RECEIVED SEEM TO POINT TO THAT AS BEING THE ONLY SOLUTION. I THINK NOW MY DB IS JUST SLOWING DOWN AND NEEDS PACKING. THANKS FOR THE INPUT. JIM ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Monday, June 15, 2009 6:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IS THERE A LIMIT TO THE SIZE OF A TABLE I have currently 4136 images stored in a table that is about 130 mb. They are in a VARBIT column. You can use the unload command and see what size the lob file is to get a pretty accurate size. I am using V8 turbo. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, June 15, 2009 4:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - IS THERE A LIMIT TO THE SIZE OF A TABLE I am running into a problem with a table that contains many BLOBs. Is there a size limit on how many total bytes in a table? I am locking up each time I try to insert more BLOB's. I can tell how many rows are in this table. Is there a way to tell the Byte size of a table? Jim No error message is coming up. The database just locks up.
