Owner manual

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 12-13
1. In the Catalogs field, click on the name of the catalog that contains the
table you want to modify. The tables in the selected catalog are
displayed in the Tables field.
2. In the Tables field, click on the table you want to modify. The attributes
for the selected table are displayed.
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.