![]() |
|||
![]() |
![]() ![]() |
![]() |
![]() ![]() |
![]() |
![]() ![]() |
![]() |
| ||
Chapter 7Other Administrative TasksThis chapter describes how to use files and scripts to add or modify grid engine system objects such as queues, hosts, and environments. This chapter includes the following sections: Gathering Accounting and Reporting StatisticsThe grid engine system provides two kinds of reporting and accounting facilities:
Report Statistics (ARCo)You can use the optional Accounting and Reporting Console (ARCo) to generate live accounting and reporting data from the grid engine system and store the data in the reporting database, which is a standard SQL database. ARCo supports the following SQL database systems:
ARCo also provides a web-based tool for generating information queries on the reporting database and for retrieving the results in tabular or graphical form. ARCo enables you to store queries for later use, to run predefined queries, and to run queries in batch mode. For more information about how to use ARCo, see Chapter 5, "Accounting and Reporting," in N1 Grid Engine 6 User's Guide. For information about how to install ARCo, see Chapter 8, "Installing the Accounting and Reporting Console," in N1 Grid Engine 6 Installation Guide. Raw reporting data is generated by sge_qmaster. This raw data is stored in a 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. About the dbwriter ProgramThe dbwriter program performs the following tasks:
When dbwriter starts up, it calculates derived values. dbwriter also deletes outdated records at startup. If dbwriter runs in continuous mode, dbwriter continues to calculate derived values and to delete outdated records at hourly intervals, or at whatever interval you specify. You can specify in an XML file the values that you want to calculate and the records that you want to delete. Use the -calculation option of the dbwriter command to specify the path to this XML file. For detailed information about calculating derived values, see Calculating Derived Values With dbwriter. For detailed information about deleting outdated records, see Deleting Outdated Records With dbwriter. Enabling the Reporting FileThe reporting file contains the following types of data:
When the grid engine system is first installed, the reporting file is disabled. To use ARCo, you must enable the reporting file for the cluster. Once enabled, the reporting file will be generated by sge_qmaster. By default, the reporting file is located in sge-root/cell/common. You can change the default with the -reporting option of the dbwriter command. For information about configuring the generation of the reporting file, see the reporting_params parameter of the sge_conf(5) man page, and the report_variables parameter of the sge_host(5) man page. To enable the reporting file with QMON, on the Main Control window click the Cluster Configuration button, select the global host, and then click Modify. On the Cluster Settings dialog box, click the Advanced Settings tab. In the Reporting Parameters field, set the following parameters:
To enable the reporting file from the command line, use the qconf -mconf command to set the reporting_params attributes, as described in the preceding paragraph. Once the reporting file is enabled, the dbwriter can read raw data from the reporting file and write it to the reporting database. For more information about configuring the reporting file, see the reporting(5) man page. For complete details about installing and setting up ARCo, see Chapter 8, "Installing the Accounting and Reporting Console," in N1 Grid Engine 6 Installation Guide. | ||
| ||
![]() |