Skip to Content
0
Former Member
Apr 07, 2014 at 11:44 AM

How to prevent wasted space on a table

469 Views

I am running a SAP Solution Manager 7.1 on Sybase ASE 15.7.0.110. The InfoCube table /BI0/F0SMD_PE2H keeps on growing quickly. This wasn't the case on other RDBMS. The ATM job doesn't help. Also running the ATM job manually doesn't change the table size:

reorg compact [SMP.SAPSR3./BI0/F0SMD_PE2H]


Only if I use the rebuild option, the table size shrinks:

reorg rebuild [SMP.SAPSR3./BI0/F0SMD_PE2H]


This causes the InfoCube with 1 million rows to shrink from 8 GB to 400 MB. That was an awful lot of wasted space.

Is it possible to avoid this excessive growth? Looks like the daily data load is causing the table to grow quickly again.

Or should I try to perform this "reorg rebuild" via the weekly ATM job?


Regards,

Mark