Skip to Content
Nov 11, 2013 at 02:14 AM

Query on BALDAT and BALHDR Table Size


Hello experts,

I need your help to enlighten me if there is any way to know the specific table size in BALDAT and BALHDR table. I am currently doing an archiving via sbal_delete to perform the deletion for old logs in the system. I am instructed to perform the deletion on a yearly basis, where I have to record the before and after deletion size of every year, which I monitor through DB02 transaction, recorded before and after running sbal_delete.

However, as I am performing the deletion, the size of both table keeps expanding as the new logs comes in every minutes and because of that, I can't get the exact space size of the deleted logs on that particular year I am deleting.

Therefore, I would like to know, is there any way where I can get the exact size of these two tables, filtered by yearly records, or any efficient way where I can get the size on before and after deletion more accurately?