The data from Historical Server is in the same format as defined when the view from the view table was created on the Adaptive 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 Adaptive Server, 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 or 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.
