Hi,

I'm new to Informix so sorry if this is a dumb question:

After creating or removing a new table partition, is it necessary to take a level 0 backup? Ideally I'd like to take a level 0 once or twice a week and use level 1 and level 2 backups in between. However, as we partition by day I'm concerned that we will require a level 0 backup each day if adding a new partition invalidates the old level 0.

I've searched for an answer to this but cannot find anything - any help will be much appreciated.

We're using IBM Informix Dynamic Server Version 11.50.FC3

Thanks in advance,