10. Click Save or Save As to save your View configuration to the query 11 Click Run to run your query.
2.28 ARCo Configuration Files and Scripts
ARCo Configuration Files and Scripts
2.28.1 About dbwriter
The dbwriter component writes and deletes the reporting data in the reporting database. It performs the following tasks:
■ Reads raw data from the reporting file and writes this raw data to the reporting
database.
■ Calculates derived values. You can configure which values to calculate, as well as
the rules that govern the calculations.
■ Deletes outdated data. You can configure how long to keep data.
The sge_qmaster component generates the reporting file. You can configure the generation of the reporting file.
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. See Derived Values and Deletion Rules. You can specify in a XML file the values that you want to calculate and the records that you want to delete. The path to this file is specified during installation. To change the path to the file, edit the DBWRITER_CALCULATION_FILE parameter in the
dbwriter.conf file.
2.28.1.1 inst_dbwriter Command Options
The inst_dbwriter script, used for installing dbwriter, is located at $SGE_ ROOT/dbwriter and supports the following options:
■ -nosmf - Disables SMF for Solaris 10+ machines. Instead the regular RC scripts are used.
■ -upd - Removes old RC scripts not containing the SGE_CLUSTER_NAME and starts the installation. This option must be used if you are upgrading from version prior to 6.2.
■ -rmrc - Removes 6.2 RC scripts or SMF service.
■ -h - Prints usage text to stdout.
If no option is specified, installation is started.
2.28.1.2 dbwriter Configuration Parameters
During dbwriter module installation, the following configuration parameters are collected. These parameters are stored in the $SGE_ROOT/$SGE_
CELL/common/dbwriter.conf file. Changes to the dbwriter.conf file require restarting the dbwriter.
Table 2–2 dbwriter Configuration Parameters
Parameter Description Sample Value
DBWRITER_ USER_PW
Password of the database user with the write privileges
password
DBWRITER_USER Name of the database user with the write privileges; this user will become the owner of the database objects that will be created.
ARCo Configuration Files and Scripts
2.28.1.3 sgedbwriter Command Options
The sgedbwriter script, used for starting and stopping dbwriter, is located at
$SGE_ROOT/$SGE_CELL/common and supports the following sub-commands:
■ start - Starts the dbwriter as a background process. If no options are supplied, this is the default behavior. You can supply three options with the start command:
■ -debug - Start the dbwriter in debug mode. This allows you to attach a debugger.
■ -debug_port port-number - Specify a port to use for debugging. The default is 8000.
■ -nosmf - Force no SMF
READ_USER Name of the ARCo read user; This user will be granted SELECT privileges on the objects owned by the user specified above, and on Oracle it is also used to create synonyms.
arco_read
DBWRITER_URL JDBC URL to database jdbc:postgresql ://host.domain: 5432/arco DB_SCHEMA Name of the database schema for the
objects
public TABLESPACE Tablespace used for storing tables pg_default TABLESPACE_
INDEX
Tablespace used for storing indexes pg_default DBWRITER_
CONTINOUS
Continuous running mode; Default value is true
true DBWRITER_
INTERVAL
Interval in s for continuous; Default value is 60 seconds
60 DBWRITER_
DRIVER
JDBC driver name org.postgresql.
Driver DBWRITER_
REPORTING_ FILE
File name of reporting file /myroot/opt/sge 62/default/comm on/reporting DBWRITER_
CALCULATION_ FILE
File containing calculation rules /myroot/opt/sge 62/dbwriter/dat abase/mysql/dbw riter.xml DBWRITER_SQL_
THRESHOLD
The dbwriter writes a warning into the log file if the execution of a single statement takes longer then the DBWRITER_SQL_ THRESHOLD. The threshold is specified in seconds. If the threshold is 0, no warning will be written.
0
SPOOL_DIR Spool directory of the dbwriter log files and pid file is stored in this directory
/myroot/opt/sge 62/default/spoo l/dbwriter DBWRITER_
DEBUG
Debug level. Valid values are: WARNING, INFO, CONFIG, FINE, FINER, FINEST, ALL
INFO
Table 2–2 (Cont.) dbwriter Configuration Parameters
ARCo Configuration Files and Scripts
■ stop - Stops the dbwriter process.
■ printsetting - Prints the specified dbwriter setting to stdout. The following settings are available:
■ pid_file - Prints the default pid file
■ log_file - Print the default log file
■ spool_dir - Print the default spool directory
■ -h - Prints usage text to stdout.
The content environment variable JVMARGS is treated as options for the Java virtual machine. If $JAVA_HOME is, set the Java virtual machine at $JAVA_HOME/bin/java
is started.
2.28.2 About Reporting
The reporting file contains the following types of data:
■ Host load values and consumable resources ■ Queue consumable resources
■ Job logging ■ Job accounting ■ Share-tree usage
■ Advance reservation logging ■ Advance reservation accounting
Enabling Generation of the Reporting File
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/$SGE_CELL/common. The path to the file is stored in the DBWRITER_ REPORTING_FILE parameter of the dbwriter.conf file.
Once the reporting file is enabled, the dbwriter can read raw data from the reporting file and write it to the reporting database.
For complete details about installing and configuring ARCo, see Installing the Accounting and Reporting Console (ARCo).
How to Enable Generation of the Reporting File From the Command Line To enable reporting from the command line, use the qconf -mconf command to set the reporting_params attributes, as described in the last step of How to Enable Generation of the Reporting File With QMON.
How to Enable Generation of the Reporting File With QMON
1. To enable reporting with QMON, on the QMON Main Control window click the