Kbase P16862: How to find out the utilization of a database extension .
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/06/2008 |
|
Status: Unverified
GOAL:
How to find out the utilization of a database extension .
GOAL:
What is the utilization of the current database extention ?
FIX:
To find out the utilization of a database extension use prostrct statistics:
prostrct statistics <db name>
The first section of the statistics report should look something like this:
Storage Utilization Statistics
Database: sports
Primary data block size: 4096
BI block size: 8192
AI block size: 8192
Look for the Database Block usage area to gather information about specific areas, for example:
Files in Area: Schema Area
C:\PROGRESS\WRK_91c\db\sports.d1 851968
Database Block Usage for Area: Schema Area
Active blocks: 204
Empty blocks: 4
Extent blocks: 1
Total blocks: 208
Records/Block: 32
The line (C:\PROGRESS\WRK_91c\db\sports.d1 851968) tells that the total size of the extension area sports.d1 is 8519689(6656).
The first part of the report showed that the data block size is 4096 or 4k.
The total number of blocks is 208.
204 blocks are active. Multiply the number of active blocks by the block size 204 x 4096 = 835584 (816k) are used.
Since there are 4 empty blocks, use the same math to find the available space. 4 x 4096 = 16384 (16k) is available.