Previewing the contents of an uploaded data definition file
When you load a data definition file, you can preview the changes contained in the file before you commit the changes to the database. The data definition preview reveals various details about an uploaded data definition.
The preview allows you to see the updates present in the file and make modifications before you commit the updates. The predefined color coding allows you to tell the allocation state at a glance. In the following figure, the color pink indicates that the area's partitions are not allocated.
The data definition file preview includes the following information:
Data Definitions — A treeview list of the contents of the data definition file, along with a notation about which objects in the file have changed, and in what way. The notation can be ADD, DELETE, or MODIFY, or a combination of these, and appears after the object name in the display.
Only those multi-tenant objects that require or are affected by partition assignments appear in the treeview, since those are the only objects you can modify in the console. (However, any and all changes that are included in the data definition file are uploaded.) Consider the following typical updates, how the updates affect partition assignments, and how the updates will appear in the treeview list:
The addition of a table requires partition information for each tenant; therefore, the name of the new table appears in the list and is followed by ADD.
A data definition file might drop and re-add an index in order to change the fields that the index comprises. In such an instance—in which two actions relate to one object—both actions follow the object (the index name, for example) and are separated by a comma, as in DELETE,ADD.
Any changes to LOB fields are listed. Changes to any other type of field do not appear in the treeview since they do not affect partitioning.
A deleted object is shown with the notation DELETE.
An object whose details change (other than ADD or DELETE) is marked by the notation MODIFY.
The drop of a table, index, or LOB field is shown, since the drop causes a removal of partition information from the database. In this case, the name of the table, index, or LOB field is followed by DELETE.
Areas Assignments — A list of current storage area assignments for each object of the selected tenant as well as each area for any area assignment referenced by a schema object. You can select multiple partitions, and simply drag them from one area and drop them on another area.
Properties —Details about a schema object you select in the Data Definitions treeview or a partition object you select in a storage area.
When you select a schema object, details can include:
Name — The name of the object selected in the treeview list
Default area — The area assigned
Multi-tenant — Whether the object is enabled for multi-tenancy
Keep default area — Whether to keep the data in the default tenant upon upload
Tenant partition area — The area where the tenant partition resides
Allocation state — The partition allocation status, which identifies whether space has been allocated for the partition and/or when it will be allocated
For a sequence, the following details appear:
Name — The name of the sequence
Multi-tenant — Whether the sequence is enabled for multi-tenancy. (If it is, the check box is selected.)
Initial value — The current value of the sequence.
Increment by — A positive or negative integer value with which you want to change the sequence value at each increment.
Sequence minimum value — An integer value that represents the lower limit of the sequence.
Upper limit — An integer value that represents the upper limit of the sequence.
Cycle at Limit — Whether a cycling sequence has been activated (true) or not (false)
When you select a partition object, details include:
Name — The name of the object selected in the area
Type — The type of object (table, LOB field, index)
Area — The area where the object resides
Buffer Pool — The chosen buffer pool, either primary or alternate.
Allocation state — The partition allocation status, which identifies whether space has been allocated for the partition and/or when it will be allocated
Tenants — A list of tenants in alphabetical order. By default, the first tenant is selected. If you have viewed the tenant already, a green indicator appears in the upper-left corner of the tenant name. If you have altered the tenant through the loading of a data definition file, a red indicator appears instead in the upper-left corner of the tenant name.
Data Definitions — A treeview list of the contents of the data definition file, along with a notation about which objects in the file have changed, and in what way. The notation can be ADD, DELETE, or MODIFY, or a combination of these, and appears after the object name in the display.