The ARCo web console mentioned below depends on a proprietary web server and is not supported in the free distribution. It may be possible to make it work under Tomcat or similar, but it is normally recommended to use the reporting database with your own query interface or the arcorun command line tool. Only the dbwriter component is currently distributed as a binary as it isn't clear whether or not arcorun can be run with free Java libraries. Note that support for the MySQL backend has been removed since the licence (GNU GPL) of its database connector is not compatible with the ARCo licence (SISSL).

Accounting and Reporting Console (ARCo)

The optional Accounting and Reporting Console (ARCo) enables you to gather live reporting data from the Grid Engine system and to store the data for historical analysis in the reporting database, which is a standard SQL database.

Raw reporting data is generated by sge_qmaster. This raw data is stored in the $SGE_ROOT/$SGE_CELL/common/reporting file. The dbwriter program reads the raw data in the reporting file and writes it to the SQL reporting database, where it can be accessed by ARCo.

ARCo supports the following SQL database systems:

The dbwriter provides functionality that helps you to manage your database size, by specifying Derived Values and Deletion Rules.

ARCo also provides a web-based tool, which contains a set of predefined SQL queries, supplementing the most frequent statistical inquiries. You can modify these queries or create your own. While creating your own SQL queries, you have a choice to use either the Simple Query builder (suitable for SQL novices) or the Advanced Query generator. You can specify if you want to display the data in a tabular, graphical, or pivotal form. You can export the data in CVS or PDF form, or store the result for later viewing. You also have the ability to run ARCo queries in a batch mode using the arcorun utility.

A description how to build ARCo from source can be found here and additional hints concerning setup and installation issues can be found in the following FAQ.

The Oracle documentation for ARCo is currently the most comprehensive.