Informix : New partition = Level 0 backup

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by reykjavik1972 0n 17 December 2008

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

Learn more about informix databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting