Sybase 12.5.1, Руководство пользователя

Страница: 91 / 210

CHAPTER 4 Command Reference
User’s Guide
77
• Filter count
• The
hs_list
command returns the following field as a float datatype:
• Alarm value
• All other fields are returned as character strings.
• If a session was recorded with the
private
protection level and the
current user is not the Historical Server superuser, the current user’s
name and password are verified against the name and password of the
user who recorded the session before that session is made visible.
Description of returned data
The data returned by
hs_list
depends on the value of level:
•
sessions
causes a single row to be returned for each session, with the
following columns:
• Session ID (a unique identifier for the session)
• Status of the session:
• active
• inactive
• active remotely or inactive – status of the session cannot be
determined unambiguously. Sessions that are currently
active in another instance of Historical Server that is using
the same home directory as the current instance fall into this
category. (For more information about running multiple
instances of Historical Server and sharing control files, see
“Configuring multiple instances of Historical Server” on
page 23.) Sessions that have already ended because of an
abnormal termination of the Historical Server instance that
was running them, and whose intended end times have not
yet been passed, are also in this category.
• Name of the user who initiated the recording session
• Name of the Adaptive Server monitored
• Name of the Monitor Server used
• Start date and time of the recording session
• End date and time of the recording session
• Directory containing the recorded data