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.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
