Recently one huge table grew up and over-filled entire storage area (called AppData).
I spoke with developers and App-Support, all decided that we can safely purge 90+% of this table, so I did it.
But when I run "prostrct statistics" or query <select * from PUB."_AreaStatus">, it still shows that AppData area is full.
Database Block Usage for Area: AppData
Active blocks: 2619327
Data blocks: 2619272
Free blocks: 55
Empty blocks: 65
Total blocks: 2619392
Extent blocks: 3
Records/Block: 128
Cluster size: 64
Do you know how to really free this space without dumping and loading the table?
I spoke with developers and App-Support, all decided that we can safely purge 90+% of this table, so I did it.
But when I run "prostrct statistics" or query <select * from PUB."_AreaStatus">, it still shows that AppData area is full.
Database Block Usage for Area: AppData
Active blocks: 2619327
Data blocks: 2619272
Free blocks: 55
Empty blocks: 65
Total blocks: 2619392
Extent blocks: 3
Records/Block: 128
Cluster size: 64
Do you know how to really free this space without dumping and loading the table?