beautypg.com

Reorganizing key-sequenced files – HP NonStop G-Series User Manual

Page 144

background image

Using FUP for Advanced File Management

Guardian User’s Guide 425266-001

8- 22

Reorganizing Key-Sequenced Files

Reorganizing Key-Sequenced Files

The FUP RELOAD command physically reorganizes a key-sequenced file or SQL
object (table or index only) while allowing shared read/write access to the file or object.
Reloading a file improves the access time and use of space for a key-sequenced file or
SQL object that has undergone a large number of insertions, deletions, and updates. To
reload a file called PAYFILE, enter:

The RATE option controls the amount of processor time the reload operation uses. A
value less than 100 prevents the reload operation from monopolizing the processor and
its resources. For more information about FUP RELOAD and its other options, see the
File Utility Program (FUP) Reference Manual.

-RELOAD PAYFILE, RATE 40

This manual is related to the following products: