AnsweredAssumed Answered

% of DSA file space in use

Question asked by SamWalker on Jan 25, 2017
Latest reply on Apr 24, 2017 by Chandru.Venkataraman

I apologise if this has been answered already.


I have 2 simple questions. Today , I have run into an issue of file space exhausted for the first time in years. We ran load tests in our non prod, warn_log showed some alerts regarding % and in 2 days we saw the file grew from 60% to 100% eventually making the server unusable.


I have increased db grid size to 1GB from 100MB (default, I dont recall modifying it )and server is operational now.


My questions are:

 I noticed the size of the .db file shows as 1GB, but I dont think I have enough entries to fill up 1GB .  Am I reading this correctly? There are 120,000 siteminder sessions in there as of now. 

-rw-r-----  1 dsa etrdir 954M Jan 25 13:44 sessionstore.db


Is it possible the dsa process created a file of 1GB as per the config, and updates information in it as needed? If so, is it possible to know how much of the available 1 GB I am currently using? Warn_log shows alerts after I hit 50-60 % but I am asking for my own curiosity.


2. How do I empty an existing database? I dont want to delete and recreate a DSA and go through the process of setting up SiteMinder policy store , session store schemas.. I just want to know if there is a simple one command to remove everything from sessionstore.db. 


Thanks everyone in advance.