Progress
Database Administration
Guide and Reference
PROUTIL TRUNCATE AREA Qualifier
Deletes all the tables and indexes in the specified storage area.
SYNTAX
db-name
Specifies the database that contains the application data storage areas that you want to truncate.
area-name
Specifies the name of the storage area you want to truncate. When you specify the area name, PROUTIL truncates the area even if it contains storage objects. If no area name is specified, PROUTIL truncates all areas not containing objects.
NOTES
- Use of this qualifier is an important step in removing application data storage areas and extents from a database.
- Deleting the contents of storage areas with this feature also allows for rapid dumping and loading. Use PROUTIL with the TRUNCATE AREA qualifier after dumping data, but before initiating the load.
- Before using PROUTIL with the TRUNCATE AREA qualifier, remove all tables and indexes from the application data storage areas you want to truncate.
- PROUTIL with the TRUNCATE AREA qualifier works by resetting the hi-water mark in the storage area back to the beginning of the storage area. This hi-water mark reset frees all of the space in the storage area for re-use. Any tables and indexes in the storage areas are initialized to the state they were in before they contained any rows or index entries. Before resetting the hi-water mark, the before image (.bi) file is truncated.
- To use this command, the database must be off-line and after imaging must be disabled.
- If the storage area does not contain any storage objects, then the command simply resets the hi-water mark. If the storage area does contain tables and or indexes, their names are listed and you must confirm to truncate the storage area.
- Indexes in other storage areas that are on tables in the storage area being truncated are marked as inactive.
- Empty index root blocks for indexes in the area being truncated are recreated.
- PROUTIL with the TRUNCATE AREA qualifier re-creates any template records in the new area.
NOTE: The schema area cannot be truncated.For more information, see the "Progress Structure Remove Utility" section in Maintaining Database Structure."
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |