We would like to have an option to set the allocation of a FS at a SG level to fast pre-allocation. We have large DMS temporary tablespaces that on a failover to our remote site, we rebuild from scratch.
when rebuilding a large DMS temp FS (800GB), it could take 20 -30 minutes and this delays our failover time.
|Who would benefit from this IDEA?||Anyone wih large DMS temp FS's who recrecrate on a failover from scratch.|
How should it work?
alter stogroup temp_sg fast_preallocation=on;
|Priority Justification||Currently, we have ext4 FS and they are all set to fast preallocation, which affects insert perfromance when the extents need to be allocated.|
|Customer Name||Howard Goldberg|
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