HP NonStop G-Series User Manual

Page 199

Advertising
background image

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

14-7

Change Security

To change the security of an index, use the drop-down lists in the R, W, E,
and P fields in the Security pane. You cannot change the owner ID or
group ID of an index.

Change File Attributes

You can changes any of the attributes in the File Attributes pane.

To change the file attributes of an index

1. To change extent allocation, perform one of the following:

To allocate extents, click on Allocate, then enter the initial number
of extents in the Allocate field.

To deallocate unused extents, click on Allocate to remove the
checkmark.

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.

Advertising