There are times when people have so many darn items in Task Manager that they skip/forget/etc.... the task listed. When these issues happen a simple kill like this is simple and stupid any QUICK! (aka KISS, I know really Keep It Simple Stupid but...) I have ran circles around my office and asked people to get out and check because I still see a open connection. I would then ask them to check Task Manager. Then finally I would do it myself and find the one. After two time of this I figured I needed a cure. A simple batch command code with a question yes/no and done. No more running back and forth. Not everybody know what Task Manger is - how to read it - how to kill a process. No comment!
There are a lot of times the dos commands are simple and fast and forgotten. I often find that a lot of exe's still have a lot of flexibility and are not used. So to make things simple: On your desktop Right Click> New> Shortcut> Browse to Windows/System32/taskkill.exe and SELECT it > Next and > Finish Then edit it: Right Click on the Icon > Properties > and in TARGET: make sure it says 'C:\WINDOWS\system32\taskkill.exe /f /im rbg76ee.exe' or 'C:\WINDOWS\system32\taskkill.exe /f /im rbg76.exe' Change the Icon to something scary and you are done. Sincerely, Paul Dewey Sorry for the delay but coffee and everyday issues came first. You could write a bat/cmd and have a warning come up first to warn the user. You decide. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Tuesday, June 16, 2009 7:35 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IS THERE A LIMIT TO THE SIZE OF A TABLE What was given was instructions on how to mimic the same activity in a DOS window that you would normally do with Windows Task Manager. If you are shaky about using a DOS window, then just use Task Manager as you normally would. ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, June 16, 2009 6:05 AM Subject: [RBASE-L] - RE: IS THERE A LIMIT TO THE SIZE OF A TABLE 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.
