It is possible that you have some corrupted data in text, varchar, bit,
bitnote, varbit or any of the columns that allows large data.
I ran into a situation where a varchar columns suddenly added a large number
of blank spaces and a few oddball characters to each record and storage was
huge.
I loaded one table at a time until I found the culprit and after I cleaned
it up the problem went away. I never found out what caused the problem
I would suggest loading one table at the time and verifying after each load
until you find the table causing the problem.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From: [email protected] [mailto:[email protected]] On Behalf Of Frank Taylor
Sent: Sunday, February 15, 2015 10:49 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Stuck Utilization (Maybe from the snow?)
3 weeks and 7.5 feet of snow and still snowing, I am getting a lot of RBase
work done since I have nowhere to go.
I have a database that seems to be stuck on the utilization and unusable
space that will not go away. I regularly do a reload and repack on the db,
but even after these I show utilization at 83% and 32K+ of unusable space.
I also did an Unload All and then rebuilt the DB, and directly after that it
still shows 83% and unusable space. The Autochk and RScope show no errors.
Any suggestions on what might be going on and how to fix this ?
The previous offer of Snow for sale with free shipping still stands, we are
so overstocked we are giving it away.
Frank Taylor - Director of Information Technology
F.J. O'Hara & Sons, Inc - Araho Transfer Inc.
Boston, MA - Rockland, ME - Miami, FL
Direct Dial - 617-790-3093
Email: [email protected]
