IBM 000-8697 Manual De Usuario

IBM Informix OnLine Database Server Administrator’s Guide

From the command line, execute tbstat -d to obtain information that is
similar to that displayed by the Dbspaces menu, Info option. However, where

DB-M

onitor lists total pages and the number used, tbstat -d lists total pages

and, in the

bpages

 field, the approximate number of free blobpages.

The tilde (~) that precedes the

bpages

 value indicates that this number is

approximate because it is derived from the information stored in the disk
version of the chunk’s free-map page, not the version of the free-map page
stored in shared memory.

Another complication is that tbstat -d does not register a blobpage as
available until the logical log in which a blob deletion occurred is backed up
and the blobpage is freed. Therefore, if you delete 25 blobs and immediately
execute tbstat -d, the newly freed space does not appear in the tbstat output.

Refer to

 for further information about the tbstat -d display.

From the command line, you also can obtain an accurate picture of the
amount of available space in a blobspace, by executing tbcheck with the -pB
options. This utility gathers its data from the actual blob-storage statistics.

Execute tbcheck -pB with either a database name or a table name as a
parameter. The display reports the following statistics:

■

Number of blobpages used by this table or database in all blobspaces

■

Blobpage fullness, by blob, for each blob in this table or database

P

Primary chunk.

R

Chunk is currently being recovered.

X

New mirror chunk that contains logical log files; a level-0 archive is
needed before the mirror can become active.

 (2 of 2)