A structure-only baseline is a baseline that captures only data structure definitions.
You can use the following items to create a structure-only baseline:
- Db2 catalog
- DDL file
- Migrate-type worklist
You specify a baseline profile each time that you create a baseline. The baseline profile determines how the baseline is named and how many baselines are maintained. When you create a baseline, you have the option to delete other baselines that are created with the same profile.
Warning
Some types of modifications can cause loss of data if you use a structure-only baseline for recovery. For example, if a table column is dropped after a structure-only baseline is created, recovering to that structure-only baseline does not restore data for the dropped column. The only method that you can use to restore data is to create a full-recovery baseline (with data) instead of the structure-only baseline. Other types of modifications, like creating new indexes or storage groups, do not cause loss of data when a structure-only baseline is used for recovery.
Note
Authorizations are not restored when you use a structure-only baseline in the recovery process. To view the authorizations that are included in the baseline, generate a baseline report. You cannot import the baseline report as a DDL file to restore the authorizations; you must re-create the authorizations manually.
This section contains the following topics: