master database only
sysdevices contains one row for each tape dump device, disk dump device, disk for databases, and disk partition for databases. There are four entries in sysdevices in the Adaptive Server distribution media: one for the master device (for databases), one for a disk dump device, and two for tape dump devices.
The columns for sysdevices are:
Name |
Datatype |
Description |
|---|---|---|
low |
int |
Not used for dump devices – First virtual page number on database device |
high |
int |
Last virtual page number on database device or dump device |
status |
smallint |
Bitmap indicating type of device, default and mirror status. See Table 12-7. |
cntrltype |
smallint |
Controller type:
|
name |
sysname |
Logical name of dump device or database device |
phyname |
varchar(127) |
Name of physical device |
mirrorname |
varchar(127) |
Name of mirror device |
The bit representations for the status column, shown below, are additive. For example, “3” indicates a physical disk that is also a default.
Decimal |
Hex |
Status |
|---|---|---|
1 |
0x01 |
Default disk |
2 |
0x02 |
Physical disk |
4 |
0x04 |
Not used – Logical disk |
8 |
0x08 |
Skip header |
16 |
0x10 |
Dump device |
32 |
0x20 |
Serial writes |
64 |
0x40 |
Device mirrored |
128 |
0x80 |
Reads mirrored |
256 |
0x100 |
Secondary mirror side only |
512 |
0x200 |
Mirror enabled |
1024 |
0x400 |
Master device is mirrored |
2048 |
0x800 |
Used internally – Mirror disabled |
4096 |
0x1000 |
Used internally – Primary device needs to be unmirrored |
8192 |
0x2000 |
Used internally – Secondary device needs to be unmirrored |
16384 |
0x4000 |
UNIX file device uses dsync setting (writes occur directly to physical media) |
