master database only
sysengines contains one row for each Adaptive Server engine currently online.
The columns for sysengines are:
Name |
Datatype |
Description |
|---|---|---|
engine |
smallint |
Engine number |
osprocid |
int |
|
osprocname |
char(32) |
Operating system process name (may be NULL) |
status |
char(12) |
One of: online, in offline, in create, in destroy, debug, bad status |
affinitied |
int |
Number of Adaptive Server processes with affinity to this engine |
cur_kpid |
int |
Kernel process ID of process currently running on this engine, if any |
last_kpid |
int |
Kernel process ID of process that previously ran on this engine |
idle_1 |
tinyint |
Reserved |
idle_2 |
tinyint |
Reserved |
idle_3 |
tinyint |
Reserved |
idle_4 |
tinyint |
Reserved |
starttime |
datetime |
Date and time engine came online |
nodeid |
tinyint null |
Reserved for future use (not available for cluster environments) |
instanceid |
tinyint |
ID of the instance (available only for cluster environments) |
