master database only
sysusages contains one row for each disk allocation piece assigned to a database. Each database contains a specified number of database (logical) page numbers. Each disk piece includes the segments on the Adaptive Server distribution media, segments 0 and 1.
The create database command checks sysdevices and sysusages to find available disk allocation pieces. One or more contiguous disk allocation pieces are assigned to the database, and the mapping is recorded in sysusages.
The columns for sysusages are:
Name |
Datatype |
Description |
|---|---|---|
dbid |
smallint |
Database ID |
segmap |
int |
Bitmap of possible segment assignments |
lstart |
int |
First database (logical) page number |
size |
int |
Number of contiguous database (logical) pages |
vstart |
int |
Starting virtual page number |
pad |
smallint |
Unused |
unreservedpgs |
int |
Free space not part of an allocated extent |
crdate |
datetime |
Creation date |
