Utility: watch_csv2

The watch_csv2 is provided to monitor the CSV2 scheduling process, much like the web/CLI status display. Unlike the status display, watch_csv2 must be run on the CSV2 server and excutes configurable commands and SQL statements periodically to produce a fine-grained monitoring status. The utility is run as a service to produce a log file of database snapshots taken once every ten seconds (also configurable) and saved within /var/log/cloudschedler/watch_csv2.log.

The utility can also be run interactively for one of the following purposes:

  • To monitor the real-time status.
  • To replay the log files created by the watch_csv2 service.
  • To rotate watch_csv2 log files.
  • To map watch_csv2 log files.

When monitoring real-time status or replaying log files, watch_csv2 uses curses to create a fullscreen, interractive display rather like the top command. Functions are provide to move backward and foward within log files and to search for specific events.

Synopsis:

To monitor the real-time status:

watch_csv2

To replay the log files created by the watch_csv2 service:

watch_csv2 --replay

For all other options, use the command:

watch_csv2 --help

Configuration

watch_csv2 has two types of configuration:

  1. Configuration items within the database:
    • category=watch_csv2, key=config_file - specifies the file containing the commands and SQL statements to be excuted (see below). These commands will be issued perioducally in a loop and the results displayed either interractively or saved within a log file. By default, this file is …/cloudscheduler/etc/watch_csv2.conf.
  • category=watch_csv2, key=log_file - specifies the log file where the watch_csv2 service is to to save monitoring data. By default, this file is /var/log/cloudscheduler/watch_csv2.logging.
  • category=watch_csv2, key=sleep_time - specififies, in seconds, the sleep time between loop iterations. The default is 10 seconds.

  1. Command and SQL statement configuration within the watch_csv2 configuration file must adhere to the following rules:

    • All commands and SQL statements must end with a semi-colon (“;”).
    • All commands must be valid system commands.
    • All SQL statements bust be valid select statements for the CSV2 database and CSV2 user.

    A standard configuration file, …/cloudscheduler/etc/watch_csv2.conf, is provided with the distribution. Please refer to that file and the database schema documentation for more information.