Kbase 20256: How to Use the Proutil Truncate Area Utility
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/09/2005 |
|
Status: Unverified
GOAL:
How the enhanced proutil truncate area utility functions?
FACT(s) (Environment):
Progress 9.1B
FIX:
Some functionality you should consider before using this command.
The truncate area option as implemented on Version 9.1B is designed to fast-delete the contents of an area to allow for a fast dump / load process, or to delete an entire table if the table were in an area by itself.
This option resets the high water mark of the area, recreates empty index root blocks for indexes in the area being truncated, and recreates any template records in the new area.
The truncate area is an option of the PROUTIL command:
proutil db-name -C truncate area [area-name]
Before you use the truncate area option, consider the following:
- If you do not specify an area name, all the empty areas will be truncated. An empty area is defined as an area with no objects in it. This is the bahavior on releases prior to 9.1B.
- New on 9.1B, if you specify a particular area name, the area will be truncated regardelss if it contains objects. Before the confirmation, the truncate area command shows all the tables and indexes that reside in that area.
- If the tables within the area that is going to be deleted have indexes in other areas, those indexes will be marked as inactive.
- The truncate area command forces the truncate BI command on the database.
- The database must be off-line and with AI disabled in order to run the command.
- You cannot truncate the schema area (Area 6).
Before you execute the truncate area command, make sure you have a valid backup of the database. There is no way to undo the truncate area operation.