master database only
syslisteners contains a row for each network protocol available for connecting with the current Adaptive Server. Adaptive Server builds syslisteners dynamically when a user or client application queries the table.
The columns for syslisteners are:
Name |
Datatype |
Description |
|---|---|---|
net_type |
char(32) |
Network protocol |
address_info |
char(255) |
Information that uniquely identifies this Adaptive Server on the network; usually the name of the current Adaptive Server and an identifying number, such as the server’s port number for the protocol |
spare |
tinyint |
Unused |
nodeid |
tinyint null |
Reserved for future use (not available for cluster environments) |
instanceid |
tinyint |
ID of the instance (available only for cluster environments) |
