How to reclaim data store space in timesten 7.0.5 database

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
Who is Participating?
sdstuberConnect With a Mentor Commented:
I don't think you can shrink it directly, but  could you copy the data (if there is anything left after deletes/trunctes), drop the tables (and tablespaces if they have nothing else in them), then recreate the structures and reload the data?
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.