shrinking .dat file after killing a Global

Question

Question

Rochdi Badis · May 2

Hi Guys,

My Cache.dat has a expanded a lot and some globals occupy a lot of disc space with just junk data so I would like to kill some globals and shrink the cache.dat file because I'm running out of disk space?
So is there a way to do that without having to do it through the Truncate & Compact databases?

Thanks

Product version: Caché 2018.1

Discussion (4)3

Log in or sign up to continue

Enrico Parisi · May 2

Compact & Truncate are there EXACTLY to perform what you want/need, no other option.

If want to speed it up, start compacting with "little" space tio free up at the end, then truncate to free disk space and gain some time, then repeat...etc.

0 0

Alexander Pettitt · May 2

Since you are on Cache still make sure it is ok to compact/truncate with your version.
Run an integrity check after to validate the DAT.
Expect large wij growth.
Do @Enrico Parisi's suggestion of a small amount first during a low utilization time.
Mirror and shadow targets have to be done separately.

0 0

score 0 · Answer 1 · 2024-05-02T10:28:59-04:00

Rochdi Badis · May 2

Thanks good idea

0 0

score 0 · Answer 2 · 2024-05-02T10:29:19-04:00

Rochdi Badis · May 2

Thanks again

0 0