3.3

Increasing Database Space for Immediate Use
51
To obtain a hogs report on the entire database, type:
hogs .
To send a hogs report to yourself, type:
NRCS-A# sh
# hogs . | mail <your username> &
n
For more examples on how to use the hogs command, see “hogs” on page 133.
Using dbserver and dbfree to Obtain Information
To obtain an accurate idea of how much space is being used by stories in the system:
1. Empty out the Dead queue and reclaim all space used in it. Type:
dbserver 16000000
n
You must run dbserver when other programs like dbpurge are not running.
2. The next day, or after completion, run the dbfree program to see how much space is
being devoted to functions in your newsroom you consider critical.
3. Repeat this process from time to time, so you are aware of trends in space usage.
Use the information to make decisions on projected storage needs, and how space is
used.
Increasing Database Space for Immediate Use
If your database has not reached the “Low on Space” point, but you want to increase free
space for immediate use, do the following:
To increase free space for immediate use:
1. Type the command that appears on bold:
NRCS-A$ dbfree
database size 16,386,300 free 1,746,564 = 11%, freelist 1,493
The dbfree command—used by a system operator or a superuser—displays database
size, free list size, and percentage of remaining database available. The freelist number
indicates how many database blocks are used to hold the free list. The free list is
compressed. This results in anywhere from 250 to 5,000 free-block numbers contained
in each free list block. In this example, 1,493 blocks are used to hold the 1,746,564 free
block numbers. That is an average of 1,169 free block numbers per free list block.