Owner manual

Managing Index Partitions16-20
Assign Primary-Key Values
Use the Primary-Key pane to specify primary-key values for both partitions.
To assign primary-key values
1. In the Column Name field, choose a column of the primary key by
clicking on the name from the list of column names.
2. Place the cursor in the First Key field for the selected column and enter
the value for that column.
3. Repeat Steps 1 and 2 for all other columns of the primary-key.
Display Dependencies
Before performing a two-way move, you can analyze the impact of the
changes:
• To display the programs which depend on the partitions, click
on Dependent Programs. Programs which would be invalidated
by moving the partitions are displayed.
• To display all objects, including programs, which depend on the
index partitions, click on Objects. All SQL objects which
depend on the index partitions are displayed.
Move the Partition
To perform the two-way move, 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.