I am thinking that this might depend on the volume of data in the table which has the container addition. You could export the data and load it to a new tablespace with additional containers without impacting your users. Ensure the table is in the same schema and name it slightly different, like _new. Then rename the table when you're done loading. For an MPP db this can be done in parallel and can be fairly optimized, again, depending on the volume of data.