Kbase P122896: What is the number displayed after the tty device name in the _connect-device field of the _connect
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/25/2009 |
|
Status: Verified
GOAL:
What is the number displayed after the tty device name in the _connect-device field of the _connect VST table?
GOAL:
What does the number shown after the tty device name in the _connect-device field of the _connect VST table indicate?
FACT(s) (Environment):
UNIX
OpenEdge 10.x
Progress 9.x
FIX:
The Database Administration guide describes the _connect-device field in the _connect VST as such:
_Connect-Device
CHARACTER
Device from which the user has connected to the database.
If a user is connecting from a tty session on a UNIX box and is connecting as a remote client using -H localhost, the tty device will have a trailing number. The trailing number is in fact the tty session number. If the name of the tty device is long enough, the number may not show in a query of the field. In such cases, specify a format length for the query display. For example
For each _connect.
Display _connect._connect-device format "x(24)".
End.
This will display a list of devices, including those tty devices connecting using -H localhost:
ux-pos-dv03 11
ux-pos-dv03 8
ux-pos-dv03 74
ux-pos-dv03 batch
ux-pos-ts05
?