Sybase 12.5.1, User Manual

Page: 104 / 210

Overview of Historical Server data files
90
Historical Server
• Data file – each view in a recording session is represented by a data file.
The data file holds all of the samples collected for the view during the
session.
• Script file – when you define a recording session using the
hs_create_recording_session
command, the script_type parameter can
specify creation of a SQL script file. The script file defines a Adaptive
Server table for each view in the recording session.
You can use the bulk copy (
bcp
) utility to populate existing Adaptive Server
tables. If you are a UNIX user, you can put subsets of the fields into separate
Adaptive Server tables if you first invoke the
cut
utility to strip the desired
columns from the file.
Permissions on files
All of the historical monitoring data files for a given recording session are
stored in the same directory. This directory is, by default, the directory
specified by the
-D
parameter to the Historical Server start-up command. You
can override this default for a session when you create the session.
The user who starts Historical Server is the owner of the files that Historical
Server creates. The owner has read and write permission on the historical
monitoring files. If the data contained in an historical data file or error message
file is public rather than private, all users and groups have read permission.
General file format
All files use newline characters as end-of-record markers. The fields in each
file are variable-length and are separated by commas. All data is stored in
ASCII format, which is compatible with the Sybase bulk copy (
bcp
) utility.