DBS_USED_THRESHOLD

onconfig.std
value

None

if not present

100

range of values

1 to 100

takes effect

When shared memory is initialized.

refer to

onutil ALTER DBSLICE ADD DBSPACE, ALTER DBSPACE , CREATE DBSLICE and CREATE DBSPACE.

DBS_USED_THRESHOLD is the default used space threshold given to new dbspaces if no THRESHOLD value is specified in the onutil command. This parameter also sets the used space threshold for the root dbspace when the server is first initialized.

The threshold value represents the percentage of the total space in the dbspace which, once used, triggers an alarm, with the following message written to the message log:

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

The alarm is 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 reset the used space threshold for any dbspace at any time. See onutil ALTER DBSPACE .

Threads allocating extents in the dbspace are unaware of the threshold and receive no errors or warnings if it is exceeded.

Setting the threshold of a dbspace to 100 effectively disables the alarm for that dbspace.

To modify the DBS_USED_THRESHOLD parameter dynamically, use the onutil SET command. Example:

% onutil
1> SET DBS_USED_THRESHOLD 85;