{section}
{column}
{livesearch:spaceKey=GridEngine}
[Sun Grid Engine Information Center|Home]
[Index]
----
h1. 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:
* PostgreSQL
* Oracle
* MySQL
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 that contains a set of predefined SQL queries. The predefined queries aupplement the most frequent statistical inquiries. You can modify these queries or create your own. To create your queries, you can use either the Simple Query builder (suitable for SQL novices) or the Advanced Query generator. You can 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 can also use the {{arcorun}} utility to run ARCo queries in a batch mode. For information about {{arcorun}}, see [arcorun|ARCo Configuration Files and Scripts#arcorun]. For more information about how to use ARCo, see [Starting the Accounting and Reporting Console]. For information about how to install ARCo, see [Installing ARCo].
If you have multiple clusters, one {{dbwriter}} installation per cluster is needed, but only one Reporting installation is needed for all clusters.
For more information, see these topics:
* [ARCo Configuration Files and Scripts]
* [Installing ARCo]
* [Upgrading ARCo]
* [Creating Cross-Cluster Queries]
* [Derived Values and Deletion Rules]
* [Starting the Accounting and Reporting Console]
* [ARCo Frequently-Asked Questions]
* [ARCo Troubleshooting]
* [Database Schemas]
!printer.png|alt="Printer Icon"! To print this section, see the [Printable Accounting and Reporting Console Guide|Printable Accounting and Reporting Console Guide].
----
{column}
{section}
{column}
{livesearch:spaceKey=GridEngine}
[Sun Grid Engine Information Center|Home]
[Index]
----
h1. 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:
* PostgreSQL
* Oracle
* MySQL
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 that contains a set of predefined SQL queries. The predefined queries aupplement the most frequent statistical inquiries. You can modify these queries or create your own. To create your queries, you can use either the Simple Query builder (suitable for SQL novices) or the Advanced Query generator. You can 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 can also use the {{arcorun}} utility to run ARCo queries in a batch mode. For information about {{arcorun}}, see [arcorun|ARCo Configuration Files and Scripts#arcorun]. For more information about how to use ARCo, see [Starting the Accounting and Reporting Console]. For information about how to install ARCo, see [Installing ARCo].
If you have multiple clusters, one {{dbwriter}} installation per cluster is needed, but only one Reporting installation is needed for all clusters.
For more information, see these topics:
* [ARCo Configuration Files and Scripts]
* [Installing ARCo]
* [Upgrading ARCo]
* [Creating Cross-Cluster Queries]
* [Derived Values and Deletion Rules]
* [Starting the Accounting and Reporting Console]
* [ARCo Frequently-Asked Questions]
* [ARCo Troubleshooting]
* [Database Schemas]
!printer.png|alt="Printer Icon"! To print this section, see the [Printable Accounting and Reporting Console Guide|Printable Accounting and Reporting Console Guide].
----
{column}
{section}