Changing table properties

These steps are part of the larger task of altering a table. When you complete the steps for changing table properties, return to altering a table.

To change table properties when altering a table:

1. Optional: In the Validate routine field, type in a new name of the program to be used as the validation exit routine for the table. Validation routines are typically used to impose limits on the information that can be entered in a table; for example, allowable salary ranges.

   The new validation routine is not used to validate existing table rows. It is used only to validate rows that are loaded, inserted, updated, or deleted after the table is altered.

   You can also clear the Validate routine field so that a validation routine is no longer used on this table. Do not type NULL.

2. Optional: Use the Audit box to specify which types of access operations on this table will cause auditing to be performed. The default (None) specifies that no auditing is done when this table is accessed.

   Auditing is usually part of your overall security plan for keeping your DB2 system secure. You can use auditing to determine if attempts are made to gain unauthorized access to the table and who accessed the table data.

3. Optional: Select or clear the Restrict on drop check box to indicate whether DB2 should prevent the table from being dropped. If this check box is selected, the table can be dropped only after it is altered again to remove the restriction. In addition, the database and table space that contain the table cannot be dropped while the restriction is in place.
4. Optional: Select or clear the Data capture check box to indicate whether whether extra information regarding SQL changes to this table will be written to the log. If this table is replicated, the Data capture check box should be selected.

5. Optional: In the Comment box, type a new 1- to 254-character description for this table or edit the existing comment.