systabstats  systimeranges

Chapter 1: System Tables

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 logical pages.

status

smallint

Bit 1 equals 1 for the log segment’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 null

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

currauth

varbinary(255) null

A bitmask 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.





Copyright © 2005. Sybase Inc. All rights reserved. systimeranges

View this book as PDF