We help IT Professionals succeed at work.

How to reclaim data store space in timesten 7.0.5 database

parpaa
parpaa asked
on
931 Views
Last Modified: 2014-01-06
Hello experts,

Lately i am having challenges with Timesten datastore space issues. I truncated one huge table consisting of 2+ millions rows and even after that i would not get the space back. I tried restarting the TT manager and that didnt work either.

The 'log purge and 'Log auto truncate' options are enabled in my DSN.

Perm size: 900 (currently sitting at 845 mb)
Temp size: 100
log file size 128
log bugger: 131072
Comment
Watch Question

Database Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
If the tablespace has not objects on it drop it using the following syntax

drop tablespace tablespace_name including contents;

This will drop the datafiles at the OS level and free up the space.

If the tablespace is NOT empty, but if it has some freespace move that object to a new tablespace and then drop the tablespace. This will help reclaiming the space.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.