Add at the 'DEFRAGMENT' SQL Api , the option to defragment an entire dbspace.
We have set in our environment tables and partitions with historical data, so, they are tables or partitions who have any changes (include/excluded data).
Most of them are set in the same dbspace and from time in time, we remove the oldest, opening a few gaps of free space over the firsts chunks of the dbspace. These dbspace are made of few chunks and we want to move all data to the firsts and remove the last chunks to recover disk space.
Why is it useful?
|Who would benefit from this IDEA?||The business of the company , because will reduce the maintenance stop time.|
How should it work?
The command shouldn't care about the number of fragments of the tables, they only should move all fragments together, where should be only an I/O work.
For certain situations will allow reducing space utilization. Mainly after certain maintenance like compressing tables, data movement, and purge of data.
Today, as far I know, there is no plausive or usable workaround unless export/move all data to another place and then back with it.
|Priority Justification||This is a feature which we need to use frequently|
|Customer Name||Cesar Martins|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions