Change the Dbspace Usage Threshold

Home | Previous Page | Next Page Utility Reference > onutil: Check, Define, and Modify Storage Objects > ALTER DBSPACE >

Change the Dbspace Usage Threshold

THRESHOLD Clause:

|--THRESHOLD--percent-------------------------------------------|

Element	Purpose	Restrictions	Syntax
percent	The percentage of total space in the dbspace which, when used, triggers an alarm.	Value is between 1 and 100	Decimal or hexadecimal integer

The THRESHOLD value represents a percentage of the total space in the dbspace. Once that percentage of space has been allocated to database objects, the "used space percentage" for that dbspace has crossed its configured threshold. At that point the following message is written to the message log:

Warning: DBspace '<dbspace name>' is more than <threshold> percent full.

An alarm is also generated with a severity of 3 (Attention), a Class ID of 5 (Resource overflow) and a Tag ID of 4 (DBspace high water mark crossed).

You can view threshold information for all dbspaces on a coserver with the onstat -g hwm command.

Note:

The fullness of a chunk or dbspace is measured in terms of the allocated space, which may be unrelated to the actual amount of data within that space. For example, a table with a large EXTENT SIZE may allocate a 20 Megabyte initial extent in order to insert a single 4 byte row. But because those 20 megabytes are now unavailable for allocation or use by any other database object, they are considered "used" by the dbspace.

Usage

Use the onutil ALTER DBSPACE command with the THRESHOLD clause when you want the server to notify you if the Dbspace fills beyond a certain percentage.