beautypg.com

HP Integrity NonStop H-Series User Manual

Page 16

background image

Contents

xvi

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

Performing a One-Way Split............................................................. 15-17

Choose Table ................................................................................................ 15-17
Assign Name and Location............................................................................ 15-17
Assign File Attributes.................................................................................... 15-18
Display Dependencies ................................................................................... 15-18
Move the Partition ........................................................................................ 15-19

Performing a Two-Way Split ............................................................ 15-19

Choose Table ................................................................................................ 15-20
Assign Names and Locations......................................................................... 15-20
Assign File Attributes.................................................................................... 15-20
Assign Primary-Key Values........................................................................... 15-21
Display Dependencies ................................................................................... 15-21
Move the Partition ........................................................................................ 15-21

CHAPTER 16.

MANAGING ENSCRIBE ...................................... 16-22

Designing Enscribe Partitions ........................................................... 16-22

Choose Enscribe Table.................................................................................. 16-22
Auto Design.................................................................................................. 16-23

Monitor Enscribe Partitions .............................................................. 16-24

CHAPTER 17.

MANAGING INDEX PARTITIONS .................... 17-24

Designing Index Partitions ................................................................ 17-24

Choose Base Index ......................................................................................... 17-2
Choose Index Partition.................................................................................... 17-2
Choose Partonly.............................................................................................. 17-3
Manual Design................................................................................................ 17-3
Auto Design.................................................................................................... 17-3

Manual Design ................................................................................... 17-4

Automatic Design ............................................................................... 17-5

Display Dependencies ..................................................................................... 17-5

View Partitions................................................................................... 17-5

Choose Index................................................................................................. 17-6
Assign Sample Rate ........................................................................................ 17-6
Compute Row Distribution ............................................................................. 17-6

Adding Partitions................................................................................ 17-7

Assign the Number of Partitions...................................................................... 17-7
Assign Volumes .............................................................................................. 17-7

This manual is related to the following products: