database(ASCDB). The
following is a brief description of what was done to the data retrieved
from the ASCDB and how to regenerate the logs as they appear in the
PostgreSQL DB.
First step is to retrieve the logs from tape(or the ASCDB).
This done, we will assume that the logs have been placed in a directory
structure such that each subdirectory contains all of the logs from a
single day and that the subdirectory is named for that day, i.e. logs from
Jan 01 are in subdirectory 001/.
Next, the user should call my_itdb_loop.csh script for each subdirectory. Calling syntax is my_itdb_loop.csh 041/ /home/ascds/ITDB/xss.itdb, where the first argument is the subdirectory and the second directory is the ASC format file for converting the binary log to an ascii file. Note that the ASC format file can vary from day to day. There is a list of the days and their appropriate format files in fmt.txt.
Note that this step results in the logs being ingested into the PostgreSQL DB and that the xss_desc.rdb file is used to define the table attributes.
Now it is necessary to split the monolithic xsslog into its 14 constituent tables. This is done by running the SQL queries found in create_xss_subsets.sql and fill_xss_subsets.sql.