beautypg.com

HP NonStop G-Series User Manual

Page 199

background image

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004

14-7

2. To change the lock length, enter the new number in the Lock length

field.

3. Enter the maximum number of extents in the Max Extents field.

4. Enter the date and time after which the table can be purged in the

NoPurgeUntil field.

5. Enter the table code in the Table Code field.

6. Enable or disable audit by clicking on Audit.

7. Enable or disable audit compression by clicking on Audit Compress.

8. Enable or disable the buffered option by clicking on Buffered.

9. Enable or disable the clear-on-purge option by clicking on Clear On

Purge.

10. Enable or disable the reset-broken option by clicking on Reset Broken.

11. Enable or disable serial writes by clicking on Serial Writes.

12. Enable or disable the verified-write option by clicking on Verified

Write.

Partitions

The name of partitions for the altered index is displayed in the Partitions
pane.

Save the Index

To save the modified index attributes, 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.