A cron job runs daily at a fixed interval (1:00 a.m. by default). The script generates a series of files containing the data for the time period since the previous interval and then removes that data from the database. The generated data files are then collected into a compressed tar file that is placed into the backup directory (/data/export).
A field in the VSM GUI Site Configuration allows changes to the interval setting.
The data files are laid out in a fashion similar to the data as it is presented within the VSM GUI application. They are created in a tab-delimited format that can easily be read into Excel or any other spreadsheet-type client application.
In each of the above file names, the timestamp portion follows the same pattern, specifying the system time when the process started. For example, the date November 27, 2016 at 2:46:17 pm would become 2106-11-27.14.46.17 in the final file name. The name of the compressed tar file also includes a timestamp, so based on the above date, the file would be named 2106-11-27.14.46.17-dbBackup.tar.gz.
The generated files containing the off-loaded data are as follows:
AUDIT SUMMARY: YYYY-DD-MM.HH24.MI.SS-AUDIT-SUMMARY_VIEW.dat
Data Fields: Command ID, Process ID, Audit Type, Tapeplex, VTSS Name or MVC Volser, Reason, and Number of VTVs Audited.
CLI LOG: YYYY-DD-MM.HH24.MI.SS-CLI-LOG_VIEW.dat
Data Fields: Command ID, Submitted, Username, Tapeplex, Host, Command Type, Command, Status, Competed, Exception, Return Code, and Reason Code.
COMMAND LOG: YYYY-DD-MM.HH24.MI.SS-COMMAND-LOG_VIEW.dat
Data Fields: Command ID, Submitted, Username, Tapeplex, Host, Command Type, Command, Status, Completed, Exception, Return Code, and Reason Code.
CONSOLE ACTIONS: YYYY-DD-MM.HH24.MI.SS-CONSOLE-ACTION_VIEW.dat
Data Fields: ID, Tapeplex, Server Address, Token, Type, Routing/Descriptor Category, Line Number, Multi-line Type, Text, State, and Time.
CONSOLE LOG: YYYY-DD-MM.HH24.MI.SS-CONSOLE-LOG_VIEW.dat
Data Fields: ID, Tapeplex, Server Address, Token, Type, Routing/Descriptor Category, Line Number, Multi-line Type, Text, State, and Time.
MESSAGE RESPONSES: YYYY-DD-MM.HH24.MI.SS-MESSAGE-RESPONSE_VIEW.dat
Data Fields: Tapeplex, Server Address, Token, Return Code, Reason Code, and Error Message.
MVC DRAIN RECALL/MIGRATE SUMMARY: YYYY-DD-MM.HH24.MI.SS-MVC-DRAIN-SUMMARY_VIEW.dat
Data Fields: Command ID, Tapeplex, MVC Volser, Reason, and VTVs Recalled/Migrated.
MVC DRAIN RECALL/MIGRATE INFORMATION: YYYY-DD-MM.HH24.MI.SS-MVC-DRAIN_VIEW.dat
Data Fields: Command ID, Tapeplex, VTV Volser, Recalled From MVC Volser, Recalled From Block ID, Recalled From VTSS, Migrated To MVC Volser, Migrated To Block ID. and Migrated To VTSS.
RECLAIM RECALL/MIGRATE SUMMARY: YYYY-DD-MM.HH24.MI.SS-RECLAIM-SUMMARY_VIEW.dat
Data Fields: Command ID, Tapeplex, MVC Volser, Reason, and VTVs Recalled/Migrated.
RECALL RECALL/MIGRATE INFORMATION: YYYY-DD-MM.HH24.MI.SS-RECLAIM_VIEW.dat
Data Fields: Command ID, Tapeplex, VTV Volser, Recalled From MVC Volser, Recalled From Block ID, Recalled From VTSS, Migrated To MVC Volser, Migrated To Block ID, and Migrated To VTSS.
COMMAND LOG: YYYY-DD-MM.HH24.MI.SS-COMMAND-LOG_VIEW.dat
Data Fields: Command ID, Tapeplex, MVC Volser, Reason, and VTVs Recalled/Migrated.
RECONCILE RECALL/MIGRATE INFORMATION: YYYY-DD-MM.HH24.MI.SS-RECONCILE_VIEW.dat
Data Fields: Command ID, Tapeplex, VTV Volser, Recalled From MVC Volser, Recalled From Block ID, Recalled From VTSS, Migrated To MVC Volser, Migrated To Block ID, and Migrated To VTSS.
RECONCILE VTV REASONS: YYYY-DD-MM.HH24.MI.SS-RECONCILE-VTV_VIEW.dat
Data Fields: Command ID, Tapeplex, VTV Volser, Uncompressed Size (MB), Compressed Size (MB), Compression Percentage, Created, Management Class, and Reason.
USER ACTIVITY LOG: YYYY-DD-MM.HH24.MI.SS-USER-ACTIVITY-LOG_VIEW.dat
Data Fields: Username, Event Type, File Type, Tapeplex, File Name, and Time.
Note:
There may be other files generated that have a lower-case name (for example,YYYY-MM-DD-hh.mm.ss-command_log.dat) and zero length. These files should be ignored.