The data from Historical Server is in the same format as defined when the view was created on the server. To store the data, Historical Server creates two system tables:
Sessions table provides a record of every recording session that used the output database.
Views table lists the views that were used by each recording session.
In addition to one table for each view that is output to the database, there are two system tables created in the Historical Server output database. These tables are:
The sessions table provides a record of every recording session that has used the output database.
The views table lists the views that were used by each recording session.
The table structures are similar to the structure of the output data files, where:
First column is the monitoring session ID.
Second column is the monitored server name.
Third column is a date/timestamp.
Subsequent columns per data item specified in the view definition.
This structure, for the date and timestamp, and the data items, is identical to the structure defined in the DDL scripts Historical Server provides when a bulk copy is executed on Historical Server data files into another Adaptive Server.
viewname is the name for the view,
truncated if necessary to conform to the file-naming conventions
of the current platform. On the Windows NT platform, the file name
is limited to thirty characters.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
