Owner manual

Managing Table Partitions15-12
4. Enter the maximum number of extents in the Max Extents field.
5. Enable or disable the Reset-Broken flag by clicking on Reset Broken.
Display Dependencies
Before altering partitions to a table, you can analyze the impact of the
proposed changes:
• To display the programs which depend on the table, click on
Dependent Programs. Programs which would be invalidated by
adding partitions are displayed.
• To display all objects, including programs, which depend on the
partitions, click on Dependent Objects. All SQL objects which
depend on the table partitions are displayed.
Alter the Partitions
To alter the partitions for the table, click on one of the following:
• Execute. Executes the command immediately.
• Show. Displays the SQL commands created by dba/m Database
Manager without executing them.
• Queue. Queues the command to be submitted in a batch later.
Drop Partitions
To drop partitions from a table, click on Table Partitions in the Main
window, then click on Drop. The Drop Partitions window will appear as
displayed in Figure 15-8.