Kbase P22837: How to determine the total blocks used for 8.X database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/1/2004 |
|
Status: Unverified
GOAL:
How to determine the total blocks used for 8.X database?
FACT(s) (Environment):
Progress 8.x
FIX:
There are three ways to determine the total number of database blocks used in a version 8.X database.
Method 1
Database is Offline: Use the "prostrct statistics dbname" command, under Database Block Usage Summary "Active blocks" lists the number of blocks used.
Method 2
Database is Online: Use the "promon dbname" command, Option 7 "Database status", "Database blocks high water mark" lists the number of blocks used.
Method 3
Connecting to the database using a Progress Client and querying the VST (virtual system tables):
find first _DBStatus.
_DbStatus-HiWater.