systhresholds

All databases

Description

systhresholds contains one row for each threshold defined for the database.

Columns

The columns for systhresholds are:

Name

Datatype

Description

segment

smallint

Segment number for which free space is being monitored.

free_space

int

Size of threshold, in 2K pages (4K for Status).

status

smallint

Bit 1 equals 1 for the logsegment’s last-chance threshold, 0 for all other thresholds.

proc_name

varchar(255)

Name of the procedure that is executed when the number of unused pages on segment falls below free_space.

suid

int

The server user ID of the user who added the threshold or modified it most recently.

currauth

varbinary(255)

A bit mask that indicates which roles were active for suid at the time the threshold was added or most recently modified. When the threshold is crossed, proc_name executes with this set of roles, less any that have been deactivated since the threshold was added or last modified.

Indexes

Unique clustered index On segment, free_space