Altering table attributes

To alter the attributes of a table:

Procedure

  1. Log on to the MXDM.
  2. In the Navigation tree pane, click Database.

    MXDM displays a list of available systems in My Systems.

  3. Expand a selected system in the navigation tree.

    List of catalogs for the selected system appears.

  4. Click and expand the contents of a Catalog.

    The list of schemas appears.

  5. Expand a schema in the left pane.

    The Tables folder appears.

  6. Expand the Tables folder and select a table in the left pane.
  7. Right-click the table and select Alter Table and then Attributes from the context menu.

    Alter Attributes dialog appears.

  8. The following attributes appear in the Alter Attributes dialog:

    • Audit Compress: This attribute controls whether unchanged columns are included in audit records.

    • Clear On Purge: This attribute controls the disk cleanup when a table is dropped. If Clear On Purge is selected, then the contents of the table are overwritten when it is purged. Otherwise, NonStop SQL/MX deallocates disk space but does not physically destroy the data in that disk space.

    • Maximum Extents for every partition: This attribute sets the maximum number of extents for all of the partitions. All the table partitions will have this maximum extents value.

    • Allocate/Deallocate for every partition: This attribute allocates the specified number of extents for all partitions if Allocate is selected, or deallocates all extents from all partitions if Deallocate is selected.

  9. Select or clear the required attributes and click OK to alter the selected table.