Sybase 12.5.1, User Manual

Page: 111 / 210

CHAPTER 5 Data Files
User’s Guide
97
• 5 – Monitor Server
• Error message text
For more information about error message fields, refer to the Reference
Manual.
Script file
If the value of the script_type parameter of the
hs_create_recording_session
command is
sybase_script
, a script file is created for the session. The name of
the script file is ssessionid where sessionid is the unique identifier for the
session.
Script file table names
The script file contains the text of create table commands, one command per
view defined for the session. The name of each table is
sSessionId_viewnumber_viewname where:
• s is a constant.
• SessionId is the unique identifier for the session.
• viewnumber is a number greater than or equal to one that reflects the order
in which views were defined for the session.
• viewname is the user-supplied name for the views, truncated if necessary
to conform to the limitations on the lengths of Adaptive Server identifiers.
Script file table column names
The first column defined for each table contains the sample timestamp field. It
is always named “Timestamp” and has the
datatime
datatype.
The names of the remaining table columns are derived from the data items that
they represent. Each column name is dataitemname_stattype where:
• dataitemname is a compressed form of the data item’s name.
• stattype is an abbreviated form of the data item’s statistic type.