Search
BWFreak - Journey to the center of Business Intelligence

Archive for January, 2009

Huge BALDAT and EDI* tables

Posted on January 2nd, 2009

When checking tablespace, found BALDAT and EDI* tables indexes are huge. To delete records in BALDAT, use SLG2. Keep in mind that there might be a lot of the logs with expiry date 12/31/9999. To delete them, choose
Expiry date: “and logs which can be deleted before the expiry date”
It also makes sense if you keep the disk usage [...]