m 6.0+)

Contentsxiv

Display Dependencies ................................................................................... 14-10

Assign the New Name...................................................................................14-11

Managing Index Comments...............................................................14-11

Choose an Index...........................................................................................14-12

Add, Change, or Delete Index Comments...................................................... 14-12

Save the Index Comment .............................................................................. 14-12

Viewing Index Statistics....................................................................14-13

CHAPTER 15. MANAGING TABLE PARTITIONS ..................... 15-1

Designing Table Partitions.................................................................. 15-1

Choose Base Table .........................................................................................15-2

Choose Table Partition....................................................................................15-2

Choose Partonly..............................................................................................15-3

Manual Design................................................................................................15-3

Auto Design....................................................................................................15-3

Manual Design................................................................................... 15-3

Automatic Design............................................................................... 15-5

Display Dependencies .....................................................................................15-6

View Partitions................................................................................... 15-6

Choose Base Table .........................................................................................15-7

Assign Sample Rate ........................................................................................15-7

Compute Row Distribution .............................................................................15-7

Adding Partitions................................................................................ 15-7

Assign the Number of Partitions......................................................................15-8

Assign Volumes..............................................................................................15-8

Assign Catalogs ..............................................................................................15-9

Assign File Attributes.................................................................................... 15-10

Display Dependencies ................................................................................... 15-10

Add the Partitions......................................................................................... 15-10

Altering Partitions .............................................................................15-11

Display Dependencies ................................................................................... 15-12

Alter the Partitions........................................................................................15-12

Drop Partitions..................................................................................15-12

Choose Partition:.......................................................................................... 15-13

Display Dependencies ................................................................................... 15-13

Drop the Partitions........................................................................................15-13

Perform a Simple Move.....................................................................15-14

Choose a Table .............................................................................................15-14

Select the Partition........................................................................................15-15

Assign Name and Location............................................................................ 15-15

Assign File Attributes.................................................................................... 15-16

Display Dependencies ................................................................................... 15-16

Move the Partition........................................................................................ 15-16