- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Team,
i got an alert from adobe saying that database is full upto 82%.
What i am doing is applying some data retention rules on the custom tables.
For example : in my prod instance it has lot of custom tables with large data and i am applying a delete based on some criteria.
i am using a javascript node :
and executing a delete function like below :
var delete = "delete from tablename where created date > some date"
sqlexec(delete);
Note : i am not commiting this.
i am doing like this for two or three tables and checked the database capacity and it is still 82%
So now i am getting doubt that should we use commit statement after "sqlexec(delete)" like ( sqlexect("commit")) OR is it okay to execute without commit.
Does my assumption is correct ? ( that since i am not using commit the database percentage is not changing ) OR is it some other reason the percentage usage is not changing.
What is the role of commit here.
Also just to know i still needs to do clean up for more tables. also can you suggest any other steps to clean up the custom tables or anything to decrease the database space?
Solved! Go to Solution.
Views
Replies
Total Likes