Will running compact command multiple times help more to reduce the storage size?

Will running compact command multiple times help more to reduce the storage size?

book

Article ID: KB0093231

calendar_today

Updated On:

Products Versions
TIBCO Enterprise Message Service -
Not Applicable -

Description

Resolution:
Yes, it may helps.
There is no direct control over what records are located where in the store file, usually when all "tail"  records are deleted the file will shrink.

The compact command start to move the records from the tail to above free space in the file. There is a possibility
that it might not get the enough free space to move in the first run. But in the second run, it might get more space.

We recommend compacting the database store files only when the database Used Space
usage is 30% or less.  You could run show db to findout the space usage and run the compact command again.

Issue/Introduction

Will running compact command multiple times help more to reduce the storage size?