User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 12-13
Display Dependencies
Before altering a table, you can analyze the impact of the changes on other
objects:
• To display all programs that depend on the table, click on
Dependent Programs.
• To display all objects, including programs, that depend on the
table you want to modify, click on Objects.
Change File Attributes
Use the File Attributes pane to change the file attributes of a table.
To change a table’s file attributes
1. To change extent allocation, perform one of the following:
To allocate extents, click on Allocate, then enter the number of extents
in the Allocate field.
To de-allocate unused extents, click on Allocate to remove the
checkmark.
2. Enter the lock length in the Lock Length field.
3. Enter the maximum number of extents in the Max Extents field.
4. Enter the date and time that the table cannot be purged until in the
NoPurgeUntil field.
5. Enter the numeric 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 buffered disk writes by clicking on Buffered.
9. Enable or disable clear-on purge by clicking on Clear On Purge.
10. Enable or disable field label broken flag by clicking on Reset Broken.
11. Enable or disable serial writes by clicking on Serial Writes.
12. Enable or disable verified writes by clicking on Verified Write.
13. Enable or disable similarity check by clicking on Similarity Check.